IExAnalyzerExporter.Sheet

Fore Syntax

Sheet: IEaxSheet;

Fore.NET Syntax

Sheet: Prognoz.Platform.Interop.Express.IEaxSheet;

Description

The Sheet property export selected express report sheet.

Comments

When the property value is not empty, only the selected express report sheet is exported, otherwise all the sheets are exported.

Fore Example

Executing the example requires an express report with the EXPRESS_REPORT identifier.

Sub UserProc;
Var
    MB: IMetabase;
    Eax: IEaxAnalyzer;
    Exporter: IExAnalyzerExporter;
Begin
    MB := MetabaseClass.Active;
    Eax := MB.ItemById("EXPRESS_REPORT").Edit As IEaxAnalyzer;
    Exporter := New ExAnalyzerExporter.Create;
    Exporter.Sheet := Eax.ActiveSheet;
    Exporter.ExportToFile("C:\Temp\EXPRESS_REPORT.xls", "xls");
End Sub UserProc;

After executing this example only active sheet of the express report is exported.

 Fore.NET Example

Executing the example requires an express report with the EXPRESS_REPORT identifier.

Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Express;

Public Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Eax: IEaxAnalyzer;
    Exporter: IExAnalyzerExporter;
Begin
    MB := Params.Metabase;
    Eax := MB.ItemById["EXPRESS_REPORT"].Edit() As EaxAnalyzer;
    Exporter := New ExAnalyzerExporterClass();
    Exporter.Sheet := Eax.ActiveSheet;
    Exporter.ExportToFile("C:\Temp\EXPRESS_REPORT.xls", "xls");
End Sub;

After executing this example only active sheet of the express report is exported.

See also:

IEaxSheet