Excel Plugins

Excel plugins will import data in the specified worksheet of an Excel file. Excel plugins support import/export to Excel Workbook (.xlsx) format. You will be able to import/export data from the Excel Workbook format even on a machine where Microsoft Excel is not installed.

See the Property Loader Plugins - File Formats topic for more information about the required file structure for this plugin.

Import Options

This plugin contains the following plugin-specific import options:

Worksheet — Specifies the name of the worksheet in the workbook containing the data to import.

Export Options

This plugin contains the following plugin-specific export options:

Worksheet — Specifies the name of the worksheet in the workbook to which to export the data.

File Format Type — Specifies the format in which the data should be exported. You can choose one of the following options:

• Default — Number of columns is not fixed. Ex: All the subproperties of a container will be specified in one line. The number of columns will grow as the number of subproperties.
• Flattened — Number of columns is fixed. A line will contain the lookup of the property along with its value.

Optional Information To Export — Specifies what optional information should be created in the property loader source. You can choose to export the following optional information:

• Sequence — Add the sequence information containing the sequence name.
• Type — Add the type information containing the type name of the property.
• Category — Add the Category information containing where the property exists. The information is not mandatory if all the property being exported contains alias names.