Creates a XlsReader object using Excel spreadsheet data read in from a stream as the data source.

Creates a XlsReader object using a file as the data source.

Closes and releases all related resources.

Determines whether the specified Object is equal to the current Object.

Serves as a hash function for a particular type.

Returns the column header value for a given columnIndex.

Gets the corresponding column index for a given headerName.

Returns the index of the sheet with the given name.

Returns the name of the sheet at the given index.

Gets the type of the current instance.

Advances the record cursor to the next record.

Resets the position of the record cursor to the first record for use with the ReadRecord method.

Returns a string that represents the current object.

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.

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.