xls-to-json

node-xls-json

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