Office.js: Add multiple rows on Excel using Excel.Range class

Question

I want to add multiple rows at a time to table on Excel. Right now we are adding using for loop.

 await Excel.run(async (ctx: Excel.RequestContext) => {
        sheet = ctx.workbook.worksheets.getItem('sheetName');
        table = ctx.workbook.tables.getItem('tableName');
        await ctx.sync();

        for (let i: number = 0; i < addRowCount; i++) {
          table.rows.add();
        }
}

Is there API on Office js which allow to insert multiple rows at a time?. I was exploring Excel.Range class. but did not find any helpful one.

Rick Kirkham · Accepted Answer · 2020-03-26 00:14:05Z

1

Yes. Beginning with Excel.js 1.4, you can use the same add method to add multiple rows. See TableRowCollection.add.

answered Mar 26, 2020 at 0:14

Rick Kirkham

9,9172 gold badges16 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

FreeSoftwareServers Over a year ago

No code example :(

Collectives™ on Stack Overflow

Office.js: Add multiple rows on Excel using Excel.Range class

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related