Forum Discussion

VeenaDevi's avatar
VeenaDevi
Contributor
4 years ago
Solved

Using Same Excel file for dataDriven as well as to update Using Excel Write

In Data Driven loop , as the last statement , i am trying to update the last column as Status (looping via Rowindex maintained in Variable and incrementing ) , however when call excel.save , TestComplete throwing " Failed to delete the 'OrderData.xlsx' file. 12.28.38 Normal 0.13 0.13

 

How to use the same file for data driven loop and update the new column 

 

excelSheet.Cell('H', excelRow).Value = message;

// Save the file to apply the changes
excelFile.Save();