1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| begin
scExcelExport1.LoadDefaultProperties;
scExcelExport1.FontData.Color := clBlack;
scExcelExport1.ExcelVisible:=False;
scExcelExport1.Dataset:=Table1;
scExcelExport1.WorksheetName:='APPELS_';
scExcelExport1.HeaderText.Text := 'STATISTICS';
scExcelExport1.BeginRowHeader := 1;
scExcelExport1.BeginRowTitles := 2;
scExcelExport1.BeginRowData := 3;
scExcelExport1.FontHeader.Size := 12;
scExcelExport1.FontHeader.Style := [fsBold];
scExcelExport1.AutoFilter := True;
scExcelExport1.ExportDataset;
scExcelExport1.SaveAs
(ExtractFilePath(Application.ExeName)+'ExcelExport.xls',ffXLS);
scExcelExport1.Disconnect;
scExcelExport1.CloseAllExcelApps;
scExcelExport1.ExcelApplication.Connect;
MonClasseur:=scExcelExport1.ExcelApplication.Workbooks
.Open('C:\Program Files\Borland\Delphi6\Projects\AnaLyZer\ExcelExport.xls',False,False,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,0);
scExcelExport1.ExcelApplication.Visible[0]:=true;
MaFeuille:=MonClasseur.Worksheets[1] as _worksheet;
MonGraph:=MonClasseur.Sheets.Add(emptyparam,emptyparam,1,xlChart,0) as _chart;
MaCollSerie:=MonGraph.SeriesCollection(EmptyParam,0) as SeriesCollection;
MaSerie:=MaCollSerie.NewSeries;
MaSerie.FormulaLocal:='=SERIE(;Feuil2!$A$2:$A$21;Feuil2!$B$2:$B$21;1)'; |
Partager