Public Instance Constructors
Public Instance Properties
 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. |
| Item | Overloaded. Returns the column's value corresponding to the column header name. |
| 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 (inherited from ReaderBase) | Returns the columns values for the current record as a string array. |
Public Instance Methods
 Close (inherited from ReaderBase) | Closes and releases all related resources. |
| Equals (inherited from Object) | Determines whether the specified Object is equal to the current Object. |
| GetHashCode (inherited from Object) | Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table. |
| GetHeader | Returns the column header value for a given columnIndex. |
| GetIndex | Gets the corresponding column index for a given headerName. |
| GetSheetIndex | Returns the index of the sheet with the given name. |
| GetSheetName | Returns the name of the sheet at the given index. |
| GetType (inherited from Object) | Gets the Type of the current instance. |
| ReadRecord | Advances the record cursor to the next record. |
| Reset | Resets the position of the record cursor to the first record for use with the ReadRecord method. |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
See Also
SpreadsheetReader Class | DataStreams.Common Namespace