Questions tagged [json2xls]
11 questions
2
votes
0 answers
Angular 4 Json to Excel or csv
So I have a large data chunk I want to export to work on excel, I have tried angular2-json2csv and angular2-csv and they download the data to a csv file but the issue is that I have several includes into my data format, nested objects that return…
V. Benavides
- 533
- 1
- 7
- 21
2
votes
2 answers
Node json2xls downloadable file
I have the following (simple) node module:
var json2xls = require('json2xls');
var fs = require('fs');
module.exports = function (router, mongoose) {
router.route('/client/toExcel')
.post(function (req, res) {
var obj =…
Marc Rasmussen
- 19,771
- 79
- 203
- 364
1
vote
1 answer
How to change the position of header columns of excel file using NodeJS
I have a dynamic JSON data fro which I am creating a Excel file using jsno2xls library nut here the resulting excel file header are like Year,DOB,Name and Age and I want excel data in this format Name,Age,DOB and Year.Is there any way I can perform…
Digvijay
- 2,887
- 3
- 36
- 86
1
vote
1 answer
Set hyperlink in excel sheet using Node js
I have converted JSON data to excel in node js using the json2xls package. The Excel file was prepared properly but I want to add a hyperlink for some cells in the sheet.
So it is possible using json2xls or any package in node js?
Vishal Patel
- 97
- 9
1
vote
1 answer
How to download whole collection with more than 500k records as csv with nodejs from mongodb?
I have tried this with npm package called json2csv.
It is working fine for records up to 75 000. when the data is more than that i am not getting any response from the callback function exporttocsv as given below.
const json2csv =…
Jagadeesh
- 1,967
- 8
- 24
- 47
1
vote
0 answers
How to add header style in json2xls?
Hi how do I add background color in the header in my xls file using json2xls in nodejs?
var xls = json2xls(data, {// should I add it here?});
Thanks :)
Vinia
- 46
- 5
1
vote
3 answers
Angular 4 : Export JSON to CSV
I need some help to export a JSON to CSV in Angular 4.
Is there any ready made external plugin to serve my requirement.
I have found one plugin json2csv. But I have no idea how to use it in Angular 4.
Suvonkar
- 2,440
- 12
- 34
- 44
0
votes
1 answer
How to configure column width using json2xls options
I am currently using json2xls to export my queried data in json format into a xlsx file like so:
var xls = tool.json2xls(data, {order:["NAME", "OWNER_EMAIL", "GROUP", "BRAND", "DOC_CENTER_URL", "LIBRARYURL", "TOTAL_VIEWS"],
…
Riley Eaton
- 137
- 12
0
votes
0 answers
Send json2xml file from Firebase Function
I'm trying to create an Excel file in a firebase function.
Running locally, this writes an xls file.
const xls = json2xls(data);
fs.writeFileSync(`${filename}.xlsx`, xls, 'binary');
But run in a firebase function, this downloads a broken file. …
nicholas
- 14,184
- 22
- 82
- 138
0
votes
0 answers
Serialization of nested JSON
I'm trying to create a nested JSON object from a datatable (tblEmployees) with 9 rows. I have generated an object but it contains just repeats of the last data row. Have I missed something? The classes I have used are shown below with code…
user3359706
- 511
- 1
- 5
- 16
0
votes
0 answers
Node json2xls wont send file
according to the documentation json2xls
i should be able to do something like this:
router.route('/api2/course/session/attending')
.get(function (req, res) {
var jsonArr = [{
foo: 'bar',
qux: 'moo',
…
Marc Rasmussen
- 19,771
- 79
- 203
- 364