Forum Discussion

hina's avatar
hina
Contributor
4 years ago

Reading from excel was working before updating to Testcomplete 15.40.421

Hi,   The code below was working before upgrading to TestComplete 15.40.421.   function test() { var ExcelFileName = "C:\\ELink\\Queries\\Dataset_Comparison_Query_Result1.xlsx"; VerifyQuer...
hina's avatar
hina
Contributor
4 years ago

Hi Nick,

 

Thank you for the quick reply. You are right when I create the spreadsheet manually, TestComplete does ready the value 0. But I realized, the spreadsheet I am using is generated by the application I am testing, for some reason when I run the same script, TestComplete doesn't read the value 0 and Difference is set to undefined. But if I resave the same spreadsheet as it is, TestComplete does read the value 0. This is so weird, I am not really sure what to do. Any help would be appreciated.

 

Thanks,

Hina

npaisley's avatar
npaisley
Icon for Staff rankStaff
4 years ago

Hey hina,

 

Interesting, maybe it's some type of odd formatting that is being applied. Would it be possible for you to attach a copy of the spreadsheet that is generated by your application?