如题:我每次随机查询10条数据,每次都不一样,查询一次,我把她导出生成EXCEL,第一次可以把查询数据导入,但第2次就不可以~~
导出EXCEL文件的代码:
var
i,row,column:integer;
begin
Try
ExcelApplication1.Connect;
Except
MessageDlg('Excel may not be installed',mtError, [mbOk], 0);
Abort;
End;
ExcelApplication1.Visible[0]:=True;
ExcelApplication1.Caption:='Excel Application';
ExcelApplication1.Workbooks.Add(Null,0);
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks[1]);
ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Worksheets[1] as _Worksheet);
ADOQuery1.Open;
row:=1;
While Not(ADOQuery1.Eof) do
begin
column:=1;
for i:=1 to ADOQuery1.FieldCount do
begin
ExcelWorksheet1.Cells.Item[row,column]:=ADOQuery1.fields[i-1].AsString;
column:=column+1;
end;
ADOQuery1.Next;
row:=row+1;
end;end;
谢谢~~~在线等~~
导出EXCEL文件的代码:
var
i,row,column:integer;
begin
Try
ExcelApplication1.Connect;
Except
MessageDlg('Excel may not be installed',mtError, [mbOk], 0);
Abort;
End;
ExcelApplication1.Visible[0]:=True;
ExcelApplication1.Caption:='Excel Application';
ExcelApplication1.Workbooks.Add(Null,0);
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks[1]);
ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Worksheets[1] as _Worksheet);
ADOQuery1.Open;
row:=1;
While Not(ADOQuery1.Eof) do
begin
column:=1;
for i:=1 to ADOQuery1.FieldCount do
begin
ExcelWorksheet1.Cells.Item[row,column]:=ADOQuery1.fields[i-1].AsString;
column:=column+1;
end;
ADOQuery1.Next;
row:=row+1;
end;end;
谢谢~~~在线等~~
解决方案 »
- 哥哥~姐姐~大叔~~大妈~~求救
- 我想在ListBox控件的Item项中左边为一个小图标,右边为文字,如何实现?
- 有可以自动将VC头文件转为DELPHI的工具吗?
- 面向对象式绘图(GIS相关)
- 如何使同级菜单的Checked属性互斥?
- 如何在delphi中执行DOS下的批处理
- 如何把excel文件导入到sql server数据表中,谢谢
- ActviexForm能否像Activex控件一样使用?
- 如何在delphi中获得cpu及硬盘的序列号?
- 请高手帮忙!!
- 怎样在DELPHI里相应COM接口的事件?
- 连接oracle数据库,DBExpress中用sqlconnection,sqltable.另加一个datasource ,DBGrid显示数据的问题!Operation not allowed on a unidi
ExcelApplication1.disconnect;
在退出时加上以上代码
===
begin
column:=1;
for i:=1 to ADOQuery1.FieldCount do
begin
ExcelWorksheet1.Cells.Item[row,column]:=ADOQuery1.fields[i-1].AsString;
column:=column+1;
end;
ADOQuery1.Next;
row:=row+1;
end;
ExcelApplication1.quit; ////////////后加
ExcelApplication1.disconnect;
是想导出完当前结果集,就保存。可是
报错,说内存地址不能读~~
现在搞好了,结帖~~