Forum Discussion

Soulman's avatar
Soulman
New Contributor
10 years ago

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