[DUG] Excel - best practice

[Stacey Verner]

We have always used the Excel OLE object.
 
LExcel := CreateOleObject('Excel.Application');
 
You can access the sheets, and modify cells directly.
 
Stacey

________________________________

From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
On Behalf Of Gary T. Benner
Sent: Tuesday, 24 January 2006 11:37 a.m.
To: delphi at delphi.org.nz
Subject: [DUG] Excel - best practice


HI guys, 

Just having to ease back into some coding accessing and modifying an
Excel spreadsheet. 

Was wondering what components are best to use to achieve this. Did some
preliminary work with ADO but had flaky results in the modification
side. 

Your ideas welcome!! 

kr 

Gary 

________________________________

Gary Benner 	
e-Engineer, Lecturer, and Software Developer	

123 Internet Limited <http://www.123.co.nz> 	
Waiariki Institute of Technology <http://www.waiariki.ac.nz> 	
Sunshine Garden Bag Co. <http://www.sunshinebags.co.nz> 	
Sommnet.com Limited <http://www.sommnet.com> 	
Mob: 021 966 992	
Email: gary at 123.co.nz 	


Ref#: 41006


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20060124/d508d2a1/attachment.html