header: pXLSExportOptions - cDRReport

states:
Procedure OnClick
drXLSExportOptions myExportOptions

Get OpenReport Of oReport To sReportId
// set the export options
Get DefaultXLSExportOptions Of oReport to myExportOptions
Move C_drXLS2007 to XLSExportOptions.iXLSVersion //not defined
Move C_drNoSheets to XLSExportOptions.iNewSheet
Move 30 to XLSExportOptions.iColumnWidth
Move False to XLSExportOptions.bExportDataOnly
Move True to XLSExportOptions.bExportPageSections
Move True to XLSExportOptions.bExportReportSections
Move True to XLSExportOptions.bExportGroupSections
Move False to XLSExportOptions.bAllPages
Move 1 to XLSExportOptions.iPage
Set pXLSExportOptions of oReport to myExportOptions

// exports the report to a file named MyReport.xlsx
Send ExportReport of oReport C_drXLS 'c:\tmp\MyReport.xlsx'
End_Procedure