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