C# Class SympleLib.OpenXml.Reader.OpenXLRow

ファイルを表示 Open project: sympletech/SympleLib

Private Properties

Property	Type	Description

Public Methods

Method	Description
GetCells ( Row xRow ) : IEnumerable
GetColumnIndexFromName ( string columnName ) : int?	Given just the column name (no row index), it will return the zero based column index. Note: This method will only handle columns with a length of up to two (ie. A to Z and AA to ZZ). A length of three can be implemented when needed.
GetColumnName ( string cellReference ) : string	Given a cell name, parses the specified cell to get the column name.
OpenXLRow ( ) : System
OpenXLRow ( DocumentFormat.OpenXml.Packaging.WorkbookPart wbPart, DocumentFormat.OpenXml.Packaging.WorksheetPart wsPart, List columns, Row xRow ) : System
OpenXLRow ( DocumentFormat.OpenXml.Packaging.WorkbookPart wbPart, DocumentFormat.OpenXml.Packaging.WorksheetPart wsPart, List columns, int rowNum ) : System
this ( int index ) : string
this ( string col ) : string

Protected Methods

Method	Description
ReadCell ( Cell cellToRead ) : String

Method Details

GetCells() public method

public GetCells ( Row xRow ) : IEnumerable
xRow	Row
return	IEnumerable

GetColumnIndexFromName() public method

Given just the column name (no row index), it will return the zero based column index. Note: This method will only handle columns with a length of up to two (ie. A to Z and AA to ZZ). A length of three can be implemented when needed.

public GetColumnIndexFromName ( string columnName ) : int?
columnName	string	Column Name (ie. A or AB)
return	int?

GetColumnName() public method

Given a cell name, parses the specified cell to get the column name.

public GetColumnName ( string cellReference ) : string
cellReference	string	Address of the cell (ie. B2)
return	string

OpenXLRow() public method

public OpenXLRow ( ) : System
return	System

OpenXLRow() public method

public OpenXLRow ( DocumentFormat.OpenXml.Packaging.WorkbookPart wbPart, DocumentFormat.OpenXml.Packaging.WorksheetPart wsPart, List columns, Row xRow ) : System
wbPart	DocumentFormat.OpenXml.Packaging.WorkbookPart
wsPart	DocumentFormat.OpenXml.Packaging.WorksheetPart
columns	List
xRow	Row
return	System

OpenXLRow() public method

public OpenXLRow ( DocumentFormat.OpenXml.Packaging.WorkbookPart wbPart, DocumentFormat.OpenXml.Packaging.WorksheetPart wsPart, List columns, int rowNum ) : System
wbPart	DocumentFormat.OpenXml.Packaging.WorkbookPart
wsPart	DocumentFormat.OpenXml.Packaging.WorksheetPart
columns	List
rowNum	int
return	System

ReadCell() protected method

protected ReadCell ( Cell cellToRead ) : String
cellToRead	Cell
return	String

this() public method

public this ( int index ) : string
index	int
return	string

this() public method

public this ( string col ) : string
col	string
return	string