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.
At A Glance
An overview of xlsx-populate features.
- Generate XLSX file
- Add paragraphs
- Apply font styles
- Rich texts
- Format text
- Printing support
- Extract paragraph
- Read XLSX
- Add rows
- Manage columns
- Agile encryption
- Extract images
- Manage hyperlinks
xlsx-populate only requires Node.js v4+.
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.
Search and Replace in Excel Workbook
Cell Formatting in Excel Workbook
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