Export to json

Tags: #<Tag:0x00007efc647674d0>
#1

Can we export the entire table as json ?

#2

Yeah, sure. Use getData method and JSON.stringify() the result.

#3

Can we export features like merged cells, freezed columns, readonly columns, hidden columns along with the json data. And later when the table is constructed using JSON, all these properties are re-applied to the table.
If its not possible through json, then is there any other way that we can remember all the changes done in table even if we log in table later as well.

A working demo in angular would be really helpful

#4

Hey @thakurshivam100

export to .csv exports only raw data. You can check how your table is exported by calling getData() method. The .CSV format doesn’t allow us to pass metadata so custom renderer, formatting, merging, colors are all gone.
We are planning to support export to .XLSX that will pass all the metadata but there’s no ETA for it yet.

#5