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 ?
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
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.
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).
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.