Question

谁知道delphi中调用OLEexcel后可以对其执行哪些操作？

Answer 1

例如：var xl:variant; xl:=createoleobject('excel.application');之后，我能在delphi中对这个excel表做些什么，比如做一个报表什么的。关键是我该怎么做。最好有过程、函数和相应的说明，或者告诉我哪里有专门的书或者资料。谢谢！

Answer 2

You need to work with an OleVariant to hold the connection withthe OLE server:var Excel: OleVariant;...Excel:= CreateOLEObject('Excel.Application');Excel.WorkBooks.Add;The creation of a WorkBook is opening 16 worksheets by default. So you canaccess singles cells:Excel.Worksheets['Sheet1'].Cells[1,1].Value := 99;Excel.Worksheets['Sheet1'].Cells[1,1].Font.Size := 12;or on whole areas:Excel.Range['A1,H10'].Formula := 'rand()';Excel.Worksheets['Sheet1'].Range['A1:D5'].Font.Size := 12;