Re: Is there any way to read the data from an excel file w/o using a loop structure?

2004-05-22 Thread Michael Munroe
If you are able to write a block of data, then you should be able to
read a block. The four requirements that you want to verify are:
1. The Range specified must match the exact size and location of the
data block you want to read
2. The returned data is in a 2D array of Variants (either strings or
numbers)
3. Use Variant to Data to convert to 2D DBL or 2D Strings
4. Check for the correct orientation for your application (use
transpose if it is not)

Michael Munroe
Certified LabVIEW Developer
www.abcdef.biz



Is there any way to read the data from an excel file w/o using a loop structure?

2004-05-21 Thread mda711
I am retrieving a large amount of data (multiple sheets) from an excel
file and would like to extract the entire range without retrieving
individual cell values(too slow).  I can write an range all at once
but cannot read it.