Delphi无法导出Excel2007
我有个程序,生成Excel,但安装了Excel2007后无法使用了。我希望不用改代码就能使用。
我想问的是:
1、能不能在PC上同时安装Excel2003和Excel2007。这样是不是程序就能使用了?
2、能不能在安装包里将Excel2000对应的组件打包进去,当安装程序时也将Excel2000对应的组件也注册。Excel2000对应的组件是哪个?
谢谢大家!以下是我所采用的示例代码
uses
Excel2000;
procedure TWriteToExcel_Vendor_Details.Write();
var
ExcelApplication: TExcelApplication;
ExcelWorkbook1: TExcelWorkbook;
ExcelWorksheet1: TExcelWorksheet;
ExcelWorksheet2: TExcelWorksheet;
ExcelWorksheet3: TExcelWorksheet;
Temp_Worksheet: _WorkSheet;
range:ExcelRange;
i, j: integer;
filename: string;
msg:string;
position:string;
temp:OleVariant;
begin
msg := #$D#$A + datetimetostr(gettime())+ '>>>开始创建Exel文件.....' + #$D#$A + writetoexcel.FrmMain.msg.Text;
WriteToExcel.FrmMain.msg.Text := msg;
filename := concat(extractfilepath(application.exename),'AC_Vendor_Details_'+writetoexcel.FrmMain.ComboBox1.Items[writetoexcel.FrmMain.ComboBox1.ItemIndex], '.xls');
try
ExcelApplication := TExcelApplication.Create(Application);
ExcelWorkbook1 := TExcelWorkbook.Create(Application);
ExcelWorksheet1 := TExcelWorksheet.Create(Application);
ExcelWorksheet2 := TExcelWorksheet.Create(Application);
ExcelWorksheet3 := TExcelWorksheet.Create(Application);
ExcelApplication.ConnectKind := ckRunningOrNew;
ExcelApplication.Connect;
ExcelApplication.Workbooks.Add(EmptyParam, 1);
ExcelWorkbook1.ConnectTo(ExcelApplication.Workbooks[1]);