When designing a new spreadsheet in Microsoft Excel that RPG2SQL will populate or read:
For example: Setting dates or month names at the top of each column of data and shifting the values depending on which month is current.
For example: Column headings, a part number, customer name, rep name, and so on.
Note: Always leave the first row of the spreadsheet template blank, unless you want to use row one for column names. Start placing data in row 2 instead.
For example: You may want to create a new spreadsheet template with worksheets for each month.
RPG2SQL will later user this named range to add or clear detail records within the spreadsheet. Think of a named range as a pre-defined detail area or single cell within a spreadsheet. A spreadsheet template can have multiple named ranges across multiple worksheets.
Still have questions? We can help. Submit a case to Technical Support.