Support site for Simplebim users
Export to Excel

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.

Configuration Options

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 a 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

DATETIME_FORMAT

Defines the format for Date, Date Time and Time of Date properties

Value
CURRENT_CULTURE Exports date and time values using the format defined the Windows current culture settings of the computer. (default)
IFC_STRING

Exports date and time values using the format defined in the IFC4 specification

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
ON Escape the cell value
OFF Do not escape the cell value (default)

Date and Time format examples:

February 20th 2018 at 15:30:00 DATETIME_FORMAT = CURRENT_CULTURE DATETIME_FORMAT = IFC_STRING
ESCAPE_DATETIME = OFF
fi-FI

20.2.2018 15:30:00
20.2.2018
15:30

en-US

2/20/2018 3:30PM

2/20/2018

3:30PM

2018-02-20T15:30:00
2018-02-20
15:30:00

ESCAPE_DATETIME = ON
fi-FI

'20.2.2018 15:30:00
'20.2.2018
'15:30

en-US

'2/20/2018 3:30PM

'2/20/2018

'3:30PM

'2018-02-20T15:30:00
'2018-02-20
'15:30:00