This tool makes it possible to export data into a Excel file from a template or script. This tool can not be run from the Simplebim user interface, but the same functionality is available through Excel Export in the ribbon Home tab.
| Key |
FILE_NAME The full path including file extension for the new Excel file.´
The export will fail if this configuration is not given. In this case a message will be written into the log if logging is enabled.
|
||||
| Value | The extensions .xls and .xlsx are supported. Using .xls result in an older Excel 97-2003 Workbook that has a limit of 256 for the number of columns. In .xlsx the limit is 16 384. | ||||
| Key | FORMAT_OUTPUT | ||||
| Value |
|
||||
| Key |
DATETIME_FORMAT Defines the format for Date, Date Time and Time of Date properties |
||||
| Value |
|
||||
| Key |
ESCAPE_DATETIME Defines whether Date, Date Time and Time of Day properties should be escaped/pefixed with a apostrophe character. Prefixing a cell value with a apostrophe in Excel forces Excel to treat the value as text and turns off any automatic data type recognition that might otherwise apply. |
||||
| Value |
|
||||
Date and Time format examples:
| February 20th 2018 at 15:30:00 | DATETIME_FORMAT = CURRENT_CULTURE | DATETIME_FORMAT = IFC_STRING | ||||
| ESCAPE_DATETIME = OFF |
|
2018-02-20T15:30:00 |
||||
| ESCAPE_DATETIME = ON |
|
'2018-02-20T15:30:00 |
