Page History

An option has been added to the ribbon to support loading worksheets from an Excel Workbook into LANSA tables.

It is only available where the appropriate driver to support Excel 12.0 is installed. A message will be issued if you select this option without the appropriate driver installed.

• To import a worksheet, select Import Excel Worksheets from the Tools tab on the ribbon:
  

...

• 
  Image Added
  
  
• Choose the file to be imported.
  

...

• 
  Image Added

• Select the worksheets to be loaded as LANSA tables:
  

...

• 
  Image Added
  
  
  
• Verify the selected work sheets worksheets and columns which will be generated:
  

...

• 
  Image Added
  
  Each

...

• worksheet generates a LANSA table, the name/identifier/description of the table needs to be provided.  You can select to include all or a subset of the columns from the original worksheet definition.
  After the tables are generated and compiled, data will be copied into LANSA tables corresponding with the data from the Excel worksheet.

• Verify the table(s) have been created with expected columns and data copied into them: 
  

...

• 
  Image Added
  
  The temporary tables created during the import are automatically removed upon completion of the processing.