Missing values while itterating through CSV/ Excel- file

[Soulman]

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

[cunderw · Accepted solution]

It has to do with mixing string and number values. There's been quite a few others with this same problem:

http://community.smartbear.com/t5/Desktop-Testing/TestComplete-returns-NULL-from-Excel-in-Property-C...

http://community.smartbear.com/t5/Getting-Started-with/DDT-driver-have-a-very-strange-behaviour/m-p/...

http://community.smartbear.com/t5/Getting-Started-with/Excel-column-returns-null-for-non-numeric-cha...

[Soulman]

Thanks a lot for the links. It works now.

In csv- Files each value must be wrapped with "..." and in Excel each cell needs a ' as predecessor.

"Interesting" solution