关于Delphi 5中Excel Server的用法
我看到一篇关于Excel Server用法的文章,有几点不明:
ExcelApplication1.Connect;
ExcelApplication1.Visible[0]:=True;
ExcelApplication1.Workbooks.Add(NULL,0);
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks[1]);
ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Sheets[1] as _WorkSheet);
for idx:=1 to 30 do begin
ExcelWorksheet1.Cells.Item[idx,1]:='Hello '+IntToStr(idx);
ExcelWorksheet1.Cells.Item[idx,2]:= idx;
end;
ExcelWorksheet1.Cells.Item[31,2]:='=SUM(B1:B30)';
ShowMessage('Total is '+ExcelWorksheet1.Cells.Item[31,2]);
ExcelApplication1.Disconnect;
ExcelApplication1.Quit;
1.ExcelApplication1.Connect是与什么连接,在哪儿指定要打开的Excel文件名呢?
2.怎么知道这些函数的接口,Delphi中又没有相关的HELP.