www.csvreader.com

XlsDataReader overview

Public Instance Constructors

XlsDataReader Overloaded. Initializes a new instance of the XlsDataReader class.

Public Instance Properties

Columns (inherited from SpreadsheetDataReader) Collection of columns to include in the source data.
CurrentSheet (inherited from SpreadsheetDataReader) Gets or sets the index of the current sheet in the workbook.
Settings (inherited from SpreadsheetDataReader) Has all the options that are able to be set that will affect the way records are parsed.
SheetCount (inherited from SpreadsheetDataReader) Returns the count of sheets found in the workbook.
SheetNames (inherited from SpreadsheetDataReader) 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 (inherited from SpreadsheetDataReader) Returns the index of the sheet with the given name.
GetSheetName (inherited from SpreadsheetDataReader) 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

XlsDataReader Class | DataStreams.Xls Namespace