SpreadsheetDataReader overview
Public Instance Constructors
Public Instance Properties
 Columns | Collection of columns to include in the source data. |
| CurrentSheet | Gets or sets the index of the current sheet in the workbook. |
| Settings | Has all the options that are able to be set that will affect the way records are parsed. |
| 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. |
Public Instance Methods
 Close (inherited from DataReaderBase) | 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. |
| 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. |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
Public Instance Events
 ReadRecord (inherited from DataReaderBase) | This event is raised after each record has been read and before the values have been converted to the destination type. This event can be used to modify values in a record, add values to a record, or skip a record entirely. |
See Also
SpreadsheetDataReader Class | DataStreams.Common Namespace