ExportPalette: Boolean;
The ExportPalette property determines whether the palette is to be exported to Excel (*.xls) files. If the property is set to True, when objects are exported, the Excel color palette is replaced with the Prognoz Platform 9 palette; if the property is set to False, the Excel palette is recalculated based on the palette used in the platform.
The default property value is True.
The following example assumes that there is the Report object with the IPrxReport type.
Sub UserProc;
Var
Report: IPrxReport;
Exp: IPrxReportExporter;
Begin
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.
See also: