xls export is giving output without table structure.
kunal1697 opened this issue · 4 comments
I am trying to export file type xsl but after the export the file is getting generated but the Excel table structure is gone will get Excel will blank white sheet with values.
Can you provide a copy of the sample data?
`[
{
"ID": "Dummy",
"SNAPSHOT_DATE": "Dummy",
"LOT_NUMBER": "Dummy",
"FUNDFAMILY_NAME": "Dummy",
"LAST_UPDATED_DATE": "Dummy",
"STATUS_ID": "Dummy",
"ETA_WORKING_DAY": "Dummy",
"ETA_EXPECTED_DATE": "Dummy",
"TOTAL_EXPECTED_FUND": "Dummy",
"COMMENTS": null,
"FREQUENCY_TYPE": "Dummy",
"Status": "True"
},
{
"ID": "Dummy",
"SNAPSHOT_DATE": "Dummy",
"LOT_NUMBER": "Dummy",
"FUNDFAMILY_NAME": "Dummy",
"LAST_UPDATED_DATE": "Dummy",
"STATUS_ID": "Dummy",
"ETA_WORKING_DAY": "Dummy",
"ETA_EXPECTED_DATE": "Dummy",
"TOTAL_EXPECTED_FUND": "Dummy",
"COMMENTS": null,
"FREQUENCY_TYPE": "Dummy",
"Status": "True"
},
] ` this is my json data.
This is my code:
`const fileName = `MonthlyStaging_${new Date().toJSON().slice(0, 10)}`
const exportType = exportFromJSON.types.xls
const monthlyStagingData = data.data.map(e => ({
"Snapshot_Date": e.SNAPSHOT_DATE == null ? "-" : moment(e.SNAPSHOT_DATE).format(
"YYYY-MM-DD"),
"Lot_No": e.LOT_NUMBER == null ? "-" : e.LOT_NUMBER,
"Fund_Family": e.FUNDFAMILY_NAME == null ? "-" : e.FUNDFAMILY_NAME,
"Last_Updated_Date": e.LAST_UPDATED_DATE == null ? "-" : moment(e.LAST_UPDATED_DATE).format(
"YYYY-MM-DD"),
"ETA_Working_Day": e.ETA_WORKING_DAY == null ? "-" : moment(e.ETA_WORKING_DAY).format(
"YYYY-MM-DD"),
"ETA_Exp_Day": e.ETA_EXPECTED_DATE == null ? "-" : moment(e.ETA_EXPECTED_DATE).format(
"YYYY-MM-DD"),
"Total_Exp_Fund": e.TOTAL_EXPECTED_FUND == null ? "-" : e.TOTAL_EXPECTED_FUND,
"Status": e.STATUS_ID == null ? "-" : e.STATUS_ID,
"Frequency": e.FREQUENCY_TYPE == null ? "-" : e.FREQUENCY_TYPE
}))
exportFromJSON({ data: monthlyStagingData, fileName: fileName, exportType: exportType });`
This is is my dependent version
"export-from-json":"^1.7.2"
I tested your data and it seems to work fine.
Ok I have tested it there was some problem with Microsoft excel you can close the issue thanks