Export Excel

TeeChart VCL for Borland/CodeGear/Embarcadero RAD Studio, Delphi and C++ Builder.
Post Reply
Menant.D
Newbie
Newbie
Posts: 19
Joined: Mon Jun 06, 2016 12:00 am

Export Excel

Post by Menant.D » Wed Nov 30, 2016 9:08 am

hi,

the Export to Excel doesn't work, we can't open the file.

Yeray
Site Admin
Site Admin
Posts: 9514
Joined: Tue Dec 05, 2006 12:00 am
Location: Girona, Catalonia
Contact:

Re: Export Excel

Post by Yeray » Wed Nov 30, 2016 10:15 am

Hello,

We implemented in v2016.19 a new way to export to xlsx for Excel > 2013 (in the ticket #1257).
It works as follows:

Code: Select all

uses TeeExcelSource;

procedure TForm2.Button1Click(Sender: TObject);
Var excelExp : TSeriesDataXLSObject;
begin
  excelExp := TSeriesDataXLSObject.Create(TCustomChart(Chart1));
  excelExp.IncludeIndex := true;
  excelExp.IncludeHeader:= true;
  excelExp.IncludeColors := true;
  excelExp.IncludeLabels := true;

  excelExp.SaveToFile('C:\tmp\excel.xlsx');
end;
Best Regards,
ImageYeray Alonso
Development & Support
Steema Software
Av. Montilivi 33, 17003 Girona, Catalonia (SP)
Image Image Image Image Image Image Please read our Bug Fixing Policy

Post Reply