Export to Excel/CSV with formatting and styling

Questions
1

Hi,

I want the grid data to to be exported to Excel with some formatting and styling in it.
For Eg.

  1. Having multiple sheets
  2. Merging rows/columns
  3. Giving styling to Headers like setting different font, font-size.
  4. Showing Headers in multi-line. Eg. (showing Units (with smaller font-size) below Headers in same row).

Are these things possible (in handsontable and while exporting to excel)? Can you please give me some example for what things are possible from above points?

2

Good day @kbharambe

our export to file option allows only an export to .csv file. The following file does not support formatting or styling - only raw data.

4

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