经常会遇到DBGRID 转入到EXCEL中的情况,所以写了个通用程序,希望对大家有用。
procedure TDM.DBGridExport(GRID:TDBGRID);
var //DBGRID控件内容存储到EXCEL 只有第一行有标题EclApp:Variant;
XlsFileName:String;
sh:olevariant;
i,j:integer;
s:string;
savedailog:TSaveDialog;
begin
savedailog:=TSaveDialog.Create(Self);
savedailog.Filter:='Excel files (*.xls)|*.XlS';
if savedailog.Execute then begin
xlsfilename:=savedailog.FileName;
savedailog.Free;
end
else begin
savedailog.Free;
exit;
end;
try
eclapp:=createOleObject('Excel.Application');
sh:=CreateOleObject('Excel.Sheet');
except
showmessage('您的机器里未安装Microsoft Excel。');
exit;
end;
try