DefaultXLSExportOptions - cDRReport ¶

Obsolete¶

Default values for XLS export are no longer code inside the cDRReport class but retrieved from the OCX. While you can still use the function and the struct it the usage is obsolete.

Method Type¶

Function

Arguments¶

None

Returns¶

drXLSExportOptions

Description¶

This function can be used to return a default set of XLS export options.

After retrieving the default set of options, one or more members can be changed.

The default initializes the members to:

Member	Value
`iXLSVersion`	C_drXLS2007
`iNewSheet`	C_drNoSheets
`iColumnWidth`	30
`bExportDataOnly`	False
`bExportPageSections`	True
`bExportReportSections`	True
`bExportGroupSections`	True
`bAllPages`	True
`bExportNativeDatatype`	False
`iPage`	1

DataFlex Framework usage¶

Web
Windows
FlexTron

Sample¶

Object oReport is a cDRReport
    Set psReportName to 'MyReport.dr'
End_Object

Object oExportReportButton is a Button
    Set Label to 'Export Report'

    Procedure OnClick
        String sReportId
        drXLSExportOptions XLSExportOptions

        Get OpenReport of oReport to sReportId
        If (sReportId <> '') Begin
            Get DefaultXLSExportOptions of oReport to XLSExportOptions
            Set pXLSExportOptions of oReport to XLSExportOptions
            Send ExportReport of oReport C_drXLS 'MyReport.xls'
            Send CloseReport of oReport sReportId
        End
    End_Procedure
End_Object

DefaultXLSExportOptions - cDRReport¶