peXLSNewSheet - cDRReport ¶

Methods - Properties - Events

Type¶

Integer

Default¶

C_drNoSheets

Arguments¶

None

Description¶

This property controls if and when to create a new sheet in the XLS(X) file.

The possible values for this property are listed in New Sheet Options

Can be retrieved or set after the OCX is initialized.

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 peXLSNewSheet of oReport to C_drSheetsPage
            Send ExportReport of oReport C_drXLS 'c:\tmp\MyReportNewSheetPerPage.xls'
        End
    End_Procedure
End_Object

peXLSNewSheet - cDRReport¶