ITabSheetExporter.ExportHiddenCells

Syntax

ExportHiddenCells: Boolean;

Description

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

Comments

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

By default the property is set to True.

Example

This example is supposed to have the Report object of the IPrxReport type.

Sub UserProc;

Var

exp: ITabSheetExporter;

Report: IPrxReport;

Tab: ITabSheet;

Begin

Tab := (Report.Sheets.Item(0) As IPrxTable).TabSheet;

exp := New TabSheetExporter.Create;

exp.TabSheet := Tab;

exp.ExportHiddenCells := False;

exp.ExportToFile("C:\Temp\Tab.xls","XLS");

End Sub UserProc;

After executing the example, the resulting file displays no hidden rows/columns.