IExAnalyzerExporter.ExportPalette

Syntax

ExportPalette: Boolean;

Description

The ExportPalette property determines whether a palette is exported to an Excel file (*.xls).

Comments

If the property is set to 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.

By default the property is set to True.

Example

The example requires the Analyzer object of the IEaxAnalyzer type.

Sub UserProc;

Var

Mb: IMetabase;

Analazer: IEaxAnalyzer;

Exp: IExAnalyzerExporter;

Begin

exp := New ExAnalyzerExporter.Create;

exp.ExAnalyzer := Analazer;

exp.ExportPalette := False;

exp.ExportToFile("C:\Temp\Analazer.xls","XLS");

End Sub UserProc;

When the report is exported, the palette is recalculated to Excel.