node-excel-export icon indicating copy to clipboard operation
node-excel-export copied to clipboard

Support for nested JSON object missing

Open dronzer1010 opened this issue 7 years ago • 6 comments

Hello ,

I have a very large dataset that I wanted to export in excel , issue is my dataset contains nested JSON values as well . Can you please let me know a way to do this? or if you have not added support for nested JSON , please add it.

dronzer1010 avatar Apr 25 '17 03:04 dronzer1010

Can you describe what you imagine the end result should look like?

andreyan-andreev avatar Apr 25 '17 06:04 andreyan-andreev

Same problem here. Is it possible to call a nested JSON Property? for instance: is it possible to call "billingAddress.street"?

{
    name: 'Enrique',
    billingAddress : {
        street: '5th',
        city:'CUU'
    }
}
``

guenruiz avatar Oct 30 '17 01:10 guenruiz

@guenruiz were you able to do this?

omardlhz avatar Mar 21 '18 20:03 omardlhz

I was able to do it by restructuring my object to be flatter but it was not efficient at all. I now need to merge every 4 rows and the merges array is getting so large that I run out of memory. This library definitely needs more work.

am2367 avatar Sep 30 '18 22:09 am2367

@am2367 my PR supports nested objects, take a look at it here.

omardlhz avatar Sep 30 '18 22:09 omardlhz

@omardlhz Thanks I will take a look.

am2367 avatar Sep 30 '18 22:09 am2367