Excel Import and Export Command Window Interface
- Last UpdatedFeb 10, 2023
- 1 minute read
The Excel Import and Export Wizard provides a PML object (excelio) for batch processing of excel files. An instance of this object can be created at the command line as follows:
!e = object excelio()
The methods on this object are as follows
|
import('<filename>') |
This will make the best guess at mapping worksheets and columns to database structures. This should only be used where Worksheets are named to match Element Types and Columns are named to match database attributes. All changes identified in the import file will be applied to the database. |
|
import('<filename>','<configname>') |
This will use the specified configuration to import an Excel Workbook. All changes identified in the import file will be applied to the database. |
|
export('<filename>','<configname>') |
This will use a specified configuration to export an Excel Workbook. |
All methods return the following values to indicate the success of their operation:
-1 error
0 success
1 warning
The export example in this user guide can be achieved non-graphically using the commands below:
!e = object excelio()
!result = !e.export('C:\data\export.xls','ExportEquipmentAndNozzleConfiguration')