C# Class Smrf.NodeXL.ExcelTemplate.TableColumnMapper

Object that maps the numbers in one table column to values in another column.

All methods are static.

Inheritance: Object

ファイルを表示 Open project: 2014-sed-team3/term-project

Public Methods

Method	Description
MapToTwoStrings ( ListObject table, String sourceColumnName, String destinationColumnName, ComparisonOperator comparisonOperator, Double sourceNumberToCompareTo, String destinationString1, String destinationString2 ) : void
MapViaCopy ( ListObject table, String sourceColumnName, String destinationColumnName ) : void
TryMapAverageColor ( IEnumerable rowIDsOfRowsToAverage, Object>.Dictionary rowIDDictionary, Double sourceCalculationNumber1, Double sourceCalculationNumber2, Color destinationColor1, Color destinationColor2, System.Boolean useLogs, Color &mappedDestinationColor ) : System.Boolean
TryMapAverageNumber ( IEnumerable rowIDsOfRowsToAverage, Object>.Dictionary rowIDDictionary, Double sourceCalculationNumber1, Double sourceCalculationNumber2, Double destinationNumber1, Double destinationNumber2, System.Boolean useLogs, Double &mappedDestinationNumber ) : System.Boolean
TryMapToColor ( ListObject table, String sourceColumnName, String destinationColumnName, System.Boolean useSourceNumber1, System.Boolean useSourceNumber2, Double sourceNumber1, Double sourceNumber2, Color destinationColor1, Color destinationColor2, System.Boolean ignoreOutliers, System.Boolean useLogs, Double &sourceCalculationNumber1, Double &sourceCalculationNumber2, Int32 &decimalPlaces ) : System.Boolean
TryMapToColor ( ListObject table, String sourceColumnName, String destinationColumnName, ICollection &categoryNames ) : System.Boolean
TryMapToNumericRange ( ListObject table, String sourceColumnName, String destinationColumnName, System.Boolean useSourceNumber1, System.Boolean useSourceNumber2, Double sourceNumber1, Double sourceNumber2, Double destinationNumber1, Double destinationNumber2, System.Boolean ignoreOutliers, System.Boolean useLogs, Double &sourceCalculationNumber1, Double &sourceCalculationNumber2, Int32 &decimalPlaces ) : System.Boolean

Private Methods

Method	Description
GetColorGradientMapper ( Double dSourceCalculationNumber1, Double dSourceCalculationNumber2, Color oDestinationColor1, Color oDestinationColor2 ) : ColorGradientMapper
GetDecimalPlaces ( ListObject oTable, String sSourceColumnName ) : Int32
GetLogIfRequested ( Double dNumber, System.Boolean bUseLog ) : Double
GetSourceRangeWithoutOutliers ( Range oVisibleSourceRange, Int32 iSourceNumbers, Double dMinimumSourceNumber, Double dMaximumSourceNumber, Double dMeanSourceNumber, System.Boolean bPositiveNumbersOnly, Double &dSourceRangeMinimum, Double &dSourceRangeMaximum ) : void
GetSourceStandardDeviation ( Range oVisibleSourceRange, Int32 iSourceNumbers, Double dMinimumSourceNumber, Double dMaximumSourceNumber, Double dMeanSourceNumber, System.Boolean bPositiveNumbersOnly ) : Double
GetVisibleNumbers ( Range oVisibleRange, System.Boolean bPositiveNumbersOnly ) : IEnumerable
MapSourceNumberToDestinationNumber ( Double dSourceNumberWithLog, Double dSourceCalculationNumberWithLog1, Double dSourceCalculationNumberWithLog2, Double dDestinationNumber1, Double dDestinationNumber2, System.Boolean bUseLogs ) : Double
TryGetAverageSourceNumber ( IEnumerable oRowIDsOfRowsToAverage, Object>.Dictionary oRowIDDictionary, System.Boolean bUseLogs, Double &dAverageSourceColumnNumberWithLog ) : System.Boolean
TryGetNumber ( Object oValue, System.Boolean bPositiveNumbersOnly, Double &dNumber ) : System.Boolean
TryGetNumber ( Object oValue, Double &dNumber ) : System.Boolean
TryGetSourceCalculationRange ( Range oVisibleSourceRange, System.Boolean bUseSourceNumber1, System.Boolean bUseSourceNumber2, Double dSourceNumber1, Double dSourceNumber2, System.Boolean bIgnoreOutliers, System.Boolean bPositiveNumbersOnly, Double &dSourceCalculationNumber1, Double &dSourceCalculationNumber2 ) : System.Boolean
TryGetSourceStatistics ( Range oVisibleSourceRange, System.Boolean bPositiveNumbersOnly, Int32 &iSourceNumbers, Double &dMinimumSourceNumber, Double &dMaximumSourceNumber, Double &dMeanSourceNumber ) : System.Boolean
TryGetVisibleSourceAndDestination ( ListObject oTable, String sSourceColumnName, String sDestinationColumnName, Range &oVisibleSourceRange, Range &oVisibleDestinationRange ) : System.Boolean

