Parse xls into json
npm install xls-parser
npm install xls-parser
``
$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 'xls-parser';
xlsxParser
.onFileSelection(file)
.then(data => {
var parsedData = data;
});
``
``
...
...
``
Example using AngularJS
Install
``
npm install ng-file-upload
npm install xls-parser
``
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 xlsParser = require('xls-parser');
vm.uploadFile = function(file){
xlsParser.onFileSelection(file)
.then((data) => {
vm.data = data;
});
}
},
controllerAs: 'vm'
});
``
index.html
``
XLS-Parser
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
}
]
}
```