procedure RsToExcel(AdoQuery1: TAdoQuery; ExcelFileName: string);
var
ExcelApp, Book, Sheet, Range, xlQuery: OleVariant;
begin
if not ADOQuery1.Active then
ADOQuery1.Open;
ExcelApp := CreateOleObject( 'Excel.Application' ); //创建
try
if ExcelApp.Workbooks.count < 1 then
ExcelApp.WorkBooks.Add;
Book := ExcelApp.Workbooks[1];
if Book.Worksheets.Count < 1 then
Book.Worksheets.Add;
Sheet := Book.Worksheets[1];
Sheet.SaveAs(ExcelFileName);
finally
Sheet := Unassigned;
Book := Unassigned;
if not VarIsEmpty(ExcelApp) then
ExcelApp.Quit;
ExcelApp := Unassigned;
if ADOQuery1.Active then ADOQuery1.Close;
end;
end;
贴出代码,望高手指点。
//打印数据表格
function PrintCxGrid(AGrid: TcxGrid): String;
var
sTmpFile: String;
eclApp, srcWorkBook: Variant;
begin
//生成临时文件的文件名
sTmpFile := ExtractFilePath(Application.ExeName) + 'E' + FormatDateTime('YYMMDDHHMMSS', Date + Time) + '.tmp';
//
try
Screen.Cursor := crHourGlass;
//
try
eclApp := CreateOleObject('Excel.Application');
srcWorkBook := CreateOleobject('Excel.Sheet');
except
Result := 'Microsoft Excel Not Support In Your System!';
Exit;
end;