C# Class SympleLib.OpenXml.Reader.OpenXLRow

Afficher le fichier Open project: sympletech/SympleLib

Private Properties

Свойство Type Description

Méthodes publiques

Méthode 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

Méthodes protégées

Méthode Description
ReadCell ( Cell cellToRead ) : String

Method Details

GetCells() public méthode

public GetCells ( Row xRow ) : IEnumerable
xRow Row
Résultat IEnumerable

GetColumnIndexFromName() public méthode

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)
Résultat int?

GetColumnName() public méthode

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)
Résultat string

OpenXLRow() public méthode

public OpenXLRow ( ) : System
Résultat System

OpenXLRow() public méthode

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
Résultat System

OpenXLRow() public méthode

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
Résultat System

ReadCell() protected méthode

protected ReadCell ( Cell cellToRead ) : String
cellToRead Cell
Résultat String

this() public méthode

public this ( int index ) : string
index int
Résultat string

this() public méthode

public this ( string col ) : string
col string
Résultat string