This 'Multi Table Template' mode facilitates the users to create a valid empty Excel file that is suitable for the Multi Table Import facility. Each worksheets in this Excel file represents the PLE input tables. Names that are used for the worksheets are the ShortNames of PLE input tables.

There are three ways to create a valid empty Excel file:

➢ Select from menu File > Export > Template to Excel file...

Generate Excel Button On File

➢ Select from menu Tools > Tables > Template to Excel File...

Multi Table Button On Tool Generate

or,

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

Multi Table Button On Toolbar Generate

'Multi Table: Template' screen will be opened. This functionality consists of 2 steps: select  the tables and set the worksheets order. Nevertheless, the first step is sufficient to create the template. Default settings will be used for the worksheets order.

Click to expand/collapseStep 1: Select input table(s) to be created

A general working procedure about the tab Selection can be found in section Multi Table Selection.

To facilitate the users in selecting the input tables to be created, different input table icons are used to make distinction between empty and filled input tables in PLE:

Table is empty

Table contains data

Input table

Input Table Green Empty

Input Table Green Filled

Please note that only input tables are available in this mode. Other PLE data tables are hidden.

Select one or more input tables from PLE to be exported as empty tables in Excel worksheets.

Load Multi Table Definition

A general working procedure about loading a definition can be found in Multi Table Definition.

The following settings will be loaded into the 'Multi Table: Template' dialog screen depending on the selected definition type:

Selected definition type

Settings to be loaded:

•Selection, Options and Layout settings

•Selection and Layout settings

tab 'Selection': selected (input) tables and the 'Show Empty tables' option

tab 'Options': none

tab 'Layout': output sequence of the selected (input) tables

•Selection settings only

tab 'Selection': selected (input) tables only

tab 'Options': none

tab 'Layout': none
Click to expand/collapseStep 2: Set the tables (sheets) layout

A general working procedure about the tab Layout can be found in section Multi Table Layout.

Save the Current Multi Table Definition

A general working procedure about saving a definition can be found in Multi Table Definition.

Settings that will be saved in the 'Multi Table: Template' definition are:

1. Selection settings

settings of tab 'Selection' (selected (input) tables and the 'Show Empty tables' option)

2. Layout settings

settings of tab 'Layout' (output sequence of the selected tables)

Multiple_Tables_Generate (last modified: Sep 22, 2025)