| SpreadsheetReader Properties |
The SpreadsheetReader type exposes the following members.
| 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.) |