C# Class Smrf.NodeXL.ExcelTemplate.WorksheetReaderBase

Base class for classes that know how to read an Excel worksheet containing graph data.
There is one derived class for each worksheet in a NodeXL workbook that contains graph data. There are additional derived classes for reading tables contained in the hidden Miscellaneous worksheet.
Inheritance: Smrf.NodeXL.Core.NodeXLBase
Afficher le fichier Open project: 2014-sed-team3/term-project Class Usage Examples

Méthodes publiques

Свойство Type Description
EmptyIDArray System.Int32[]

Protected Properties

Свойство Type Description
m_oAlphaConverter AlphaConverter

Méthodes publiques

Méthode Description
AssertValid ( ) : void
VertexNameToVertex ( String vertexName, IVertexCollection vertices, IVertex>.Dictionary vertexNameDictionary ) : IVertex
WorksheetReaderBase ( ) : System

Initializes a new instance of the WorksheetReaderBase class.

Méthodes protégées

Méthode Description
CreateVertex ( String sVertexName, IVertexCollection oVertices, IVertex>.Dictionary oVertexNameDictionary ) : IVertex
FillIDColumn ( ListObject oTable ) : void
FilterColumnNames ( ExcelTableReader oExcelTableReader, HashSet oColumnNamesToExclude ) : String[]
GetTableColumnIndex ( ListObject oTable, String sColumnName, System.Boolean bColumnIsRequired ) : Int32
HideVertex ( IVertex oVertex ) : void
OnInvalidVisibility ( ExcelTableReader oRow ) : void
OnWorkbookFormatError ( String sMessage ) : void
OnWorkbookFormatError ( String sMessage, Range oRangeToSelect ) : void
OnWorkbookFormatErrorWithDropDown ( ExcelTableReader oRow, String sColumnName, String sInvalidCellDescription ) : void
ReadAllColumns ( ExcelTableReader oExcelTableReader, ExcelTableReader oRow, IMetadataProvider oEdgeOrVertex, HashSet oColumnNamesToExclude ) : void
ReadAlpha ( ExcelTableReader oRow, IMetadataProvider oEdgeOrVertex ) : System.Boolean
ReadCellAndSetMetadata ( ExcelTableReader oRow, String sColumnName, IMetadataProvider oEdgeOrVertex, String sKeyName ) : System.Boolean
ReadColor ( ExcelTableReader oRow, String sColumnName, IMetadataProvider oEdgeOrVertex, String sColorKey, ColorConverter2 oColorConverter2 ) : void
RemoveVertex ( IVertex oVertex, ReadWorkbookContext oReadWorkbookContext, IGraph oGraph ) : void
TryGetBoolean ( ExcelTableReader oRow, String sColumnName, BooleanConverter oBooleanConverter, System.Boolean &bBoolean ) : System.Boolean
TryGetColor ( ExcelTableReader oRow, String sColumnName, ColorConverter2 oColorConverter2, Color &oColor ) : System.Boolean
TryGetLocation ( ExcelTableReader oRow, String sXColumnName, String sYColumnName, VertexLocationConverter oVertexLocationConverter, PointF &oLocation ) : System.Boolean
TryGetVertexShape ( ExcelTableReader oRow, String sColumnName, VertexShape &eShape ) : System.Boolean

Method Details

AssertValid() public méthode

public AssertValid ( ) : void
Résultat void

CreateVertex() protected static méthode

protected static CreateVertex ( String sVertexName, IVertexCollection oVertices, IVertex>.Dictionary oVertexNameDictionary ) : IVertex
sVertexName String
oVertices IVertexCollection
oVertexNameDictionary IVertex>.Dictionary
Résultat IVertex

FillIDColumn() protected méthode

protected FillIDColumn ( ListObject oTable ) : void
oTable ListObject
Résultat void

FilterColumnNames() protected méthode

protected FilterColumnNames ( ExcelTableReader oExcelTableReader, HashSet oColumnNamesToExclude ) : String[]
oExcelTableReader Smrf.AppLib.ExcelTableReader
oColumnNamesToExclude HashSet
Résultat String[]

GetTableColumnIndex() protected méthode

protected GetTableColumnIndex ( ListObject oTable, String sColumnName, System.Boolean bColumnIsRequired ) : Int32
oTable ListObject
sColumnName String
bColumnIsRequired System.Boolean
Résultat System.Int32

HideVertex() protected méthode

protected HideVertex ( IVertex oVertex ) : void
oVertex IVertex
Résultat void

OnInvalidVisibility() protected méthode

protected OnInvalidVisibility ( ExcelTableReader oRow ) : void
oRow Smrf.AppLib.ExcelTableReader
Résultat void

