C# Class OpenXml.Excel.Data.ExcelDataReader

Inheritance: IDataReader
Show file Open project: gSerP1983/OpenXml.Excel.Data Class Usage Examples

Public Methods

Method Description
Close ( ) : void
Dispose ( ) : void
ExcelDataReader ( Stream stream, int sheetIndex, bool firstRowAsHeader = true ) : System
ExcelDataReader ( Stream stream, string sheetName, bool firstRowAsHeader = true ) : System
ExcelDataReader ( string path, int sheetIndex, bool firstRowAsHeader = true ) : System
ExcelDataReader ( string path, string sheetName, bool firstRowAsHeader = true ) : System
GetBoolean ( int i ) : bool
GetByte ( int i ) : byte
GetBytes ( int i, long fieldOffset, byte buffer, int bufferoffset, int length ) : long
GetChar ( int i ) : char
GetChars ( int i, long fieldoffset, char buffer, int bufferoffset, int length ) : long
GetData ( int i ) : IDataReader
GetDataTypeName ( int i ) : string
GetDateTime ( int i ) : System.DateTime
GetDecimal ( int i ) : decimal
GetDouble ( int i ) : double
GetFieldType ( int i ) : Type
GetFloat ( int i ) : float
GetGuid ( int i ) : System.Guid
GetInt16 ( int i ) : short
GetInt32 ( int i ) : int
GetInt64 ( int i ) : long
GetName ( int i ) : string
GetOrdinal ( string name ) : int
GetSchemaTable ( ) : DataTable
GetString ( int i ) : string
GetValue ( int i ) : object
GetValues ( object values ) : int
IsDBNull ( int i ) : bool
NextResult ( ) : bool
Read ( ) : bool
this ( int i ) : object
this ( string name ) : object

Private Methods

Method Description
AdjustRow ( OpenXmlElement row, int capacity ) : IEnumerable
GetCellValue ( CellType cell ) : string
GetFirstRowAsHeaders ( ) : string[]
GetRangeHeaders ( OpenXmlPart worksheetPart ) : string[]
GetSharedStrings ( SpreadsheetDocument document ) : string>.IDictionary
GetSheetByIndex ( int sheetIndex ) : Sheet
GetSheetByName ( string sheetName ) : Sheet
GetSheets ( ) : IEnumerable

Method Details

Close() public method

public Close ( ) : void
return void

Dispose() public method

public Dispose ( ) : void
return void

ExcelDataReader() public method

public ExcelDataReader ( Stream stream, int sheetIndex, bool firstRowAsHeader = true ) : System
stream Stream
sheetIndex int
firstRowAsHeader bool
return System

ExcelDataReader() public method

public ExcelDataReader ( Stream stream, string sheetName, bool firstRowAsHeader = true ) : System
stream Stream
sheetName string
firstRowAsHeader bool
return System

ExcelDataReader() public method

public ExcelDataReader ( string path, int sheetIndex, bool firstRowAsHeader = true ) : System
path string
sheetIndex int
firstRowAsHeader bool
return System

ExcelDataReader() public method

public ExcelDataReader ( string path, string sheetName, bool firstRowAsHeader = true ) : System
path string
sheetName string
firstRowAsHeader bool
return System

GetBoolean() public method

public GetBoolean ( int i ) : bool
i int
return bool

GetByte() public method

public GetByte ( int i ) : byte
i int
return byte

GetBytes() public method

public GetBytes ( int i, long fieldOffset, byte buffer, int bufferoffset, int length ) : long
i int
fieldOffset long
buffer byte
bufferoffset int
length int
return long

GetChar() public method

public GetChar ( int i ) : char
i int
return char

GetChars() public method

public GetChars ( int i, long fieldoffset, char buffer, int bufferoffset, int length ) : long
i int
fieldoffset long
buffer char
bufferoffset int
length int
return long

GetData() public method

public GetData ( int i ) : IDataReader
i int
return IDataReader

GetDataTypeName() public method

public GetDataTypeName ( int i ) : string
i int
return string

GetDateTime() public method

public GetDateTime ( int i ) : System.DateTime
i int
return System.DateTime

GetDecimal() public method

public GetDecimal ( int i ) : decimal
i int
return decimal

GetDouble() public method

public GetDouble ( int i ) : double
i int
return double

GetFieldType() public method

public GetFieldType ( int i ) : Type
i int
return System.Type

GetFloat() public method

public GetFloat ( int i ) : float
i int
return float

GetGuid() public method

public GetGuid ( int i ) : System.Guid
i int
return System.Guid

GetInt16() public method

public GetInt16 ( int i ) : short
i int
return short

GetInt32() public method

public GetInt32 ( int i ) : int
i int
return int

GetInt64() public method

public GetInt64 ( int i ) : long
i int
return long

GetName() public method

public GetName ( int i ) : string
i int
return string

GetOrdinal() public method

public GetOrdinal ( string name ) : int
name string
return int

GetSchemaTable() public method

public GetSchemaTable ( ) : DataTable
return System.Data.DataTable

GetString() public method

public GetString ( int i ) : string
i int
return string

GetValue() public method

public GetValue ( int i ) : object
i int
return object

GetValues() public method

public GetValues ( object values ) : int
values object
return int

IsDBNull() public method

public IsDBNull ( int i ) : bool
i int
return bool

NextResult() public method

public NextResult ( ) : bool
return bool

Read() public method

public Read ( ) : bool
return bool

this() public method

public this ( int i ) : object
i int
return object

this() public method

public this ( string name ) : object
name string
return object