Preetha
Occasional Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Not able to open excel from test complete
getting the below error sorry we couldn't find C:\QA\PATCAT\PATCAT_suite\PATCAT\Results\CATRegressionCompareTestResults.xlsx. Is it possible it was moved, renamed or deleted? I can see the excel in the same path. This is my code resultToExcel.rowNo= 2; //static variable function resultToExcel(Apptn,graphname,count) { var rowNo; var fileName=Project.ConfigPath+"\Result\\CATRegressionCompareTestResults.xlsx"; var excel = Sys.OleObject("Excel.Application"); var myWorkbook = excel.Workbooks.Open(fileName); //// this line is giving the error var mySheet = myWorkBook.Sheets.Item("Sheet1"); excel.Cells.Item(rowNo,2).Value=graphname; if(Apptn="PAT") { excel.Cells.Item(rowNo,3).Value=count; } else if(Apptn="CAT") { excel.Cells.Item(rowNo,4).Value=count; } myWorkBook.Save(); excel.Quit(); } Please let me know if i am doing anything wrongSolved1.1KViews0likes2CommentsNot able to retrive the date from the excel sheet.
Not able to retrive the date from the excel sheet. Excel I am using is professional 2013. When I read a date from excel it is retriving as text hence for date 18/03/2019 it retrives as 43542. How can can I get it in the date format?Solved871Views0likes1Comment