xls-to-json

Converting xls file to json files using nodejs

Usage no npm install needed!

<script type="module">
  import xlsToJson from 'https://cdn.skypack.dev/xls-to-json';
</script>

README

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