Forum Discussion

Azeddin_Margani's avatar
Azeddin_Margani
Contributor
10 years ago

Data-Driven - To read next row of excel sheet.

Hi,   I have a scripts which reads data from excel sheet (It contains 3 rows of 1 column). When executed, it completes successfully for the first row but it doesn't continue to the second then thir...
jmcpeek's avatar
jmcpeek
Contributor
10 years ago

I'm guessing you're working in a script and using opening your spreadsheet using COM?

 

When reading from spreadsheets, I'll usually dump the contents of the sheet into a TC table-variable and then perform my operations from that (so I'm not keeping the sheet locked and am at the mercy of MS Office and network concerns for as little time as possible). Once I have the contents in a TC variable, I'll loop through that as needed. So...

 

set tblVar = project.variables.tblXLSDump

for i = 0 to tblVar.rowcount-1

   'do stuff

next

 

Hope this helps.