OnWorkbookFormatError() protected méthode

protected OnWorkbookFormatError ( String sMessage ) : void
sMessage String
Résultat void

OnWorkbookFormatError() protected méthode

protected OnWorkbookFormatError ( String sMessage, Range oRangeToSelect ) : void
sMessage String
oRangeToSelect Range
Résultat void

OnWorkbookFormatErrorWithDropDown() protected méthode

protected OnWorkbookFormatErrorWithDropDown ( ExcelTableReader oRow, String sColumnName, String sInvalidCellDescription ) : void
oRow Smrf.AppLib.ExcelTableReader
sColumnName String
sInvalidCellDescription String
Résultat void

ReadAllColumns() protected méthode

protected ReadAllColumns ( ExcelTableReader oExcelTableReader, ExcelTableReader oRow, IMetadataProvider oEdgeOrVertex, HashSet oColumnNamesToExclude ) : void
oExcelTableReader Smrf.AppLib.ExcelTableReader
oRow Smrf.AppLib.ExcelTableReader
oEdgeOrVertex IMetadataProvider
oColumnNamesToExclude HashSet
Résultat void

ReadAlpha() protected méthode

protected ReadAlpha ( ExcelTableReader oRow, IMetadataProvider oEdgeOrVertex ) : System.Boolean
oRow Smrf.AppLib.ExcelTableReader
oEdgeOrVertex IMetadataProvider
Résultat System.Boolean

ReadCellAndSetMetadata() protected méthode

protected ReadCellAndSetMetadata ( ExcelTableReader oRow, String sColumnName, IMetadataProvider oEdgeOrVertex, String sKeyName ) : System.Boolean
oRow Smrf.AppLib.ExcelTableReader
sColumnName String
oEdgeOrVertex IMetadataProvider
sKeyName String
Résultat System.Boolean

ReadColor() protected méthode

protected ReadColor ( ExcelTableReader oRow, String sColumnName, IMetadataProvider oEdgeOrVertex, String sColorKey, ColorConverter2 oColorConverter2 ) : void
oRow Smrf.AppLib.ExcelTableReader
sColumnName String
oEdgeOrVertex IMetadataProvider
sColorKey String
oColorConverter2 ColorConverter2
Résultat void

RemoveVertex() protected méthode

protected RemoveVertex ( IVertex oVertex, ReadWorkbookContext oReadWorkbookContext, IGraph oGraph ) : void
oVertex IVertex
oReadWorkbookContext ReadWorkbookContext
oGraph IGraph
Résultat void

TryGetBoolean() protected méthode

protected TryGetBoolean ( ExcelTableReader oRow, String sColumnName, BooleanConverter oBooleanConverter, System.Boolean &bBoolean ) : System.Boolean
oRow Smrf.AppLib.ExcelTableReader
sColumnName String
oBooleanConverter BooleanConverter
bBoolean System.Boolean
Résultat System.Boolean

TryGetColor() protected méthode

protected TryGetColor ( ExcelTableReader oRow, String sColumnName, ColorConverter2 oColorConverter2, Color &oColor ) : System.Boolean
oRow Smrf.AppLib.ExcelTableReader
sColumnName String
oColorConverter2 ColorConverter2
oColor Color
Résultat System.Boolean

TryGetLocation() protected méthode

protected TryGetLocation ( ExcelTableReader oRow, String sXColumnName, String sYColumnName, VertexLocationConverter oVertexLocationConverter, PointF &oLocation ) : System.Boolean
oRow Smrf.AppLib.ExcelTableReader
sXColumnName String
sYColumnName String
oVertexLocationConverter VertexLocationConverter
oLocation System.Drawing.PointF
Résultat System.Boolean

TryGetVertexShape() protected méthode

protected TryGetVertexShape ( ExcelTableReader oRow, String sColumnName, VertexShape &eShape ) : System.Boolean
oRow Smrf.AppLib.ExcelTableReader
sColumnName String
eShape VertexShape
Résultat System.Boolean

VertexNameToVertex() public static méthode

public static VertexNameToVertex ( String vertexName, IVertexCollection vertices, IVertex>.Dictionary vertexNameDictionary ) : IVertex
vertexName String
vertices IVertexCollection
vertexNameDictionary IVertex>.Dictionary
Résultat IVertex

WorksheetReaderBase() public méthode

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

Property Details

EmptyIDArray public_oe static_oe property

public static Int32[],System EmptyIDArray
Résultat System.Int32[]

m_oAlphaConverter protected_oe property

protected AlphaConverter,Smrf.NodeXL.ExcelTemplate m_oAlphaConverter
Résultat AlphaConverter