AnsweredAssumed Answered

vrf AW: Reading Excel range into VEE

Question asked by warren.pickles on May 7, 2003
Tried that.  I would have thought it would speed things up, but it didn't
seem to make any difference in this case.  Thanks anyway.
Warren

-----Original Message-----
From: Baranski, Detlef [mailto:Detlef.Baranski@PILKINGTON.de]
Sent: 08 May 2003 11:39
To: VEE vrf
Subject: [vrf] AW: Reading Excel range into VEE


Excel gets damned slow in visible mode.
Just switch the visible mode off and after use of your routine on again.

ExcelApp.Visible = TRUE; Its slow ;-(

ExcelApp.Visible = FALSE; It gets fast

Best regards,
detlef



-----Ursprngliche Nachricht-----
Von: Pickles, Warren [mailto:Warren.Pickles@tycoelectronics.com]
Gesendet: Donnerstag, 8. Mai 2003 11:15
An: VEE vrf
Betreff: [vrf] Reading Excel range into VEE


Hello,
I have attached a small VEE program, adapted from one of the examples, to
illustrate something which has been giving me a headache.
I want to read the contents of an Excel worksheet into VEE, as a 2D array.
I set up a variable called "sheet", which is an object variable of the
worksheet class.  Then I use sheet.Usedrange.Value in a formula box.
Sometimes this outputs a 2D array, sometimes a record.  The data type of the
output seems to depend on the data in the cells.  If the data are all of the
same type, a 2D array is outputted.  If the data are of mixed types, ie some
are real numbers, some are text, a record gets outputted.  It doesn't matter
if you go into excel and format all the cells as text; if any of them can be
read as numbers you still get a record.
I can't find an easy way to convert the record into a 2D array.
The way around the problem is to loop through the each cell, get its value,
and collect into an array.  But there is a time penalty for this, and I will
be working with large sheets.
Any thoughts?
Thanks,
Warren Pickles

<<ExcelProblem.vee>>

*** eSafe scanned this email for malicious content ***
*** IMPORTANT: Do not open attachments from unrecognized senders  ***
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: Warren.Pickles@tycoelectronics.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@it.lists.it.agilent.com".

If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.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@it.lists.it.agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes