IExportSettings Properties

Return data in a canonical format. Default is false.

External CSS file to be linked with an HTML export. Location is the output path. Only applies to HTML exports. Default is empty (no CSSFile).

Use custom columnheaders.

Custom root node for Xml, Json, Excel.

Delete and recreate Excel file when exporting. Only applies to Excel. Default is true.

Data format the export engine should generate. Default is Xml.

Headermode, i.e. what to use for columnames (Text, Html, Excel) or nodenames (Xml, Json). Default is Fieldname.

Use headers on the first row in table-like exports (like Text, Html, Excel). Default is true.

Include additional connection information. Only applies to Json. Default is true.

Make dates return in ISO8601 format.

Maximum number of characters to retrieve from fields. This includes connected fields. The default is ~500.000, skabout five times the Commence default.

Only applies to Json. Splits connection information into distinct elements/nodes.

Specify the number of rows to export at a time. Default is 1024.

Include all connected items. Supported only for Xml, Json, Excel Overrides Canonical, ISO8601Format, SkipConnectedItems, SplitConnectedItems, ExcelUpdateOptions.

Read Commence data in an asynchronous way. Async can be slightly faster, but it depends on a number of things, such as NumRows and MaxFieldSize.

When you export to Excel or use PreserveAllConnections there is a performance gain.

Default is true.

Used in conjunction with Canonical, allows removal of the currency symbol that Commence will include when numeric fields were set to 'Display as currency' Default is false.

Ignore connected items.

Split connected values into separate nodes/elements. Only applies to Json and Xml. Default is true. If set to false, connected values are not split and you will get the data as Commence returns them.

Text-delimiter used in a Text export. Only applies to Text and Html exports. Default is tab character.

Text-delimiter used for connected values. Only applies to Text and Html exports. Default is newline character (same as Commence uses).

Text-qualifier. Only applies to Text and Html exports. Default is " (double-quote).

Make Commence use DDE calls to retrieve data. WARNING: extremely slow!

Include additional column holding the item's THID and return THIDs instead of Name field values for connected items. (XML and Json). For text-based exports, connected items are not returned as thids. Default is false.

Get serialized XML with a XmlSchema (XSD). Only applies to PreserveAllConnections in combination with Xml. Default is false.

Update options when exporting to Microsoft Excel. See ExcelUpdateOptions.