xls-to-json

2.1.1 • Public • Published

node-xls-json

Build Status npm version

Convert xls files to JSON in NodeJS

Install

npm i xls-to-json

Usage

node_xj = require("xls-to-json");
node_xj(
	{
		input: "sample.xls", // input xls
		output: "output.json", // output json
		sheet: "sheetname", // specific sheetname
		rowsToSkip: 5, // number of rows to skip at the top of the sheet; defaults to 0
		allowEmptyKey: false, // avoids empty keys in the output, example: {"": "something"}; default: true
	},
	function (err, result) {
		if (err) {
			console.error(err);
		} else {
			console.log(result);
		}
	}
);

In config object, you have to enter an input path. But If you don't want to output any file you can set to null.

License

MIT @chilijung

Readme

Keywords

Package Sidebar

Install

npm i xls-to-json

Weekly Downloads

3,289

Version

2.1.1

License

MIT

Unpacked Size

5.52 kB

Total Files

7

Last publish

Collaborators

  • chilijung
  • rodrigograca31