Delphi&Excel

← →
Electric (2002-02-20 00:08) [7]

unit Unit1;

interface

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

type
TForm1 = class(TForm)
Button1: TButton;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;

var
Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
var
exl: OleVariant;
WorkBook, Sheet: Variant;
fileName: String;
begin
try

fileName:= "c:\Port\"+"Sample1.xls";
exl := CreateOleObject("Excel.Application");
WorkBook := exl.Application.WorkBooks.Add;
Sheet := WorkBook.WorkSheets[1];
Sheet.Cells(1,1) := "proba";

exl.Application.ActiveWorkBook.Saveas(fileName);
finally
exl.Application.Quit;
end;
end;

Delphi&Excel Найти похожие ветки