C# Класс Smrf.NodeXL.ExcelTemplate.TableColumnMapper

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

All methods are static.

Наследование: Object

Показать файл Открыть проект

Открытые методы

Метод	Описание
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

Приватные методы

Метод	Описание
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

Описание методов

MapToTwoStrings() публичный статический Метод

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
Результат	void

MapViaCopy() публичный статический Метод

public static MapViaCopy ( ListObject table, String sourceColumnName, String destinationColumnName ) : void
table	ListObject
sourceColumnName	String
destinationColumnName	String
Результат	void

TryMapAverageColor() публичный статический Метод

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
Результат	System.Boolean

TryMapAverageNumber() публичный статический Метод

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
Результат	System.Boolean

TryMapToColor() публичный статический Метод

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
Результат	System.Boolean

TryMapToColor() публичный статический Метод

public static TryMapToColor ( ListObject table, String sourceColumnName, String destinationColumnName, ICollection &categoryNames ) : System.Boolean
table	ListObject
sourceColumnName	String
destinationColumnName	String
categoryNames	ICollection
Результат	System.Boolean

TryMapToNumericRange() публичный статический Метод

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
Результат	System.Boolean