exceltest.pas

在 Delphi中调用 Excel ,实现对 Excel 的基本操作

unit ExcelTest;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExcelXP, OleServer;

type
  TForm1 = class(TForm)
    ExcelApplication: TExcelApplication;
    ExcelWorksheet: TExcelWorksheet;
    ExcelWorkbook: TExcelWorkbook;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
  ExcelApplication.Connect;                   //打开 Excel  
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  ExcelApplication.Visible[0]:=true;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
  ExcelApplication.Caption:='应用程序更改 Excel 标题';
end;

end.