Nidhi_Arora
Occasional Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: Saving an Excel file
I have also tried to use Book.SaveAs(filepath) . It is giving an error -- 'Cannot access read-only document 'dealImports.xlsx'. Please refer the code. The function has few parameters. function updateExcel(fileName, sheetName, arrayStartDate, arrayEndDate) { var book; var filepath=Project.Path+fileName; var app1 = Sys.OleObject("Excel.Application"); app1.DisplayAlerts = false; book = app1.Workbooks.Open(filepath); var sheet = book.Sheets(sheetName); var rowCount = sheet.UsedRange.Rows.Count; Log.Message('Row Count '+rowCount); var j=0; for(var row = 2; row <=rowCount+1; row++) { Log.Message('Trade Start Date -- '+arrayStartDate[j]+ ', Trade End Date --' +arrayEndDate[j]); sheet.Cells.Item(row, 7).Value = arrayStartDate[j]; sheet.Cells.Item(row, 8).Value = arrayEndDate[j]; if(row==arrayStartDate.length+1) { break; } j=j+1; } book.Save(); app1.Quit(); }2.7KViews0likes2CommentsDoes TestComplete support Itron EE(Meter Data Management) application automation?
I want to automate Itron EE(Meter Data Management) application using test complete. Please suggest the scripting language and there are few .Net components in the application. Few tree node components are not being identified.884Views0likes1Comment