In your recent reply saying what you wanted to do, you noted that you hoped to read Excel data (and thank you for providing a sample data file). The Report Generation Toolkit was designed for producing a Report, i.e. for writing Excel.
But don't worry -- you can also use it to read Excel -- it is just a little more work. New Report has an input marked "Template" -- any Excel (.xls or .xlsx) file placed here will be read. If you have a Normal Window, you'll actually see Excel open and show you the data.
Excel Read Data is on the Excel Specific/Excel General Palette. This function wants to read either Strings or Numerics (read its Help entry). There's a function that will tell you how many Rows are in the Spreadsheet (provided you don't clear any rows -- it gets the Count from Excel), but there is no analogous function to tell you how many columns there are. You may need to play a bit (what sometimes works is to read into a 2D array of strings, and use the size of the Strings to tell you how many rows and columns there are). The Read Data function lets you specify what area of the Excel Spreadsheet you want to read, so if you have a Header Row and the rest of it is data, you can just "read the data" (in a second Read, of course).
Bob Schor
