You are here: Visual LANSA User Guide > 4. Editor Features > 4 5 Import Excel Worksheets

4.5 Import Excel Worksheets

Use Import Excel Worksheets to load worksheets from an Excel Workbook into LANSA tables.

This feature is only available on machines that have the appropriate driver to support for Excel 12.0 installed. See 4.5.1 Installing the Driver.

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 to the data from the Excel worksheet.

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