调用如下:
ADOQuery3.Close;
ADOQuery3.Open;
if ADOQuery3.RecordCount > 0 then
begin
with TDS2Excel.Create(TDataSet(ADOQuery3)) do
try
Save2File('c:\产品.xls', True);
finally
Free;
end;
ShowMessage('产品已经导出到C盘');
end;
end;
with adoquery1 do
begin
open;
first;
while not Eof do
begin
s:='';
for y:=0 to fieldcount-1 do
begin
s:=s+fields[y].AsString+char(9);
application.ProcessMessages;
end;
tslist.Add(s);
next;
end;
close;
end;