The properties of the SpreadsheetReader class are listed below. For a complete list of SpreadsheetReader class members, see the SpreadsheetReader Members topic.
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. |
See Also
SpreadsheetReader Class | DataStreams.Common Namespace