Installation
npm install wk-csv-jsonUsage
inputToJSON method
// on your component.ts
import { inputToJSON } from 'wk-csv-json'
public csv
fileChange(event) {
const file = event.target.files
inputToJSON(file).then((data) => {
this.csv = data
})
}<!-- on your component.html -->
<input type="file" (change)="fileChange($event)" />Sample CSV file
| id | first name | last name | |
|---|---|---|---|
| 1 | Letizia | Dominy | Letizia.Dominy@yopmail.com |
| 2 | Wilma | Therine | Wilma.Therine@yopmail.com |
Sample Output (Headers true)
{
data: [
{
"id": 1,
"firstname": "Letizia",
"lastname": "Dominy",
"email": "Letizia.Dominy@yopmail.com"
},
{
"id": 2,
"firstname": "Wilma",
"lastname": "Therine",
"email": "Wilma.Therine@yopmail.com"
}
],
message: "Conversion complete"
}Sample Output (Headers false)
{
data: [
{
"value": ["id", "first name", "last name", "email"]
},
{
"value": [1, "Letizia", "Dominy", "Letizia.Dominy@yopmail.com"]
},
{
"value": [2, "Wilma", "Therine", "Wilma.Therine@yopmail.com"]
}
],
message: "Conversion complete"
}csvToJSON method
// on your component.ts
this.csv = csvToJSON(
"id,name,email\n1,Letizia Dominy,Letizia.Dominy@yopmail.com"
);Output (Headers true)
{
data: [
{
"id": 1,
"name": "Letizia Dominy",
"email": "Letizia.Dominy@yopmail.com"
}
],
message: "Conversion complete"
}Output (Headers false)
{
data: [
{
"value": ["id", "name", "email"]
},
{
"value": [1, "Letizia Dominy", "Letizia.Dominy@yopmail.com"]
}
],
message: "Conversion complete"
}inputToJSON(target, headers)
| Parameters | Type | Default | Description |
|---|---|---|---|
| target | FileList | The CSV file to be converted to JSON | |
| headers | Boolean | true | Use the header as key |
csvToJSON(target, headers)
| Parameters | Type | Default | Description |
|---|---|---|---|
| target | String | The CSV string to be converted to JSON | |
| headers | Boolean | true | Use the header as key |
if headers parameter is true, it uses the first line in CSV as headers.
Future
Convert plain CSV (Not from file) to JSON - Added
Convert JSON to CSV