Modify existing Excel File using node.js

node.js exceljs
jengfad picture jengfad · Oct 5, 2016 · Viewed 29.8k times · Source

Is there any way to modify existing excel file in node.js? I've looked into exceljs but it does not provide any functionality that will just modify the existing data. It seems like it will write to a new stream.

Or did I miss something on exceljs?

Thanks in advance.

Answer

Clarence Leung picture Clarence Leung · Oct 5, 2016

exceljs does let you modify Excel spreadsheets.

Here's an example of reading in an existing spreadsheet and writing it back out to a different file:

var Excel = require('exceljs');
var workbook = new Excel.Workbook();

workbook.xlsx.readFile('old.xlsx')
    .then(function() {
        var worksheet = workbook.getWorksheet(1);
        var row = worksheet.getRow(5);
        row.getCell(1).value = 5; // A5's value set to 5
        row.commit();
        return workbook.xlsx.writeFile('new.xlsx');
    })

If you're using the Streams API with exceljs, you can also pipe your stream into fs.createWriteStream to write to a file as well.

Related questions

How to download created excel file in node.js using exceljs

I am using exceljs module for creating excel file. The problem is it is neither getting created nor getting saved in the path. var excel = require('exceljs'); var options = { filename: './streamed-workbook.xlsx', useStyles: true, useSharedStrings: true }; var workbook = new …

Read More
Node exceljs reading file

So according to the offical documentation i should be able to read an excel document using: // read from a file var workbook = new Excel.Workbook(); workbook.xlsx.readFile(filename) .then(function() { // use workbook }); // pipe from stream var workbook = new Excel.…

Read More
Add rows before the column header using excel.js module + node

I am trying to create xslx file using excel.js module in node.js. I was able to create the columns and add its values. But, I need to insert some rows before the columns headers, where I can have …

Read More