xlsx-parse-json #

$3

Parse csv, xls, xlsx into json. Having multiple sheets is not an issue we return and object for each sheet found. See example below for more info. Visit https://abelalvarez.info/xlsx-parse-json/ to test it online.

$3

```
npm install xlsx-parse-json
``

$3

To use this library you need to have already the file uploaded, there are many libraries out there to select a file from your system. In the example below I provided an HTML(bootstrap) snippet and a JS snippet, of the components you need to have.
Example
``
import xlsxParser from 'xlsx-parse-json';

xlsxParser
.onFileSelection(file)
.then(data => {
var parsedData = data;
});

``

``

...

Example file input

...


``

Example using AngularJS
Install
``
npm install ng-file-upload
npm install xlsx-parse-json
``
index.js
``
'use strict';

var angular = require('angular');

require('ng-file-upload');

angular.module('test-xls-parser', ['ngFileUpload'])
.component('testXlsParserUpload', {
template: '

{{vm.data | json}}

',
controller: function() {
var vm = this;
var xlsxParser = require('xlsx-parse-json');

vm.uploadFile = function(file){
xlsxParser.onFileSelection(file)
.then((data) => {
vm.data = data;
});
}
},
controllerAs: 'vm'
});

``
index.html
``









loading




``

input file #

$3

``
Price | Name
-----------------
4 | a
8 | b
9 | c
4 |
``

$3

``
Name | Lastname | Age
-------------------------
Nico | Jhones | 69
Carl | | 4
Abel | | 30
Gabe | |

``

output sample #

``
{
"Test": [
{
"Price": 4,
"Name": "a"
},
{
"Price": 8,
"Name": "b"
},
{
"Price": 9,
"Name": "c"
},
{
"Price": 4
}
],
"Sheet1": [
{
"Name": "Nico",
"Lastname": "Jhones",
"Age": 69
},
{
"Name": "Carl",
"Age": 4
},
{
"Name": "Abel",
"Age": 55
},
{
"Name": "Gabe"
}
]
}
``

$3

There are optional parameters to show. They should be provided in the second argument
``
The default values are { showNullProperties = false, hideEmptyRows = true }
onFileSelection = (file, { showNullProperties = false, hideEmptyRows = true })
``

Setting showNullProperties = true; will show all properties on every object example

input file #

$3

``
Price | Name
-----------------
4 | a
8 | b
| c
4 |

``

output sample #

``
{
"Test": [
{
"Price": 4,
"Name": "a"
},
{
"Price": 8,
"Name": "b"
},
{
"Price": null,
"Name": "c"
},
{
"Price": 4
"Name": null
}
]
}
``

Setting { showNullProperties = true hideEmptyRows = false } will show all properties on every object example including empty rows with null values

input file #

$3

``
Price | Name
-----------------
4 | a
8 | b
|
| c
4 |

``

output sample #

``
{
"Test": [
{
"Price": 4,
"Name": "a"
},
{
"Price": 8,
"Name": "b"
},
{
"Price": null,
"Name": null
},
{
"Price": null,
"Name": "c"
},
{
"Price": 4
"Name": null
}
]
}
```