C# Class Smrf.AppLib.ExcelColumnHider

Hides and shows columns in an Excel workbook.

Call ShowHiddenColumns to show all the hidden columns in a table, then call RestoreHiddenColumns to hide them again. Use ShowColumns, HideColumns, and to show or hide a specified set of table columns.

All methods are static.

Show file Open project: 2014-sed-team3/term-project

Public Methods

Method	Description
HideColumns ( ListObject table, String columnNames ) : void
RestoreHiddenColumns ( ListObject table, ExcelHiddenColumns excelHiddenColumns ) : void
ShowColumns ( ListObject table, String columnNames ) : void
ShowHiddenColumns ( ListObject table ) : ExcelHiddenColumns
ShowOrHideColumn ( ListColumn column, System.Boolean show ) : System.Boolean
ShowOrHideColumn ( ListObject table, String columnName, System.Boolean show ) : System.Boolean
ShowOrHideColumns ( ListObject table, String columnNames, System.Boolean show ) : void

Method Details

HideColumns() public static method

public static HideColumns ( ListObject table, String columnNames ) : void
table	ListObject
columnNames	String
return	void

RestoreHiddenColumns() public static method

public static RestoreHiddenColumns ( ListObject table, ExcelHiddenColumns excelHiddenColumns ) : void
table	ListObject
excelHiddenColumns	ExcelHiddenColumns
return	void

ShowColumns() public static method

public static ShowColumns ( ListObject table, String columnNames ) : void
table	ListObject
columnNames	String
return	void

ShowHiddenColumns() public static method

public static ShowHiddenColumns ( ListObject table ) : ExcelHiddenColumns
table	ListObject
return	ExcelHiddenColumns

ShowOrHideColumn() public static method

public static ShowOrHideColumn ( ListColumn column, System.Boolean show ) : System.Boolean
column	ListColumn
show	System.Boolean
return	System.Boolean

ShowOrHideColumn() public static method

public static ShowOrHideColumn ( ListObject table, String columnName, System.Boolean show ) : System.Boolean
table	ListObject
columnName	String
show	System.Boolean
return	System.Boolean

ShowOrHideColumns() public static method

public static ShowOrHideColumns ( ListObject table, String columnNames, System.Boolean show ) : void
table	ListObject
columnNames	String
show	System.Boolean
return	void