AnsweredAssumed Answered

vrf AW: Reading data from an excel file

Question asked by detlef.baranski on Jun 28, 2004
Try this concept ( from Shawn originally) in a fromular box:

// Get a sheet.
Set sht = CreateObject("Excel.Sheet").Worksheets(1);
sht.Application.Visible = True;

// Setup a test array.
ary = [[1, 2, 3], [4, 5, 6], [7, 8, 9]];

// Try a couple things.
sht.Range("A1:C1").Value = ary;
sht.Range("A3:C5").Value = ary;
sht.Range("A7:A9").Value = ary;


Where ary is your data-output ....


best regards,
detlef



-----Ursprngliche Nachricht-----
Von: murat atasayar [mailto:matasayar@yahoo.com]
Gesendet: 28 June 2004 17:38
An: VRF
Betreff: [vrf] Reading data from an excel file


Hello,
I am preparing a database by using Vee and MSexcel.I have finished the part
consisting writing data in excel sheet. However, i do not know how to read
these data from excel sheet. Could you please help me about this problem?

Thank you,

Best regards

Murat ATASAYAR
This message and any attachments are confidential, for the exclusive use of
the addressee and may be legally privileged. Any other distribution, use or
reproduction is unauthorised and prohibited. If you have received this
message in error, please notify the sender immediately and delete the
message from your system.

Visit our internet site at http://www.pilkington.com

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes