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;

Rep: IPrxReport;

Exp: IPrxReportExporter;

Begin

Mb := MetabaseClass.Active;

Rep := Mb.ItemById("OBJ_REPORT").Bind As IPrxReport;

Exp := New PrxReportExporter.Create;

Exp.Report := Rep;

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.