form上添加三个控件:ExcelApplication、ExcelWookbook、ExcelWooksheetExcelApplication1.Connect;
ExcelApplication1.Visible[0]:=True;
ExcelApplication1.Workbooks.Add(NULL,0);
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks[1]);
ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Sheets[1] as _WorkSheet);
//相关处理写到这里
.....ExcelApplication1.Disconnect;//断开连接
ExcelApplication1.Quit;//关闭excel
ExcelApplication1.Visible[0]:=True;
ExcelApplication1.Workbooks.Add(NULL,0);
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks[1]);
ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Sheets[1] as _WorkSheet);
//相关处理写到这里
.....ExcelApplication1.Disconnect;//断开连接
ExcelApplication1.Quit;//关闭excel
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货