Method Details

MapToTwoStrings() public static method

public static MapToTwoStrings ( ListObject table, String sourceColumnName, String destinationColumnName, ComparisonOperator comparisonOperator, Double sourceNumberToCompareTo, String destinationString1, String destinationString2 ) : void
table	ListObject
sourceColumnName	String
destinationColumnName	String
comparisonOperator	ComparisonOperator
sourceNumberToCompareTo	Double
destinationString1	String
destinationString2	String
return	void

MapViaCopy() public static method

public static MapViaCopy ( ListObject table, String sourceColumnName, String destinationColumnName ) : void
table	ListObject
sourceColumnName	String
destinationColumnName	String
return	void

TryMapAverageColor() public static method

public static TryMapAverageColor ( IEnumerable rowIDsOfRowsToAverage, Object>.Dictionary rowIDDictionary, Double sourceCalculationNumber1, Double sourceCalculationNumber2, Color destinationColor1, Color destinationColor2, System.Boolean useLogs, Color &mappedDestinationColor ) : System.Boolean
rowIDsOfRowsToAverage	IEnumerable
rowIDDictionary	Object>.Dictionary
sourceCalculationNumber1	Double
sourceCalculationNumber2	Double
destinationColor1	Color
destinationColor2	Color
useLogs	System.Boolean
mappedDestinationColor	Color
return	System.Boolean

TryMapAverageNumber() public static method

public static TryMapAverageNumber ( IEnumerable rowIDsOfRowsToAverage, Object>.Dictionary rowIDDictionary, Double sourceCalculationNumber1, Double sourceCalculationNumber2, Double destinationNumber1, Double destinationNumber2, System.Boolean useLogs, Double &mappedDestinationNumber ) : System.Boolean
rowIDsOfRowsToAverage	IEnumerable
rowIDDictionary	Object>.Dictionary
sourceCalculationNumber1	Double
sourceCalculationNumber2	Double
destinationNumber1	Double
destinationNumber2	Double
useLogs	System.Boolean
mappedDestinationNumber	Double
return	System.Boolean

TryMapToColor() public static method

public static TryMapToColor ( ListObject table, String sourceColumnName, String destinationColumnName, System.Boolean useSourceNumber1, System.Boolean useSourceNumber2, Double sourceNumber1, Double sourceNumber2, Color destinationColor1, Color destinationColor2, System.Boolean ignoreOutliers, System.Boolean useLogs, Double &sourceCalculationNumber1, Double &sourceCalculationNumber2, Int32 &decimalPlaces ) : System.Boolean
table	ListObject
sourceColumnName	String
destinationColumnName	String
useSourceNumber1	System.Boolean
useSourceNumber2	System.Boolean
sourceNumber1	Double
sourceNumber2	Double
destinationColor1	Color
destinationColor2	Color
ignoreOutliers	System.Boolean
useLogs	System.Boolean
sourceCalculationNumber1	Double
sourceCalculationNumber2	Double
decimalPlaces	System.Int32
return	System.Boolean

TryMapToColor() public static method

public static TryMapToColor ( ListObject table, String sourceColumnName, String destinationColumnName, ICollection &categoryNames ) : System.Boolean
table	ListObject
sourceColumnName	String
destinationColumnName	String
categoryNames	ICollection
return	System.Boolean

TryMapToNumericRange() public static method

public static TryMapToNumericRange ( ListObject table, String sourceColumnName, String destinationColumnName, System.Boolean useSourceNumber1, System.Boolean useSourceNumber2, Double sourceNumber1, Double sourceNumber2, Double destinationNumber1, Double destinationNumber2, System.Boolean ignoreOutliers, System.Boolean useLogs, Double &sourceCalculationNumber1, Double &sourceCalculationNumber2, Int32 &decimalPlaces ) : System.Boolean
table	ListObject
sourceColumnName	String
destinationColumnName	String
useSourceNumber1	System.Boolean
useSourceNumber2	System.Boolean
sourceNumber1	Double
sourceNumber2	Double
destinationNumber1	Double
destinationNumber2	Double
ignoreOutliers	System.Boolean
useLogs	System.Boolean
sourceCalculationNumber1	Double
sourceCalculationNumber2	Double
decimalPlaces	System.Int32
return	System.Boolean