XLS export options¶
The name of this structure is drXLSExportOptions. It is used by the DefaultXLSExportOptions and pXLSExportOptions
Obsolete¶
The struct is obsolete per version 26 as setting PDF export options is now done via properties and no longer passing a pointer to the struct
Struct layout¶
| Member | Type | Description | Default Value |
|---|---|---|---|
iXLSVersion |
Integer | One of the XLS Version constants | C_drXLS2003 |
iNewSheet |
Integer | One of the XLS New Sheet constants | C_drNoSheets |
iColumnWidth |
Integer | Width of a cell in the spreadsheet. Value between 5 and 999 | 20 |
bExportDataOnly |
Boolean | True if only the data should be exported. False if the report should be formatted | False |
bExportPageSections |
Boolean | True if the page sections (Page header and footer) should be exported | True |
bExportReportSections |
Boolean | True if the report sections (Report header and footer) should be exported | True |
bExportGroupSections |
Boolean | True if the group sections (Group 1-N headers and footers) should be exported | True |
bExportNativeDatatype |
Boolean | True to un-format the number value and pass the real value to Excel | False |
bAllPages |
Boolean | Export all pages or single page | True |
iPage |
Integer | Page number of single page to export | 1 |
Notes¶
- Defined in cDRAPI.pkg
- The member bExportWithFormatting has been renamed in version 26 to bExportNativeDatatype
Change of default settings¶
With the introduction of getters for export options the defaults for export setting is now the same between Studio and integration.
| Member | < 26.0 | >=26.0 |
|---|---|---|
iXLSVersion |
C_drXLS2007 |
C_drXLS2003 |
iColumnWidth |
30 |
20 |