Missing values while itterating through CSV/ Excel- file
Hi all,
I have a problem while trying to itterate through CSV with "DDT.CSVDriver".
CSV file:
a;b;c;d;Enter;f
input;casesInput.Keys;0;0;0;Input_HappyPath_02
input;searchBox.Keys;1115;1115;Enter;Input_HappyPath_01
input;casesInput.Keys;0;1;Enter;Input_HappyPath_02
.....
My problem is, the values of the second line are wrong, when I itterate with:
while (! DDT.CurrentDriver.EOF())
{
excelValue1 = DDT.CurrentDriver.Value(0);
excelValue2 = DDT.CurrentDriver.Value(1);
excelValue3 = DDT.CurrentDriver.Value(2);
excelValue4 = DDT.CurrentDriver.Value(3);
excelValue5 = DDT.CurrentDriver.Value(4);
excelValue6 = DDT.CurrentDriver.Value(5);
.
.
.
DDT.CurrentDriver.Next();
}
Output:
First line (OK):
excelValue1:input
excelValue2:casesInput.Keys
excelValue3:0
excelValue4:0
excelValue5:0
excelValue6:Input_HappyPath_02
Ausführungstyp: input
Second line (NOK):
excelValue1:input
excelValue2:searchBox.Keys
excelValue3:1115
excelValue4:1115
excelValue5:null
excelValue6:Input_HappyPath_01
Ausführungstyp: input
The value for "excelValue5" should be "Enter". It doesnt matter in which line the value is. The output is always "null".
Can anybody help me?
Regards
Max
It has to do with mixing string and number values. There's been quite a few others with this same problem: