GetHiddenColumns Method

'Declaration
 
Public Function GetHiddenColumns( _
   ByVal worksheet As Worksheet, _
   Optional ByVal createIfNull As System.Boolean _
) As HiddenColumnCollection

public HiddenColumnCollection GetHiddenColumns( 
   Worksheet worksheet,
   System.bool createIfNull
)

Parameters

worksheet

The worksheet whose associated hidden columns are to be retrieved.

createIfNull

True to create the hidden column if it has not yet been allocated of the Worksheet. The options will be initialized based on the current state. Note the options should only have been null if there were no options for the Worksheet when the Workbook was loaded. Also this will not allocate the collection unless the SaveHiddenRowsAndColumns is true.

Return Value

Adding columns on the returned HiddenColumnCollection instance will not actually hide columns in the worksheet. After modifying the hidden columns in this collection, the Apply method of the CustomView will hide or unhide the columns.

Target Platforms: Windows 8.1, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

CustomView Class
CustomView Members
Hidden Property
SaveHiddenRowsAndColumns Property