Easily Parse Microsoft® Excel Spreadsheets with Node Office
Open Source JavaScript & Node.js Spreadsheet API allows developers to parse Microsoft Excel Spreadsheets programmatically.
NodeOffice is an open-source API for JavaScript developers to parse Microsoft Excel Spreadsheets programmatically. NodeOffice is completely developed using JavaScript, and you use it for your Node.js projects. It supports different operating systems including Windows, Mac OS, and Linux. NodeOffice is an easy and lightweight solution for the programmers for parsing Spreadsheet documents inside their own applications.
Before you use Node office, make sure to install XHTML to convert Microsoft Excel sheets into HTML for the parser, and unoconv a command-line tool that allows you to convert any document format from LibreOffice.
Getting Started with NodeOffice
TThe recommended way to install the NodeOffice library is via npm. Please use the following command for a smooth installation.
Install NodeOffice via npm
npm install office
You can download the compiled shared library from GitHub repository and install it.
Parse XLS via Free JavaScript API
NodeOffice is an open-source JavaScript API to parse Microsoft Spreadsheet documents for free. It is a simple and lightweight tool to parse Excel Spreadsheet documents. By using the following simple lines of code, you can parse your XLS using JavaScript.
- Include NodeOffice
- Parse XLS by using office.parse() method and pass excel file name as string
Parse DOCX - JavaScript
var office = require('office');
office.parse('fileformat.xls', function(err, data) {
console.log(data);
});