An efficient way to read data from excel
- From: FaisalVali <faisalv@xxxxxxxxx>
- Date: Thu, 11 Oct 2007 01:47:44 -0000
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
.
- Follow-Ups:
- Re: An efficient way to read data from excel
- From: McKirahan
- Re: An efficient way to read data from excel
- From: Paul Randall
- Re: An efficient way to read data from excel
- Prev by Date: Re: Handling Errors in script code
- Next by Date: Re: An efficient way to read data from excel
- Previous by thread: Re: Handling Errors in script code
- Next by thread: Re: An efficient way to read data from excel
- Index(es):
Loading