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 assumes that an object Report of the type IPrxReport exists.

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.