 | SpreadsheetReader Class |
Inheritance HierarchySystemObject
DataStreams.CommonReaderBase
DataStreams.CommonSpreadsheetReader
DataStreams.XlsXlsReader
DataStreams.XlsxXlsxReader
DataStreams.CommonReaderBase
DataStreams.CommonSpreadsheetReader
DataStreams.XlsXlsReader
DataStreams.XlsxXlsxReader
Namespace: DataStreams.Common
Assembly: DataStreams (in DataStreams.dll) Version: 5.20.0.0
SyntaxThe SpreadsheetReader type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | SpreadsheetReader | Initializes a new instance of the SpreadsheetReader class |
Methods| Name | Description | |
|---|---|---|
| Close |
Closes and releases all related resources.
(Inherited from ReaderBase.) |
| Equals | (Inherited from Object.) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetHeader |
Returns the column header value for a given
columnIndex.
|
| GetIndex |
Gets the corresponding column index for a given
headerName.
|
| GetSheetIndex |
Returns the index of the sheet with the given name.
|
| GetSheetName |
Returns the name of the sheet at the given index.
|
| GetType | Gets the type of the current instance. (Inherited from Object.) |
| ReadRecord |
Advances the record cursor to the next record.
(Overrides ReaderBaseReadRecord.) |
| Reset |
Resets the position of the record cursor to the first record
for use with the ReadRecord method.
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
Properties| Name | Description | |
|---|---|---|
 | ColumnCount |
Returns the count of columns found on the current record when looping
with the ReadRecord method.
|
| CurrentRecord |
Gets or sets the current record the reader is on
for reading records in a loop using ReadRecord.
|
| CurrentSheet |
Gets or sets the index of the current sheet in the workbook.
|
| HeaderCount |
Returns the count of column headers found when HasHeaders
is set to true.
|
| Headers |
Returns the header values as a string array or
sets the headers to allow columns to be accessed by
name even if the current spreadsheet does not contain
column headers.
|
| ItemInt32 |
Returns the current column value for a given column index.
(Inherited from ReaderBase.) |
| ItemString |
Returns the column's value corresponding to the column header
name.
|
| ItemInt32, Int32 |
Returns the column value at the given record and column indexes.
|
| RecordCount |
Returns the count of records found in the current sheet.
|
| Settings |
Has all the options that are able to be set that will affect the way
records are parsed and accessed.
|
| SheetCount |
Returns the count of sheets found in the workbook.
|
| SheetNames |
Returns the list of sheet names as a string array in the correct
order. The array can then easily be bound to a combo box for example
for sheet selection in a windows form.
|
| Table |
Returns all data for the current sheet as a DataTable of string
columns.
|
| Values |
Returns the columns values for the current record as a string array.
(Inherited from ReaderBase.) |
See Also