Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,089 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
I have developed an Excel Javascript plugin using the React framework.
The add-in workflow is simple.
During the Excel data writing, the whole Excel workbook freezes, and I'm unable to use any other workbook until the data is written.
The maximum amount of data coming from APIs is 5-8K.
Below is the sample code.
try {
var i = 0;
// these data are coming from APIs
var allCompanies =[12,32,33,43,45,66,12,32,10,12,21,90];
allCompanies.forEach(async _company => {
// calling APIs for each _docs and writing data for that companies
await fetchData(_company).then(async (responseRows) => {
await Excel.run(async (context) => {
let sheet = context.workbook.worksheets.getActiveWorksheet();
sheet.load(["name"]);
await context.sync();
for (let i = 0; i < responseRows.length; i++) {
// data operations into Exel sheet
// creating table, table header, applying Css
// writting value to each cells
}
sheet.getUsedRange().format.autofitColumns();
sheet.getUsedRange().format.autofitRows();
await context.sync();
});
});
});
} catch (error) {
console.log("error on appending data into excel " + error);
}
Any solution will be helpful to me.
Thanks.