Natty Precise Maverick

    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

    Keywords

    Install

    npm i xls-to-json

    DownloadsWeekly Downloads

    17,470

    Version

    2.1.1

    License

    MIT

    Unpacked Size

    5.52 kB

    Total Files

    7

    Last publish

    Collaborators

    • chilijung
    • rodrigograca31