Reading Excel files is another side of Excel file manipulation. It is equally important as file creation. Usage could vary from importing simple data to processing user-filled files like timesheets, purchase orders, etc.
In this recipe, we will use the file created in the previous recipe. We will read customer data using SysExcel classes and will show it on the screen.
In AOT, create a new class called ReadExcelFile with the following code:
class ReadExcelFile { } public static void main(Args args) { SysExcelApplication application; SysExcelWorkbooks workbooks; SysExcelWorkbook workbook; SysExcelWorksheets worksheets; SysExcelWorksheet worksheet; SysExcelCells cells; COMVariantType type; int row; CustAccount account; CustName name; #define.Filename('<documents>\\customers.xlsx') ; application = SysExcelApplication::construct...