Hi ,
Is there a way to format the excel which is exported from the handsontable plugin ? Currently the excel contains the columns which are present in the table. Is there a way to add few extra fields which are not available inisde the handsontable into the excel ?
Export excel formatting
Hi @alikhodja
sure, you can use this demos https://docs.handsontable.com/pro/1.14.3/demo-hiding-rows.html and https://docs.handsontable.com/pro/1.14.3/demo-hiding-columns.html to hide columns and rows that contain sensitive data.
Hi ,
Thanks for the reply 
The issue here is , we have a handsontable which has certain number of columns. I need that to be displayed in the excel , also in addition to that 3 fields should be added to it which is not configured in the handsontable. For eg , adding the username, details on top of the table. But that would not be available inside the handsontable in the UI.
Oh I see. So just before the export to Excel you would need to show the columns and then hide them right after the table get’s exported. Would that be suitable for your project?
Hi ,
I am attaching two screenshots for your reference. Actually the problem here is , we do not have those extra fields inside the handsontable grid. The data needs to be stored somewhere and when export excel is clicked , they expect it to be a separate section above the columns , inside the excel.
Handsontable can export only what’s a part of Handsontable data source + headers (if not nested).