Support site for Simplebim users
In This Topic
    Export to Excel
    In This Topic

    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 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
    ON Set format of headers to bold and right align numeric values (default)
    OFF Do not format any cells. This can be considerably faster than formatting the cells.
    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