API Reference
Class
ExcelWorkbookDataReader
Package-owned ADO.NET projection for XLSX, XLSM, and XLSB workbook worksheets.
Inheritance
- DbDataReader
- ExcelWorkbookDataReader
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
Methods
public override Int64 GetBytes(Int32 ordinal, Int64 dataOffset, Byte[] buffer, Int32 bufferOffset, Int32 length) #Returns:
Int64Parameters
- ordinal System.Int32
- dataOffset System.Int64
- buffer System.Byte[]
- bufferOffset System.Int32
- length System.Int32
public override Int64 GetChars(Int32 ordinal, Int64 dataOffset, Char[] buffer, Int32 bufferOffset, Int32 length) #Returns:
Int64Parameters
- ordinal System.Int32
- dataOffset System.Int64
- buffer System.Char[]
- bufferOffset System.Int32
- length System.Int32
public override String GetDataTypeName(Int32 ordinal) #Returns:
StringParameters
- ordinal System.Int32
public override DateTime GetDateTime(Int32 ordinal) #Returns:
DateTimeParameters
- ordinal System.Int32
public override IEnumerator GetEnumerator() #Returns:
IEnumeratorpublic override T GetFieldValue<T>(Int32 ordinal) #Returns:
TType Parameters
- T
Parameters
- ordinal System.Int32
public override DataTable GetSchemaTable() #Returns:
DataTablepublic override Boolean NextResult() #Returns:
BooleanInherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
public override Task<ReadOnlyCollection<DbColumn>> GetColumnSchemaAsync(CancellationToken cancellationToken = null) #Returns:
Task<ReadOnlyCollection<DbColumn>>Inherited from DbDataReader
Parameters
- cancellationToken CancellationToken = null
public DbDataReader GetData(Int32 ordinal) #Returns:
DbDataReaderInherited from DbDataReader
EditorBrowsable(1)Parameters
- ordinal Int32
GetFieldValueAsync 2 overloads
public Task<T> GetFieldValueAsync<T>(Int32 ordinal) #Returns:
Task<T>Inherited from DbDataReader
Type Parameters
- T
Parameters
- ordinal Int32
public override Task<T> GetFieldValueAsync<T>(Int32 ordinal, CancellationToken cancellationToken) #Returns:
Task<T>Inherited from DbDataReader
Type Parameters
- T
Parameters
- ordinal Int32
- cancellationToken CancellationToken
public Object GetLifetimeService() #Returns:
ObjectInherited from MarshalByRefObject
Obsolete("This Remoting API is not supported and throws PlatformNotSupportedException.", DiagnosticId = "SYSLIB0010", UrlFormat = "https://aka.ms/dotnet-warnings/{0}")public override Type GetProviderSpecificFieldType(Int32 ordinal) #Returns:
TypeInherited from DbDataReader
EditorBrowsable(1)Parameters
- ordinal Int32
public override Object GetProviderSpecificValue(Int32 ordinal) #Returns:
ObjectInherited from DbDataReader
EditorBrowsable(1)Parameters
- ordinal Int32
public override Int32 GetProviderSpecificValues(Object[] values) #Returns:
Int32Inherited from DbDataReader
EditorBrowsable(1)Parameters
- values Object[]
public override Task<DataTable> GetSchemaTableAsync(CancellationToken cancellationToken = null) #Returns:
Task<DataTable>Inherited from DbDataReader
Parameters
- cancellationToken CancellationToken = null
public override Stream GetStream(Int32 ordinal) #Returns:
StreamInherited from DbDataReader
Parameters
- ordinal Int32
public override TextReader GetTextReader(Int32 ordinal) #Returns:
TextReaderInherited from DbDataReader
Parameters
- ordinal Int32
public override Object InitializeLifetimeService() #Returns:
ObjectInherited from MarshalByRefObject
Obsolete("This Remoting API is not supported and throws PlatformNotSupportedException.", DiagnosticId = "SYSLIB0010", UrlFormat = "https://aka.ms/dotnet-warnings/{0}")IsDBNullAsync 2 overloads
public Task<Boolean> IsDBNullAsync(Int32 ordinal) #Returns:
Task<Boolean>Inherited from DbDataReader
Parameters
- ordinal Int32
public override Task<Boolean> IsDBNullAsync(Int32 ordinal, CancellationToken cancellationToken) #Returns:
Task<Boolean>Inherited from DbDataReader
Parameters
- ordinal Int32
- cancellationToken CancellationToken
NextResultAsync 2 overloads
ReadAsync 2 overloads
Properties
public IReadOnlyList<String> SheetNames { get; } #Gets worksheet names exposed by this reader in workbook order.
public Int32 CurrentSheetIndex { get; } #Gets the zero-based workbook index of the current worksheet.
public Int32 CurrentResultIndex { get; } #Gets the zero-based index of the current reader result within SheetNames.
public String CurrentSheetName { get; } #Gets the worksheet name for the current result.
public override Int32 Depth { get; } #public override Int32 FieldCount { get; } #public override Boolean HasRows { get; } #public override Boolean IsClosed { get; } #public override Int32 RecordsAffected { get; } #public override Int32 VisibleFieldCount { get; } #