AnsweredAssumed Answered

vrf How to read data from Excel

Question asked by VRFuser on Feb 9, 2004

Like • Show 0 Likes0
Comment • 2

We are using VEE 6.2 to read data from Excel but it dont't work. The
data we are reading is list of numbers but FROM FILE object don't work.
Is there some other way to read an Excel file?

__
Sano ei kuukausimaksuille. Hanki Suomen ainoa aidosti
kuukausimaksuton GSM-liittym osoitteesta http://www.saunalahti.fi

---
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".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!

No one else has this question

Outcomes

wilsonr Feb 8, 2004 5:32 PM

There is an example of how to do this using ActiveX thats installed
with 6.1.

Not sure of the file name (currently on a Mac; wish there was a Mac
version of VEE), but go Help, Examples, and look at the examples under
folder: ActiveX Automation.

Best wishes,
Richard.
------------------------------------------
Dr. Richard J.A. Wilson
Rm 205, Heritage Medical Research Building,
Department of Medical Physiology and Biophysics,
University of Calgary,
3330 Hospital Dr. N.W.
Calgary, Alberta,
Canada. T2N4N1

Secretary: (403) 220 6765

Office:(403) 220 8460
Lab: (403) 220 4528
Fax: (403) 270 8928

E-mail: wilsonr@ucalgary.ca
Web: http://www.ucalgary.ca/~wilsonr/index.html

---
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".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!

Actions

scubaman Feb 8, 2004 7:59 PM

You can't read a .xls file using the from file object. If you store the
file in .csv or some other text format, you can use that object. To read a
.xls file, you need to use activeX. There are some examples that came with
Vee. I use an add-in program called vxl that makes interacting with .xls
files much easier for the casual user (me) than dealing with a lot of
activeX. vxl is available from passtechnologies.com. You can download a
demo as I recall.
--
Regards,
Rich
===================
Richard Kleinhenz
Wafer Engineering
845-892-2617
scubaman@us.ibm.com
===================


             MittaLKmo@jippii.
             fi
                                                                        To
             02/09/2004 06:53          VRF <vrf@agilent.com>
             AM                                                         cc

                                                                   Subject
             Please respond to         [vrf] How to read data from Excel
                 MittaLKmo






We are using VEE 6.2 to read data from Excel but it dont't work. The
data we are reading is list of numbers but FROM FILE object don't work.
Is there some other way to read an Excel file?

__
Sano ei kuukausimaksuille. Hanki Suomen ainoa aidosti
kuukausimaksuton GSM-liittym osoitteesta http://www.saunalahti.fi

---
You are currently subscribed to vrf as: scubaman@us.ibm.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".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible
inclusion in VEE 7.0!

---
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".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!

Actions

2 Replies

wilsonr Feb 8, 2004 5:32 PM
Mark Correct
Correct Answer
There is an example of how to do this using ActiveX thats installed
with 6.1.

Not sure of the file name (currently on a Mac; wish there was a Mac
version of VEE), but go Help, Examples, and look at the examples under
folder: ActiveX Automation.

Best wishes,
Richard.
------------------------------------------
Dr. Richard J.A. Wilson
Rm 205, Heritage Medical Research Building,
Department of Medical Physiology and Biophysics,
University of Calgary,
3330 Hospital Dr. N.W.
Calgary, Alberta,
Canada. T2N4N1

Secretary: (403) 220 6765

Office:(403) 220 8460
Lab: (403) 220 4528
Fax: (403) 270 8928

E-mail: wilsonr@ucalgary.ca
Web: http://www.ucalgary.ca/~wilsonr/index.html

---
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".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!
Like • Show 0 Likes0
Actions
scubaman Feb 8, 2004 7:59 PM
Mark Correct
Correct Answer

You can't read a .xls file using the from file object. If you store the
file in .csv or some other text format, you can use that object. To read a
.xls file, you need to use activeX. There are some examples that came with
Vee. I use an add-in program called vxl that makes interacting with .xls
files much easier for the casual user (me) than dealing with a lot of
activeX. vxl is available from passtechnologies.com. You can download a
demo as I recall.
--
Regards,
Rich
===================
Richard Kleinhenz
Wafer Engineering
845-892-2617
scubaman@us.ibm.com
===================


             MittaLKmo@jippii.
             fi
                                                                        To
             02/09/2004 06:53          VRF <vrf@agilent.com>
             AM                                                         cc

                                                                   Subject
             Please respond to         [vrf] How to read data from Excel
                 MittaLKmo






We are using VEE 6.2 to read data from Excel but it dont't work. The
data we are reading is list of numbers but FROM FILE object don't work.
Is there some other way to read an Excel file?

__
Sano ei kuukausimaksuille. Hanki Suomen ainoa aidosti
kuukausimaksuton GSM-liittym osoitteesta http://www.saunalahti.fi

---
You are currently subscribed to vrf as: scubaman@us.ibm.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".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible
inclusion in VEE 7.0!

---
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".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!
Like • Show 0 Likes0
Actions

vrf How to read data from Excel

Outcomes

Related Content

Recommended Content