Question

93

How to delete an existing row of a worksheet in Excel by using XLSX in node js?

rated 0 times [ 96] [ 3] / answers: 1 / hits: 6510 / 3 Years ago, wed, december 16, 2020, 12:00:00

How to delete an existing row of a worksheet of a workbook in Excel by using the XLSX from SheetJS in Node.js?

The code so far:

const xlsx = require('xlsx');



// read the file

workBook = xlsx.readFile("todo-list.xlsx", {cellDates:true});



// read the worksheet

const shoppingList = workBook.Sheets["Do-Shopping"];



// delete a specific row

........ [here I dont know even how to start]



// write the data to the Excel file

xlsx.writeFile(workBook, 'todo-list.xlsx');

Desired results:

BEFORE:

AFTER:

But the deleted row could be anyone, like the first one or the third one, not necessary the last one.

I tried searching on the official docs and stack, but I have not found an answer yet. :( and I am new to Node js

Could you please help me ?

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

mckinley

Add To Favorites

Follow

Total Points: 15

Total Questions: 101

Total Answers: 94

Location: Liechtenstein

Member since Fri, Sep 11, 2020

3 Years ago

mckinley questions

1 Apache reverse proxy to Node - Connection refused: AH00957

Sun, Oct 17, 21, 00:00, 2 Years ago

1 NestJS Http Module

Tue, Jun 15, 21, 00:00, 3 Years ago

1 Next.js Static Regeneration on demand

Thu, Apr 8, 21, 00:00, 3 Years ago

1 Why is my WebSocket connection closing after I refresh the page?

Fri, Feb 21, 20, 00:00, 4 Years ago

1 Typescript enums typing error (argument of type 'string' is not assignable to parameter of type)

Mon, Oct 21, 19, 00:00, 4 Years ago

View All

answered 3 Years ago rociom · Accepted Answer

Answer found on the Github's site, works very well on any row:

// delete a specific row

function ec(r, c){

    return xlsx.utils.encode_cell({r:r,c:c});

}

function delete_row(ws, row_index){

    var variable = xlsx.utils.decode_range(ws["!ref"])

    for(var R = row_index; R < variable.e.r; ++R){

        for(var C = variable.s.c; C <= variable.e.c; ++C){

            ws[ec(R,C)] = ws[ec(R+1,C)];

        }

    }

    variable.e.r--

    ws['!ref'] = xlsx.utils.encode_range(variable.s, variable.e);

}

delete_row(shoppingList, 1)