Open dijitha opened 11 years ago
When i read an excel file using office module of node.js i got the output as { cell: [ { row: 0, col: 0, '$t': 'hello' }, { row: 0, col: 1, '$t': 'test' } ] } { cell: [ { row: 1, col: 0, '$t': 1 }, { row: 1, col: 1, '$t': 2 } ] } { cell: [ { row: 2, col: 0, '$t': 2 }, { row: 2, col: 1, '$t': 3 } ] }
But i need the output as correct json format like [ { hello: '1', test: '2' }, { hello: '2', test: '3' } ].
Can anyone help in getting this
When i read an excel file using office module of node.js i got the output as { cell: [ { row: 0, col: 0, '$t': 'hello' }, { row: 0, col: 1, '$t': 'test' } ] } { cell: [ { row: 1, col: 0, '$t': 1 }, { row: 1, col: 1, '$t': 2 } ] } { cell: [ { row: 2, col: 0, '$t': 2 }, { row: 2, col: 1, '$t': 3 } ] }
But i need the output as correct json format like [ { hello: '1', test: '2' }, { hello: '2', test: '3' } ].
Can anyone help in getting this