hi guys,
what is the best practice around exporting to XLSX ? I’m looking at sheetjs (https://github.com/SheetJS/js-xlsx), but will be willing to look at anything.
there are these concepts of “virtual rendering” which are causing some issues while export. I’m not sure if I have do something to get this to work well
Hi @sss
currently we’re offering only an export to .csv
https://github.com/SheetJS/js-xlsx looks promising for a first glace but I’ve never used it so I can’t say how it would handle Handsontable.
hi aleksandra,
im unclear on how to get csv export working. the documentation is a bit unclear and how to build the button that exports the data.
can you point me to anything - including whether we need to set any special flags for virtual rendering (like what was asked here - https://github.com/handsontable/handsontable/issues/420#issuecomment-85483326)
Hi @sss
Please take a minute to check this tutorial (with a demo) https://docs.handsontable.com/pro/1.1.1/demo-export-file.html and if you’ll have any additional questions do not hesitate to ask.
It’s off topic but since externals work well with Handsontable … Perl has two modules that
allow you to programatically export your data directly into an xsl or xslx spreadsheet with
as many tabs as needed.