IPrxReportExporter.SheetAccess

Syntax

SheetAccess: Boolean;

Description

The SheetAccess property determines whether sheet and cell protection should be exported to XLS (*.xls) format. If the property is set to True, the protection is exported; if the property is set to False, it is not. The default property value is False.

Note that sheet protection in Microsoft Excel includes an empty password, even if the regular report contains a password for sheet protection.

Example

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

Sub UserProc;

Var

Report: IPrxReport;

Exp: IPrxReportExporter;

Begin

Exp := New PrxReportExporter.Create;

Exp.Report := Report;

Exp.SheetAccess := True;

Exp.ExportToFile("C:\Report1.xls","xls");

End Sub UserProc;

Sheets and cells protection is exported during the report export.