Skip to content

StateDMI / Command / ReadPropertiesFromExcel

Overview

The ReadPropertiesFromExcel command reads cells from a Microsoft Excel worksheet and sets processor properties. This is useful when Excel is used to configure an analysis. The properties can be used directly by StateDMI for commands that support ${Property} notation or can be used to expand a template command file. Property object types are determined from Excel cell type/format unless the type is specified with command parameters. If issues arise, check the Excel cell type and format.

StateDMI uses the Apache POI software to read/write the Excel file and consequently functionality is constrained by the features of that software package. Check the StateDMI Help / About menu for information on the POI version.

Command Editor

The following dialog is used to edit the command and illustrates the syntax of the command. See also the full-size image.

ReadPropertiesFromExcel

ReadPropertiesFromExcel Command Editor for Excel Parameters

The following dialog is used to edit the command and illustrates the syntax of the command for Excel to properties map. See also the full-size image.

ReadPropertiesFromExcel Map

ReadPropertiesFromExcel Command Editor for Excel to Properties Map Parameter

The following dialog is used to edit the command and illustrates the syntax of the command for properties parameters. See also the full-size image.

ReadPropertiesFromExcel Properties

ReadPropertiesFromExcel Command Editor for Properties Parameters

Command Syntax

The command syntax is as follows:

ReadPropertiesFromExcel(Parameter="Value",...)

Command Parameters

Parameter                      Description Default                           
InputFile
required		 The name of the Excel workbook file (*.xls or *.xlsx) to read, as an absolute path or relative to the command file location. None – must be specified.
Worksheet The name of the worksheet in the workbook to read. Read the first worksheet.
KeepOpen Indicate whether to keep the Excel file open (True) or close after creating (False). Keeping the file open can increase performance because later commands will not need to reread the workbook. False
PropertyCellMap
required		 Indicate how to map property names to Excel addresses. The format of the parameter is:
PropertyName1:ExcelAddress1,
PropertyName2:ExcelAddress2,...
where the Excel addresses can be specified using A1 notation, named range, or * to use a named range that matches the property name. The property names cannot be repeated.		 None – must be specified.
BooleanProperties A list of property names to be defined as Boolean objects. Determine from Excel cell type and format.
DateTimeProperties A list of property names to be defined as date/time objects. Determine from Excel cell type and format.
IntegerProperties A list of property names to be defined as integer objects. Determine from Excel cell type and format.

Examples

See the automated tests.

Troubleshooting

See Also