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