Report > Report Assembly Interfaces > IPrxReportExporter > IPrxReportExporter.ExportHiddenCells

IPrxReportExporter.ExportHiddenCells

Syntax

ExportHiddenCells: Boolean;

Description

The ExportHiddenCells property determines whether hidden rows and columns should be exported when exporting a report to XLS (*.xls) and ODS (*.ods) files.

Comments

If this property is set to True, hidden columns/rows (if any) are exported and the user can work with them using Microsoft Excel tools; if this property is set to False, the hidden areas are not exported.

The default property value is True.

Example

The following example assumes that there is the Report object with the IPrxReport type.

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.ExportHiddenCells := False;
    Exp.ExportToFile("C:\Report.xls", "xls");
End Sub UserProc;

After executing the example the output file displays no hidden rows or columns.