Home > Foresight Analytics Platform > Web Application and Desktop Application > Application Development and Functionality Enhancement > Developing in Development Environment > Description of System Assemblies > Report > Report Assembly Interfaces > IPrxReportExporter > IPrxReportExporter.SheetAccess

IPrxReportExporter.SheetAccess

Syntax

SheetAccess: Boolean;

Description

The SheetAccess property determines whether sheet and cell protection should be exported to XLS format (*.xls).

Comments

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

Sheets and cells protection is exported during the report export.