An efficient way to read data from excel



Hi,
I am trying to use jscript to read out almost 10,000 rows in each
of 3 columns in an excel spread***.
I end up using Cells(r,c).Value to get at each value (so almost 30,000
interprocess communication attempts) - but this is taking too long.
Is there a way to "slurp" an entire column i.e - just do one request
that then transfers all of the data from the excel.exe process into an
in memory data structure within my cscript/wscript process? I would
imagine that would take less time
So for example:
var col = ***.GetEntireUsedColumn("A");

instead of
while( ***.Cells(2,row).Value !== undefined ) )
col.push(***.Cells(2,row++).Value);

Any thoughts?
thanks in advance :)
-fas

.


Loading