我的代码如下:
var
ExcelApp: Variant;
begin
ExcelApp := CreateOleObject('Excel.application');
ExcelApp.Visible := True;
ExcelApp.Caption := 'Delphi调用 Microsoft Excel';
ExcelApp.WorkBooks.Open(Filename:='D:\czcgl\test.xls');
end;
var
ExcelApp: Variant;
begin
ExcelApp := CreateOleObject('Excel.application');
ExcelApp.Visible := True;
ExcelApp.Caption := 'Delphi调用 Microsoft Excel';
ExcelApp.WorkBooks.Open(Filename:='D:\czcgl\test.xls');
end;
xlApp, xlWorkBook , xlSheet, szValue: Variant;
OpenFileName : String ;
begin
If OpenDialog1.Execute Then Begin
OpenFileName := OpenDialog1.FileName ;
xlApp := CreateOleObject('Excel.Application');
xlWorkBook := CreateOleObject('Excel.Sheet'); xlWorkBook := xlApp.Workbooks.Open(OpenFileName );
xlSheet := xlWorkBook.Worksheets[1];
xlApp.Visible := True ;
/////.......
End ;
End ;
ExcelApp: Variant;
begin
ExcelApp := CreateOleObject('Excel.application');
ExcelApp.Visible := True;
ExcelApp.Caption := 'Delphi调用 Microsoft Excel';
ExcelApp.WorkBooks.Open('D:\czcgl\test.xls');
end;