Hybrid framework | Selenium Forum
P
Pinki Daga Posted on 16/11/2019

in excel , we have tabs for different testcases. Now suppose one of the column has number as inputs rather text.

If I simply put the number in excel, driver script throwing error saying that particular column or row does not exists.

But if I input the number by prefixing " '  ", then no error.

Why so?


A
Ashish Thakur Replied on 18/11/2019

Its an old excel trick.

The number is read as float type.. rather than string if you do not give a single quote

 


A
Ashish Thakur Replied on 18/11/2019

Its an old excel trick.

The number is read as float type.. rather than string if you do not give a single quote

 


P
Pinki Daga Replied on 18/11/2019

so we need to prefix " ' " for numbers?


A
Ashish Thakur Replied on 19/11/2019

Yes you need to fix that