XlsReader Properties |
The XlsReader type exposes the following members.
Name | Description | |
---|---|---|
ColumnCount |
Returns the count of columns found on the current record when looping
with the ReadRecord method.
(Inherited from SpreadsheetReader.) | |
CurrentRecord |
Gets or sets the current record the reader is on
for reading records in a loop using ReadRecord.
(Inherited from SpreadsheetReader.) | |
CurrentSheet |
Gets or sets the index of the current sheet in the workbook.
(Inherited from SpreadsheetReader.) | |
HeaderCount |
Returns the count of column headers found when HasHeaders
is set to true.
(Inherited from SpreadsheetReader.) | |
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.
(Inherited from SpreadsheetReader.) | |
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.
(Inherited from SpreadsheetReader.) | |
ItemInt32, Int32 |
Returns the column value at the given record and column indexes.
(Inherited from SpreadsheetReader.) | |
RecordCount |
Returns the count of records found in the current sheet.
(Inherited from SpreadsheetReader.) | |
Settings |
Has all the options that are able to be set that will affect the way
records are parsed and accessed.
(Inherited from SpreadsheetReader.) | |
SheetCount |
Returns the count of sheets found in the workbook.
(Inherited from SpreadsheetReader.) | |
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.
(Inherited from SpreadsheetReader.) | |
Table |
Returns all data for the current sheet as a DataTable of string
columns.
(Inherited from SpreadsheetReader.) | |
Values |
Returns the columns values for the current record as a string array.
(Inherited from ReaderBase.) |