This Multi Table functionality provides Ple4Win users an ability to import data from an Excel file into Ple4Win input tables. Existing data in input tables will be overwritten unless the input tables are locked.

Please note, that the Excel file to be imported must be suitable for Ple4Win. This means:

data for each table must be on separate worksheets,

the worksheets must be named as table's ShortName, and

data must start at the 3rd row of each sheet.

Therefore, it is recommended to use the empty Excel input file generated by Ple4Win or Excel file created by Multi Table Export mode. This is to assure that a valid Excel file is used in this process.

There are 2 ways to call this Multi Table Import mode:

Select from menu File > Import > Tables from Excel file...

Import Excel Button On File

or,

Click on (the arrow next to) the 'Multi Table' Tools.MTable.16x16 button and select Import Excel 16 'Import from Excel File...'

Multi Table Button On Toolbar Import

Dialog 'Ple4Win: Import tables...' is shown. Select the Excel file, click on the Open button and the 'Multi Table: Import' screen will be appeared.

Info Please note, when importing prescribed values (fixed values presented in a dropdown box in Ple4Win) in 'shortname' format, these prescribed values must be in UPPERCASE.

Click to expand/collapseSelect the tables (sheets) to be imported

Last changed: 12/13/2019