Export to Excel/CSV with formatting and styling

Getting help 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.