![]() | XlsxReader Properties |
The XlsxReader 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.) |