Writing data in Excel file using JavaScript is resulting in performance issue.
Writing data in Excel file using JavaScript is resulting in performance issue.
I am using Excel 2016 and for simple code also observing perforamnce issue. Any solution ???
code :
function WriteExcelSheet(sheetName,rowCell,columnCell,value)
{
var app = Sys.OleObject("Excel.Application");
var book = app.Workbooks.Open(excelPath);
var sheet = book.Sheets.Item(sheetName);
app.DisplayAlerts = false;
sheet.Cells.$set("Item", rowCell, columnCell, value);
book.Save();
app.Quit();
}
A very basic example of how to write out to a text file is given at https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqfile/writetotextfile.html
To write to a CSV is simply to take that code and modify it to update the output to be comma delimited rows.