The SpreadsheetReader type exposes the following members.
Returns the count of columns found on the current record when looping with the ReadRecord method.
Gets or sets the current record the reader is on for reading records in a loop using ReadRecord.
Gets or sets the index of the current sheet in the workbook.
Returns the count of column headers found when HasHeaders is set to true.
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.
Returns the current column value for a given column index.(Inherited from ReaderBase.)
Returns the column's value corresponding to the column header name.
Returns the column value at the given record and column indexes.
Returns the count of records found in the current sheet.
Has all the options that are able to be set that will affect the way records are parsed and accessed.
Returns the count of sheets found in the workbook.
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.
Returns all data for the current sheet as a DataTable of string columns.
Returns the columns values for the current record as a string array.(Inherited from ReaderBase.)