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.
UPDATE! As of v17.1, Export to Excel is now supported! You can download the file to the user’s machine, or export it as a blob for upload to your backend. The exported file respects the same column filters and sorting that the user sees.