How do I import an excel sheet into a HTML table , such that every row can be converted into an Object, based on the Column Names. Using Angular JS
P.S: The Objects are needed for the future sorted tables .
1
-
You may find some answers here : stackoverflow.com/questions/18450259/… and here : stackoverflow.com/questions/30765389/…Mistalis– Mistalis2016-06-14 11:31:19 +00:00Commented Jun 14, 2016 at 11:31
Add a comment
|
1 Answer
I have developed a component for that. Please take a look if it helps you: https://github.com/Helvio88/angular-xlsx-model
Using
<input type="file" xlsx-model="excel">
will give you the ability to select a file.
For multiple files:
<input type="file" xlsx-model="excel" multiple>
It can be further extended to filter out specific extensions and so on. Refer to http://www.w3schools.com/jsref/dom_obj_fileupload.asp
Once you select a file, an Angular JSON object named after the xlsx-model attribute (in this case 'excel') will be created in this format:
$scope.excel (multiple files):
{
"file1.xlsx": {
"Sheet1": [
{
"Col1Name": "Row1Col1_Value",
"Col2Name": "Row1Col2_Value"
},
{
"Col1Name": "Row2Col1_Value",
"Col2Name": "Row2Col2_Value"
}
],
"Sheet2" : [...]
},
"file2.xlsx": {...}
}
That model is valid if you've selected multiple files. For a single file, it's slightly different.
$scope.excel (single file):
{
"Sheet1": [
{
"Col1Name": "Row1Col1_Value",
"Col2Name": "Row1Col2_Value"
},
{
"Col1Name": "Row2Col1_Value",
"Col2Name": "Row2Col2_Value"
}
],
"Sheet2" : [...]
}
Playground: http://plnkr.co/edit/inETA0PcxIkm4EmS9qjD?p=preview
