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 ...
Forum Discussion
TanyaYatskovska
Alumni
AlumniHi,
What if you separate your line 23 in the following way?
...
var cell = VarToStr(Excel.Cells(i,0));
switch(cell) //This is line 23
// I have tried Excel.ActiveSheet.Cell
{
...
I recommend that you go through the TestComplete sample demonstrating how to read data from Excel files. You can find it on your computer here:
<TestComplete Samples>\Miscellaneous\MSOffice\