ExportPalette: Boolean;
The ExportPalette property determines whether a palette is exported to an Excel file (*.xls).
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.
The property is set to True by default.
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.
See also: