C# 클래스 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.
상속: Smrf.NodeXL.Core.NodeXLBase
파일 보기 프로젝트 열기: 2014-sed-team3/term-project 1 사용 예제들

공개 프로퍼티들

프로퍼티 타입 설명
EmptyIDArray System.Int32[]

보호된 프로퍼티들

프로퍼티 타입 설명
m_oAlphaConverter AlphaConverter

공개 메소드들

메소드 설명
AssertValid ( ) : void
VertexNameToVertex ( String vertexName, IVertexCollection vertices, IVertex>.Dictionary vertexNameDictionary ) : IVertex
WorksheetReaderBase ( ) : System

Initializes a new instance of the WorksheetReaderBase class.

보호된 메소드들

메소드 설명
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

메소드 상세

AssertValid() 공개 메소드

public AssertValid ( ) : void
리턴 void

CreateVertex() 보호된 정적인 메소드

protected static CreateVertex ( String sVertexName, IVertexCollection oVertices, IVertex>.Dictionary oVertexNameDictionary ) : IVertex
sVertexName String
oVertices IVertexCollection
oVertexNameDictionary IVertex>.Dictionary
리턴 IVertex

FillIDColumn() 보호된 메소드

protected FillIDColumn ( ListObject oTable ) : void
oTable ListObject
리턴 void

FilterColumnNames() 보호된 메소드

protected FilterColumnNames ( ExcelTableReader oExcelTableReader, HashSet oColumnNamesToExclude ) : String[]
oExcelTableReader Smrf.AppLib.ExcelTableReader
oColumnNamesToExclude HashSet
리턴 String[]

GetTableColumnIndex() 보호된 메소드

protected GetTableColumnIndex ( ListObject oTable, String sColumnName, System.Boolean bColumnIsRequired ) : Int32
oTable ListObject
sColumnName String
bColumnIsRequired System.Boolean
리턴 System.Int32

HideVertex() 보호된 메소드

protected HideVertex ( IVertex oVertex ) : void
oVertex IVertex
리턴 void

OnInvalidVisibility() 보호된 메소드

protected OnInvalidVisibility ( ExcelTableReader oRow ) : void
oRow Smrf.AppLib.ExcelTableReader
리턴 void

OnWorkbookFormatError() 보호된 메소드

protected OnWorkbookFormatError ( String sMessage ) : void
sMessage String
리턴 void

OnWorkbookFormatError() 보호된 메소드

protected OnWorkbookFormatError ( String sMessage, Range oRangeToSelect ) : void
sMessage String
oRangeToSelect Range
리턴 void

OnWorkbookFormatErrorWithDropDown() 보호된 메소드

protected OnWorkbookFormatErrorWithDropDown ( ExcelTableReader oRow, String sColumnName, String sInvalidCellDescription ) : void
oRow Smrf.AppLib.ExcelTableReader
sColumnName String
sInvalidCellDescription String
리턴 void

ReadAllColumns() 보호된 메소드

protected ReadAllColumns ( ExcelTableReader oExcelTableReader, ExcelTableReader oRow, IMetadataProvider oEdgeOrVertex, HashSet oColumnNamesToExclude ) : void
oExcelTableReader Smrf.AppLib.ExcelTableReader
oRow Smrf.AppLib.ExcelTableReader
oEdgeOrVertex IMetadataProvider
oColumnNamesToExclude HashSet
리턴 void

ReadAlpha() 보호된 메소드

protected ReadAlpha ( ExcelTableReader oRow, IMetadataProvider oEdgeOrVertex ) : System.Boolean
oRow Smrf.AppLib.ExcelTableReader
oEdgeOrVertex IMetadataProvider
리턴 System.Boolean

ReadCellAndSetMetadata() 보호된 메소드

protected ReadCellAndSetMetadata ( ExcelTableReader oRow, String sColumnName, IMetadataProvider oEdgeOrVertex, String sKeyName ) : System.Boolean
oRow Smrf.AppLib.ExcelTableReader
sColumnName String
oEdgeOrVertex IMetadataProvider
sKeyName String
리턴 System.Boolean

ReadColor() 보호된 메소드

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
리턴 void

RemoveVertex() 보호된 메소드

protected RemoveVertex ( IVertex oVertex, ReadWorkbookContext oReadWorkbookContext, IGraph oGraph ) : void
oVertex IVertex
oReadWorkbookContext ReadWorkbookContext
oGraph IGraph
리턴 void

TryGetBoolean() 보호된 메소드

protected TryGetBoolean ( ExcelTableReader oRow, String sColumnName, BooleanConverter oBooleanConverter, System.Boolean &bBoolean ) : System.Boolean
oRow Smrf.AppLib.ExcelTableReader
sColumnName String
oBooleanConverter BooleanConverter
bBoolean System.Boolean
리턴 System.Boolean

TryGetColor() 보호된 메소드

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

TryGetLocation() 보호된 메소드

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
리턴 System.Boolean

TryGetVertexShape() 보호된 메소드

protected TryGetVertexShape ( ExcelTableReader oRow, String sColumnName, VertexShape &eShape ) : System.Boolean
oRow Smrf.AppLib.ExcelTableReader
sColumnName String
eShape VertexShape
리턴 System.Boolean

VertexNameToVertex() 공개 정적인 메소드

public static VertexNameToVertex ( String vertexName, IVertexCollection vertices, IVertex>.Dictionary vertexNameDictionary ) : IVertex
vertexName String
vertices IVertexCollection
vertexNameDictionary IVertex>.Dictionary
리턴 IVertex

WorksheetReaderBase() 공개 메소드

Initializes a new instance of the WorksheetReaderBase class.
public WorksheetReaderBase ( ) : System
리턴 System

프로퍼티 상세

EmptyIDArray 공개적으로 정적으로 프로퍼티

public static Int32[],System EmptyIDArray
리턴 System.Int32[]

m_oAlphaConverter 보호되어 있는 프로퍼티

protected AlphaConverter,Smrf.NodeXL.ExcelTemplate m_oAlphaConverter
리턴 AlphaConverter