Hiding Columns in export excel

Getting help Questions
1

Hi ,

We have a requirement in our project which requires hiding a specific column when export to excel is done. That change should reflect only on the Excel sheet , it should be visible in the UI side.

Tried the hiddenColumns plugin . Here the column gets hidden on the UI side as well.
Any method of implementing the above mentioned functionality ?

2

Hi @alikhodja

the hiddenColumns plugin allows you to hide the columns from UI

Please take a minute to check this example https://docs.handsontable.com/pro/1.14.2/demo-hiding-columns.html

3

Hi ,
I don’t want it to be hidden from the UI side. As per requirement , it should be shown on UI side. But while exporting the excel the column should be hidden in excel.

4

There is currently no way to hide columns/rows only in the Excel file. You can use a hack that will hide the columns before performing an export and then show them again, but I did not test it and it may look unpleasant (I expected column flashing).