Articles   Members Online:
-Article/Tip Search
-News Group Search over 21 Million news group articles.
-Delphi/Pascal
-CBuilder/C++
-C#Builder/C#
-JBuilder/Java
-Kylix
Member Area
-Home
-Account Center
-Top 10 NEW!!
-Submit Article/Tip
-Forums Upgraded!!
-My Articles
-Edit Information
-Login/Logout
-Become a Member
-Why sign up!
-Newsletter
-Chat Online!
-Indexes NEW!!
Employment
-Build your resume
-Find a job
-Post a job
-Resume Search
Contacts
-Contacts
-Feedbacks
-Link to us
-Privacy/Disclaimer
Embarcadero
Visit Embarcadero
Embarcadero Community
JEDI
Links
Handle Excel through OLE Automation Turn on/off line numbers in source code. Switch to Orginial background IDE or DSP color Comment or reply to this aritlce/tip for discussion. Bookmark this article to my favorite article(s). Print this article
11-Sep-02
Category
OLE
Language
Delphi 3.x
Views
128
User Rating
No Votes
# Votes
0
Replies
0
Publisher:
DSP, Administrator
Reference URL:
DKB
			Author: William Gerbert

Handle Excel through OLE Automation

Answer:

The example below shows how to create and control an embedded Excel object. In case 
of Delphi 3, you need to use unit OleAuto, in Delphi 5 you have to use ComObj 
instead.

A good additional source is here.


1   uses
2     OleAuto; // Delphi 3
3     ComObj; // Delphi 5
4   
5   var
6     vExcel: variant;
7   
8   procedure TForm1.Button1Click(Sender: TObject);
9   begin
10    vExcel := CreateOleObject('Excel.Application');
11    vExcel.Workbooks.Add;
12    vExcel.ActiveWorkbook.Worksheets(1).Range('A1').Value := 'Hello World';
13    vExcel.Visible := True;
14  end;
15  
16  procedure TForm1.FormDestroy(Sender: TObject);
17  begin
18    if not VarIsEmpty(vExcel) then
19      vExcel.Quit;
20  end;


			
Vote: How useful do you find this Article/Tip?
Bad Excellent
1 2 3 4 5 6 7 8 9 10

 

Advertisement
Share this page
Advertisement
Download from Google

Copyright © Mendozi Enterprises LLC