'how can I add nestead array of objects using convert-excel-to-json
I am trying to insert data from excel sheet using convert-excel-to-json npm. I am able to basic format of my data but i want to add also images as a nested array.
Here Is my code:
app.post("/upload-excel", async (req, res) => {
const newpath = __dirname + "/files/";
const file = req.files.file;
const filename = file.name;
const worksheetsArray = xlsx.parse(filename); // parses a file
const excelData = excelToJson({
sourceFile: filename,
sheets: [{
// Excel Sheet Name
name: worksheetsArray[0].name,
// Header Row -> be skipped and will not be present at our result object.
header: {
rows: 1
},
// Mapping columns to keys
columnToKey: {
A: '_id',
B: 'name',
C: 'address',
D: 'age',
}
}]
});
console.log(excelData);
});
The above code output is:
{
Customers: [
{ _id: 1, name: 'Jack Smith', address: 'Massachusetts', age: 23 },
{ _id: 2, name: 'Adam Johnson', address: 'New York', age: 27 },
{
_id: 3,
name: 'Katherin Carter',
address: 'Washington DC',
age: 26
},
{ _id: 4, name: 'Jack London', address: 'Nevada', age: 33 },
{ _id: 5, name: 'Jason Bourne', address: 'California', age: 36 }
]
}
The expected output is: Here i have added extra images
{
Customers: [
{ _id: 1, name: 'Jack Smith',images:[{id:1, src:"sadasd.com"}], address: 'Massachusetts', age: 23 },
{ _id: 2, name: 'Adam Johnson', address: 'New York',images:[{id:1, src:"sadasd.com"}] age: 27 },
{
_id: 3,
name: 'Katherin Carter',
address: 'Washington DC',
age: 26,
images:[{id:1, src:"sadasd.com"}, {id:1, src:"sadasd.com"}],
{ _id: 4, name: 'Jack London', address: 'Nevada',images:[{id:1, src:"sadasd.com"}], {id:1, src:"sadasd.com"}], age: 33 },
{ _id: 5, name: 'Jason Bourne',images:[{id:1, src:"sadasd.com"}, address: 'California', age: 36 }
]
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
