problems with Excel

← →
yuriki (2002-10-23 12:31) [0]

Kak iz delphi postroit" graphik v Excel

← →
AME (2002-10-23 13:21) [1]

//Если через EXCEL сервера.Описание основных функций в Excel help

var IR1, IR2:Range;
begin
IDispatch(IR1) := ExcelWorksheet1.Cells.Item[1,1];
IDispatch(IR2) := ExcelWorksheet1.Cells.Item[20,20];//Набор данных
ExcelChart1.ConnectTo(ExcelWorkbook1.Charts.Add(EmptyParam,ExcelWorkbook1.Charts.Item[1],1,EmptyParam,LOCALE_USER_DEFAULT)as _Chart);

ExcelChart1.HasTitle[0]:=true;
ExcelChart1.ChartTitle[0].Text:="AAA "
ExcelChart1.Name:="BBB"
ExcelChart1.SetSourceData(ExcelWorksheet1.Range[IR1, IR2]);
ExcelChart1.ChartType:=xlLineMarkers;
ExcelChart1.HasLegend[0]:=false;
ExcelChart1.HasDataTable:=true;

problems with Excel Найти похожие ветки