各位高手,我在用Ole方式控制EXCEL时其他方面都没出现件么问题可就在保存时出错了:
var
ExcelApp: Variant;
begin
ExcelApp:= CreateOleObject( 'Excel.Application' );
ExcelApp.WorkBooks.Add;
ExcelApp.WorkSheets[1].Activate;
....
ExcelApp.SaveAs(Filename := SaveDialog1.FileName,
FileFormat:=xlNormal,
Password := '',
WriteResPassword := '',
ReadOnlyRecommended := False,
CreateBackup := False);end;
在执行SaveAs语句时报错,提示为:Method 'SaveAS'not supported by automation object。
var
ExcelApp: Variant;
begin
ExcelApp:= CreateOleObject( 'Excel.Application' );
ExcelApp.WorkBooks.Add;
ExcelApp.WorkSheets[1].Activate;
....
ExcelApp.SaveAs(Filename := SaveDialog1.FileName,
FileFormat:=xlNormal,
Password := '',
WriteResPassword := '',
ReadOnlyRecommended := False,
CreateBackup := False);end;
在执行SaveAs语句时报错,提示为:Method 'SaveAS'not supported by automation object。
ExcelApp.ActiveWorkBook.SaveAs(Filename := SaveDialog1.FileName,
FileFormat:=xlNormal,
Password := '',
WriteResPassword := '',
ReadOnlyRecommended := False,
CreateBackup := False);
我使用的是Delphi 控件方法
在Form中分别放入ExcelApplication, ExcelWorkbook和ExcelWorksheet。 WorkBooks我是直接打开1个已有的,ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks.Open ('D:\a.xls',EmptyParam,EmptyParam,
EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam,0));
保存时用的ExcelWorkbook1.SaveAs( 'd:\a.xls' ); 运行后出现蓝屏说是fatal错误 。