JavaScript Library to Generate and Parse Excel XLSX Files  

Open Source JavaScript API to Populate Excel data from a worksheet, manage rows and columns, manage Excel sheets, data validation, XLSX agile encryption or decryption, and so on.

xlsx-populate is a powerful JavaScript library that enables software developers to build applications that can generate and parse Excel XLSX  with ease.  The library was first written for Node.js and later the browser support is also provided. The library has included several important features such as to populate Excel data from excel sheet, pull data out of existing workbooks, manage rows and columns, manage Excel sheets, find and replace data, manage cell formatting, rich texts support, Data validation support, manage hyperlinks, page margins support, printing support, XLSX agile encryption or decryption and much more.

The library is very stable and emphasis on keeping the existing workbook features and styles intact.  The library supports several important features related to spreadsheet rows and columns, such as you can access rows and columns in order to change the size, hide or show, or access cells.

he xlsx-populate can easily read an Excel worksheet from a specified Excel file, and get its data in JSON format, and can export it to any other worksheet with ease.  You can easily parse and manipulate multiple cells at once.  The library has included support for several important features related to managing Excel Worksheet and workbooks such as adding new sheets, rename a worksheet, move the sheet to other locations, and many more.

Previous Next

Getting Started with xlsx-populate

The recommended way to install xlsx-populate, is using npm, please use the following script for a smooth installation.

Install xlsx-populate via npm

npm install xlsx-populate 

You can download the compiled shared library from GitHub repository and install it.

Manage Excel Worksheet via JavaScript API

The open source library xlsx-populate has provided support for managing your excel worksheets with ease inside their own JavaScript applications. The library has included numerous options for managing sheets, such as add a new worksheet, assign names to a worksheet, rename a sheet, move worksheet, delete a worksheet, get the active sheet,  get a sheet by name, or index and so on.

Search and Replace in Excel Workbook

The free library xlsx-populate enables software developers to easily search text in a workbook and can also replace it with a new one using JavaScript commands.  It provides several important options such as find all occurrences of the text, search text in the first sheet, find the text but don't replace it, check if a particular cell matches the value, replace all lowercase letters with uppercase, and many more.

Cell Formatting in Excel Workbook

The open source library xlsx-populate supports several important features for Excel worksheet cell formatting using JavaScript code. You can easily set or get a single style as well as multiple styles with ease. You can also set all cells in a range with a single style or multiple styles using any combination. Same like Microsoft Excel setting a style on a column will apply that style to all existing cells as well as on any new cells that are populated.

Excel Data Validation support

The data validation feature in Microsoft Excel helps users to control what can be entered in the worksheet. For example, you can place a check that a number value is entered or date occurs is a particular format, etc. The open source library xlsx-populate provides a complete support setting, getting or removing a cell data validation. You can also apply validation on a range of cells with ease