[Openroad-users] Transferring data into an Excel spreadsheet

[Antill, Jim]

Allan,
 
We use the automation features offered by Excel in order to allow OpenROAD to
control an Excel spreadsheet. Rather than try to use the Excel functions
directly from OpenROAD we use an ActiveX control which wraps Excel (we found
this makes things more stable).
 
The ActiveX control holds a reference to the Excel object it is using, and
also methods that allow this instance of Excel to be manipulated. For
example, there could be an insertCell method which takes as parameters the X
and Y coords of the cell and a value. Methods would also exist to open a new
workbook, print etc. The actual Excel object held by the ActiveX is always
accessed using these methods.
 
I've attached a sample piece of VB6 code (that would be used to form an
ActiveX control) which contains methods enabling an Excel worksheet to be
opened and values added to particular cells. It's very cut-down and needs
error-checking etc. put in, but it demonstrates what can be done.
 
Hope that helps,
Jim
 
 

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com]On Behalf Of Kim Ginnerup
Sent: 29 February 2008 09:08
To: International OpenROAD Users
Subject: Re: [Openroad-users] Transferring data into an Excel spreadsheet


*************************************

This e-mail has been received by the Revenue Internet e-mail service. (IP)

*************************************
	

I would really like to har about this as well.

I have used copytoclipboard with success.

But would like to make a more automated way I need to do graphs as well

 

Regards,

 

Kim

 


  _____  


Fra: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] På vegne af Allan Biggs
Sendt: 29. februar 2008 09:40
Til: openroad-users at peerlessit.com
Emne: [Openroad-users] Transferring data into an Excel spreadsheet

 


I have to report some data in an excel spreadsheet - I can think of many ways
to do this outside of OpenROAD - but have decided that OpenROAD will be the
simplest. 

I wonder if anyone has a simple example that they would be prepared to share
to get me started? 

All I want to do is place some values into specified cells and save the
spreadsheet. 

Thanks in advance Allan

 
This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.
 
Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean
 
           http://www.DuPont.com/corp/email_disclaimer.html



************************

This message has been delivered to the Internet by the Revenue Internet e-mail service (OP)

*************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20080229/c790880f/attachment.html 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: excelexample.txt
Url: http://www.peerlessit.com/pipermail/openroad-users/attachments/20080229/c790880f/attachment.txt