Read/Write excel sheet using ExcelJS

In this post we will understand how we can read/write excel sheet and styles using ExcelJS [javaScript/TypeScript].

We are using node.js / npm package “ExcelJS” to achieve excel operations.

Installation :

Open terminal [Ctrl + `] and enter

npm install exceljs


make an entry to the package.json under dependency and run command npm install

Open any JS editor [let’s say VScode], on your local drive, create a file “ExcelJSTest.js” and open the file in VSCode.

Implementation :

Once installed, create an excel sheet “test.xlsx” under your project folder and follow the below basic code for excel operations

To run the code, on terminal enter

node ExcelJSTest.js


Reference :


Content posted is based on learning or working experience,
Share the post with others if find useful,
Any queries?, leave comments or discuss on our, Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *