HI hina!
May you provide a screenshot of the error you are receiving in your test logs?
I am on the same version of TC as you and unfortunately after bringing in your code and creating the same spreadsheet, I am seeing 'Expected and Actual Datasets are the same' when running your script. Could your spreadsheet have been updated with you knowing possibly?
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
We had many problems with Excel and TestComplete that turned out to be Excel issues. It was similar to what you are seeing, sometimes you could read the cell and sometimes not. There was a post on the forum recently about not being able to read blank cells and that was a problem too. If we wrote and rewrote to the same sheet, eventually something would get corrupted in the spreadsheet that we couldn't fix and then we had to create a whole new spreadsheet with the exact same data. Our workarounds ended up wasting so much time that we abandoned Excel as a data storage and began using .csv files instead.
Sometimes we all forget that Excel wasn't designed to do all the things that we try to force it to do. .csv files are just text and won't have hidden, embedded code that can interfere with your data.
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?
Hi Nick,
I have attached the file generated by the application, which Testcomplete can't read.
Also I tried one more thing, I modified the code to add excelFile["Save"](); (was hoping it might fix the issue)
Below is the code:
function VerifyQueryResults(ExcelFileName)
{
// Get the sheet of the Excel file
var excelFile = Excel.Open(ExcelFileName);
var excelSheet = excelFile.SheetByTitle("Sheet1");
Delay(1000);
excelFile["Save"]();
// Read data from the Excel file
var Difference = excelSheet.Cell(1, 2).Value;
if(Difference == 0)
Log["Event"]("Expected and Actual Datasets are the same");
else
Log["Error"]("Expected and Actual Datasets are not the same");
}
But when I run the code above, Testcomplete throws an error below:
Next time when I run the same code, TestComplete throws an error below:
So basically excelFile["Save"](); does not work.
Thanks,
Hina
