Report > Report Assembly Interfaces > IPrxReportExporter > IPrxReportExporter.ExportHiddenSheets

IPrxReportExporter.ExportHiddenSheets

Syntax

ExportHiddenSheets: Boolean;

Description

The ExportHiddenSheets property determines whether hidden sheets should be exported when exporting a report to XLS (*.xls). If this property is set to True, the hidden sheets (if any) are exported and the user can work with them using Microsoft Excel tools; if this property is set to False, the hidden sheets are not exported.

The default property value is False.

Example

Executing the example requires that the repository contains a regular report with the OBJ_REPORT identifier.

Sub UserProc;
Var
    Mb: IMetabase;
    Report: IPrxReport;
    Exp: IPrxReportExporter;
Begin
    Mb := MetabaseClass.Active;
    Rep := Mb.ItemById("OBJ_REPORT").Bind As IPrxReport;
    Exp := New PrxReportExporter.Create;
    Exp.Report := Report;
    Exp.ExportHiddenSheets := True;
    Exp.ExportToFile("C:\Report.xls", "xls");
End Sub UserProc;

After executing the example the regular report is exported to the C:\Report.xls file including hidden sheets.