Hi,
I have tried to export to excel from Handsontable in react. After using exportPlugin.downloadFile the file downloaded but the color(conditional formatting) not applied properly. Is there any other way to achieve this use cases.
Please find the sample link: https://jsfiddle.net/46feo9c5/
Hi @MuthuAbimannan
Handsontable allows exporting only to a CSV file. The CSV file does not contain styling, formatting. It shows raw data. Here is a related topic I want to export CSV file without HTML
Thanks for the quick reply.
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.
Docs: Export to Excel
Release Announcement: Handsontable 17.1.0: Export to Excel, Server-Side Row Model, and Built-in Toasts