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.) |