[Advanced Excel] How we can hide particular column values from user using Advanced Excel widget
excel-png
Web icon
Forge component by Carlos Freitas
Application Type
Traditional Web

Hi all,

I want to hide particular column of excel sheet from user, this is because as user import same excel sheet after changes , i can able to perform operation using that column id.

Suppose, as mention in image, there is column contain names and another column is id, after changing names from user, user will import same excel sheet and i will update in table using id mention in another table. 


So, i do not wish to display that id to user. How can hide in excel using Advanced Excel widget 

Capture.JPG

You can use Column_Hide_Show method to hide any particular column in the worksheet. Given in AdvancedExcel demo as well.

Regards

Hi @Vikas Sharma ,

Thank you for time but it is just collapsing column, user can see it if he drag out. I want to hide value completely from there


Thank you

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.