Webix spreadsheet export to excel hidden columns/rows

rsant

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

Dima_S

Hi @rsant

There is no such feature, but you can try this workaround:

https://snippet.webix.com/mk2ej4sh

rsant

Thanks this helps

rsant

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

Dima_S

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

rsant

Thanks @Dima_S .. this could work for me.