Report > Report Assembly Interfaces > IPrxReportExporter > IPrxReportExporter.ExportPalette

IPrxReportExporter.ExportPalette

Syntax

ExportPalette: Boolean;

Description

The ExportPalette property determines whether the palette should be exported to Excel (*.xls).

Comments

If the property value is True, when objects are exported, the Excel color palette is replaced with the Foresight Analytics Platform palette; if the value is False, the Excel palette is recalculated based on the palette used in Prognoz Platform.

The default property value is True.

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

When the regular report is exported, the palette is recalculated for Excel.