C# Class Smrf.NodeXL.ExcelTemplate.TableColumnAdder

Adds columns to an Excel table (ListObject), and finds the columns that were added.
Use AddColumnPair to add a pair of columns to a table. Use GetColumnPairNames to get a collection of all the columns pairs that were added.
Inheritance: Object
Afficher le fichier Open project: 2014-sed-team3/term-project Class Usage Examples

Méthodes publiques

Méthode Description
AddColumnPair ( Microsoft workbook, String worksheetName, String tableName, String column1NameBase, Double column1WidthChars, String column2NameBase, Double column2WidthChars ) : void
GetColumnPairNames ( ListObject table, String column1NameBase, String column2NameBase ) : String>>.ICollection
TableColumnAdder ( ) : System

Initializes a new instance of the TableColumnAdder class.

Méthodes protégées

Méthode Description
GetColumnNameRegex ( String sColumnNameBase ) : Regex
GetMaximumAppendedNumber ( ListObject oTable, String sColumnNameBase ) : Int32

Private Methods

Méthode Description
AssertValid ( ) : void

Method Details

AddColumnPair() public méthode

public AddColumnPair ( Microsoft workbook, String worksheetName, String tableName, String column1NameBase, Double column1WidthChars, String column2NameBase, Double column2WidthChars ) : void
workbook Microsoft
worksheetName String
tableName String
column1NameBase String
column1WidthChars Double
column2NameBase String
column2WidthChars Double
Résultat void

GetColumnNameRegex() protected méthode

protected GetColumnNameRegex ( String sColumnNameBase ) : Regex
sColumnNameBase String
Résultat System.Text.RegularExpressions.Regex

GetColumnPairNames() public méthode

public GetColumnPairNames ( ListObject table, String column1NameBase, String column2NameBase ) : String>>.ICollection
table ListObject
column1NameBase String
column2NameBase String
Résultat String>>.ICollection

GetMaximumAppendedNumber() protected méthode

protected GetMaximumAppendedNumber ( ListObject oTable, String sColumnNameBase ) : Int32
oTable ListObject
sColumnNameBase String
Résultat System.Int32

TableColumnAdder() public méthode

Initializes a new instance of the TableColumnAdder class.
public TableColumnAdder ( ) : System
Résultat System