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

Provides access to settings for dynamic filtering.
A dynamic filter is a control that can be adjusted to selectively show and hide edges and vertices in the graph in real time. This class maintains the filter settings, which are stored in a table in a hidden worksheet.

Call the Open method to gain access to the settings, then use TryGetSettings and SetSettings to get and set the settings for one filter.

Наследование: WorksheetReaderBase
Показать файл Открыть проект Примеры использования класса

Защищенные свойства (Protected)

Свойство Тип Описание
m_oDynamicFilterSettingsDictionary SettingsForOneFilter>.Dictionary
m_oDynamicFilterSettingsTable ListObject
m_oWorkbook Microsoft.Office.Interop.Excel.Workbook

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

Метод Описание
AssertValid ( ) : void
DynamicFilterSettings ( Microsoft workbook ) : System

Initializes a new instance of the DynamicFilterSettings class.
Open ( ) : void
SetSettings ( String tableName, String columnName, Decimal selectedMinimum, Decimal selectedMaximum, String &selectedMinimumAddress, String &selectedMaximumAddress ) : void
TryGetSettings ( String tableName, String columnName, Decimal &selectedMinimum, Decimal &selectedMaximum, String &selectedMinimumAddress, String &selectedMaximumAddress ) : System.Boolean

Защищенные методы

Метод Описание
CheckOpen ( ) : void
GetDictionaryKey ( String sTableName, String sColumnName ) : String

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

AssertValid() публичный Метод

public AssertValid ( ) : void
Результат void

CheckOpen() защищенный Метод

protected CheckOpen ( ) : void
Результат void

DynamicFilterSettings() публичный Метод

Initializes a new instance of the DynamicFilterSettings class.
public DynamicFilterSettings ( Microsoft workbook ) : System
workbook Microsoft /// The workbook containing the settings. ///
Результат System

GetDictionaryKey() защищенный Метод

protected GetDictionaryKey ( String sTableName, String sColumnName ) : String
sTableName String
sColumnName String
Результат String

Open() публичный Метод

public Open ( ) : void
Результат void

SetSettings() публичный Метод

public SetSettings ( String tableName, String columnName, Decimal selectedMinimum, Decimal selectedMaximum, String &selectedMinimumAddress, String &selectedMaximumAddress ) : void
tableName String
columnName String
selectedMinimum Decimal
selectedMaximum Decimal
selectedMinimumAddress String
selectedMaximumAddress String
Результат void

TryGetSettings() публичный Метод

public TryGetSettings ( String tableName, String columnName, Decimal &selectedMinimum, Decimal &selectedMaximum, String &selectedMinimumAddress, String &selectedMaximumAddress ) : System.Boolean
tableName String
columnName String
selectedMinimum Decimal
selectedMaximum Decimal
selectedMinimumAddress String
selectedMaximumAddress String
Результат System.Boolean

Описание свойств

m_oDynamicFilterSettingsDictionary защищенное свойство

protected Dictionary m_oDynamicFilterSettingsDictionary
Результат SettingsForOneFilter>.Dictionary

m_oDynamicFilterSettingsTable защищенное свойство

protected ListObject m_oDynamicFilterSettingsTable
Результат ListObject

m_oWorkbook защищенное свойство

protected Workbook,Microsoft.Office.Interop.Excel m_oWorkbook
Результат Microsoft.Office.Interop.Excel.Workbook