peXLSVersion - cDRReport¶
Methods - Properties - Events
Type¶
Default¶
C_drXLS2003
Arguments¶
None
Description¶
When the export to XLS there are two formats available. The value of this property must be one of the predefined constants
Can be retrieved or set after the OCX is initialized.
Related topics¶
- pbXLSAllPages
- piXLSColumnWidth
- pbXLSExportDataOnly
- pbXLSExportGroupSections
- pbXLSExportNativeDatatype
- pbXLSExportPageSections
- pbXLSExportReportSections
- peXLSNewSheet
- piXLSPage
DataFlex Framework Usage¶
- Web
- Windows
- FlexTron
Sample¶
Object oReport is a cDRReport
Set psReportName to 'MyReport.dr'
End_Object
Object oExportToXLSReportButton is a Button
Set Label to 'Export Report to XLS'
Procedure OnClick
String sReportId
Get OpenReport of oReport to sReportId
If (sReportId <> '') Begin
Set peXLSVersion of oReport to C_drXLS2007
Send ExportReport of oReport C_drXLS 'c:\tmp\report.xlsx'
End
End_Procedure
End_Object