Hi
I have a webix spreadsheet, and I am trying to export it using the webix.toExcel().
Below is the code snippet
webix.toExcel($$("ssheet"), { download: false, sheets: true }).then(function(blob) { // blob is sent to server and processed there }
I have a few columns that are hidden in my webix spreadsheet. I find that they dont get exported to the blob and onto my app server. Is there a way, I can enable of the hidden rows and columns.
Thanks
Comments
Hi @rsant
There is no such feature, but you can try this workaround:
https://snippet.webix.com/mk2ej4sh
Thanks this helps
Hi @Dima_S
I had a follow up question on this. I found that this works fine when the columns are hidden. But it does not pick up the rows that are hidden. Is there a feature to export the hidden rows as well.
Thanks
Hi @rsant
The only possibility I found is to serialize spreadsheet before exporting (to save hidden rows and columns), show them, export and hide them again.
Example: https://snippet.webix.com/bpyzyn5o
Thanks @Dima_S .. this could work for me.