Read and Write Data into Excel
Hi, In our application, we open some excel documents from data base and read\write data into that excel document and perform some calculations. When i try to record excel document, i see tha...
Forum Discussion
Hi,
The code,
Set objRange2 = objDriverSheet.Range(”B1″)
just fetches data from the cell B1, i.e. a single cell.
However if we try to modify the same into something like
dim arrayA(10)
Set arrayA(10) = objDriverSheet.Range(”B1:B10") ' reading a range of data
or
Set arrayA(10) = objDriverSheet.Range(”RangeName1″) ' reading a named range and which has 10 cells
Log.Message arrayA(0)
The script runs successfully but always returns 0.
Please let me know the exact code to read these ranges.
Also please let me know a way to read from excel documents in our application as i have specified in my earlier post.
Thanks,
Laxmi
The code,
Set objRange2 = objDriverSheet.Range(”B1″)
just fetches data from the cell B1, i.e. a single cell.
However if we try to modify the same into something like
dim arrayA(10)
Set arrayA(10) = objDriverSheet.Range(”B1:B10") ' reading a range of data
or
Set arrayA(10) = objDriverSheet.Range(”RangeName1″) ' reading a named range and which has 10 cells
Log.Message arrayA(0)
The script runs successfully but always returns 0.
Please let me know the exact code to read these ranges.
Also please let me know a way to read from excel documents in our application as i have specified in my earlier post.
Thanks,
Laxmi
