rtslink.com
Home / UDI-Magic / Tutorials
Introduction / Create an Excel sheet

Step 1: Create an Excel sheet


To begin with, let's create an Excel sheet with UNIT Master records.


Excel sheet with UNIT Master records

  • Start MS-Excel and Create a new Excel-file with few sample records.

  • Save the file as "Unit-master.xls" in the "C:\udi-Magic" folder.

  • Close MS-Excel.


Remarks:-
a) The 1st Row in the Excel sheet must contain HEADINGS. The Data
     must start from the 2nd Row.
b) udi-Magic stops processing records when it encounters a blank row or a
     hidden row. [Demo version processes limited records]
c) The Excel sheet must contain a column labelled as  "NAME" or "ID".
    This is required to uniquely identify records.
d) For other Columns, you can specify any Headings. However, it is
      advised that you specify concise and meaningful Headings.







Next Page : Write XML tags
Tally is a registered trademark of Tally Solutions FZ LLC.

Valid HTML 4.01 Transitional