You are here: What's New in LANSA Version 15 > Visual LANSA IDE Enhancements > Import Excel Worksheets

Import Excel Worksheets

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.

Each work sheet 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.

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