convert json 2 csv and download it
npm install json-2-csv-tsConverts json to csv
Install
``bash`
$ npm install json-2-csv-ts --save
`javascript
import { json2csv } from 'json-2-csv-ts';
const myData = {
id:"id",
name:"name",
comments:[
"first",
"second",
"third"
]
}
try {
var result = json2csv(myData)
console.log(result);
} catch (err) {
console.error(err);
}
`
- data - Required Array or Objectoptions
- expandArray
- - whether u need to expand an array as new row.download
- true(default) expandArray true example
- false expandArray false example
- - whether u need download csv.fileName
- false(default)
- - default fileName is 'default.csv'
`javascript
import { json2csv } from 'json-2-csv-ts';
const myData = {
id:"id",
name:"name",
comments:[
"first",
"second",
"third"
]
}
try {
var result = json2csv(myData,{
expandArray:true
})
console.log(result);
} catch (err) {
console.error(err);
}
`
The result should be
``
id,name,comments
"id",name,"first"
,,"second"
,,"third"
The csvFile looks like
| id | name | comments |
| -- | ---- | -------- |
| id | name | first |
| | | second |
| | | third |
`javascript
import { json2csv } from 'json-2-csv-ts';
const myData = {
id:"id",
name:"name",
comments:[
"first",
"second",
"third"
]
}
try {
var result = json2csv(myData,{
expandArray:false
})
console.log(result);
} catch (err) {
console.error(err);
}
`
The result should be
``
id,name,comments
"id",name,"first,second,third"
The csvFile looks like
| id | name | comments |
| -- | ---- | -------- |
| id | name | first,second,third |
`javascript
import { json2csv } from 'json-2-csv-ts';
const myData = [
{
id:"1",
name:"test"
},
{
id:"2",
des:"desc"
}
]
try {
var result = json2csv(myData,{
expandArray:true
})
console.log(result);
} catch (err) {
console.error(err);
}
`
The result should be
```
id,name,des
"1","test",
"2",,"desc"
The csvFile looks like
| id | name | des |
| -- | ---- | -------- |
| 1 | test | |
| 2 | | desc |