Based on Role and Status show and Hide columns

Based on Role and Status show and Hide columns

Posted by: srinivasan.lakshmanan on 23 July 2018, 2:02 am EST

• 

  srinivasan.lakshmanan

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 July 2018, 2:02 am EST

  Hi,

  How to show/Hide columns in Excel sheet based on the User?

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 23 July 2018, 7:39 am EST

  Hello,

  You can hide the or unhide the column using the code as follows:

  activeSheet.setColumnVisible(2,false,GC.Spread.Sheets.SheetArea.viewport);

  You can also reduce the column width to 0 in order to hide it based your user name.

  Thanks,
  
  Deepak Sharma