C# Class Smrf.NodeXL.ExcelTemplate.WorkbookAutoFiller

Automatically fills one or more edge and vertex attribute columns by mapping values from user-specified source columns.
Call the AutoFillWorkbook method to autofill one or more edge and vertex attribute columns. The method takes an object that specifies one or more source-to-destination column mappings. For example, the settings might specify that the vertex color column should be autofilled by mapping the numbers in a numeric source to a specified range of colors, and that the edge width column should be autofilled by mapping the numbers in another numeric source column to a specified range of widths.

All methods are static.

Inheritance: Object
Show file Open project: 2014-sed-team3/term-project Class Usage Examples

Public Methods

Method Description
AutoFillWorkbook ( Microsoft workbook, AutoFillUserSettings autoFillUserSettings ) : void

Private Methods

Method Description
AutoFillColumnViaCopy ( ListObject oTable, String sSourceColumnName, String sDestinationColumnName ) : System.Boolean
AutoFillEdgeTable ( ListObject oEdgeTable, AutoFillUserSettings oAutoFillUserSettings, AutoFillWorkbookResults oAutoFillWorkbookResults ) : void
AutoFillGroupTable ( ListObject oGroupTable, AutoFillUserSettings oAutoFillUserSettings, AutoFillWorkbookResults oAutoFillWorkbookResults ) : void
AutoFillNumericComparisonColumn ( ListObject oTable, String sSourceColumnName, String sDestinationColumnName, NumericComparisonColumnAutoFillUserSettings oDetails ) : void
AutoFillTable ( Microsoft oWorkbook, AutoFillUserSettings oAutoFillUserSettings, AutoFillWorkbookResults oAutoFillWorkbookResults, String sWorksheetName, String sTableName, AutoFillTableMethod oAutoFillTableMethod ) : void
AutoFillVertexTable ( ListObject oVertexTable, AutoFillUserSettings oAutoFillUserSettings, AutoFillWorkbookResults oAutoFillWorkbookResults ) : void
AutoFillWorkbookInternal ( Microsoft oWorkbook, AutoFillUserSettings oAutoFillUserSettings ) : void
PrependGroupLabelsWithGroupNames ( ListObject oGroupTable ) : void
TryAutoFillColorColumn ( ListObject oTable, String sSourceColumnName, String sDestinationColumnName, ColorColumnAutoFillUserSettings oDetails, System.Boolean &bSourceColumnContainsNumbers, Double &dSourceCalculationNumber1, Double &dSourceCalculationNumber2, Int32 &iDecimalPlaces, ICollection &oCategoryNames ) : System.Boolean
TryAutoFillNumericRangeColumn ( ListObject oTable, String sSourceColumnName, String sDestinationColumnName, NumericRangeColumnAutoFillUserSettings oDetails, Double &dSourceCalculationNumber1, Double &dSourceCalculationNumber2, Int32 &iDecimalPlaces ) : System.Boolean

Method Details

AutoFillWorkbook() public static method

public static AutoFillWorkbook ( Microsoft workbook, AutoFillUserSettings autoFillUserSettings ) : void
workbook Microsoft
autoFillUserSettings AutoFillUserSettings
return void