Forum Discussion

tpoirier's avatar
tpoirier
Contributor
13 years ago

Reading values out of cell in Excel

I am tryint to read a data to use in a test out of an excel document. I was going to use the CSV DDT but I need to read in different rows and store them in arrays and that was not working out so I am ...
tpoirier's avatar
tpoirier
Contributor
13 years ago
UPDATE: When working with Excel and looping through a row of cells make sure your index starts at 1 starting at 0 will come up with an error saying a semi colon ':' was expected. This error can be very misleading and left me looking for a problem that wasn't there!
hhagay's avatar
hhagay
Contributor
10 years ago

UPDATE:

 

Replace:

var cell = VarToStr(Excel.Cells(i, 1).Value);

 

With:

var cell = (VarToString(Excel.Cells.Item(i, 1)));