12-06-2011, 12:04 PM
ابومهند كتب :اذا مشت معك الطريقة نأمل ارفاق مثال لليستفيد منه الجميع.
أستعمل مكون scExcelExport +ExcelApplication
و هذا هو المثال المطلوب أخي:
PHP كود :
Var
MonClasseur : _workbook;
MaFeuille :_Worksheet;
MonGraph : _Chart;
MaSerie : Series;
MaCollSerie : SeriesCollection;
compteur:integer;
begin
try
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;
// Save worksheet
scExcelExport1.SaveAs(ExtractFilePath(Application.ExeName)+'ExcelExport.xls',ffXLS);
scExcelExport1.Disconnect;
scExcelExport1.LoadDefaultProperties;//export vers le fichier Excel
scExcelExport1.ExcelApplication.Connect;
MonClasseur:=scExcelExport1.ExcelApplication.Workbooks.Open(ExtractFilePath(Application.ExeName)+'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;
MonGraph.ChartType := xlLine;
MaCollSerie:=MonGraph.SeriesCollection(EmptyParam,0) as SeriesCollection;
MaSerie:=MaCollSerie.NewSeries;
scExcelExport1.CloseAllExcelApps;
except
on E : Exception do
showmessage('Microsoft Excel n'+'''a pas été installé ');
أدبني الدهر فأراني نقص عقلي وإذا ما ازددت علما زادني علما بجهلي

