Click or drag to resize
SpreadsheetReader Class
Inheritance Hierarchy

Namespace: DataStreams.Common
Assembly: DataStreams (in DataStreams.dll) Version:
public abstract class SpreadsheetReader : ReaderBase

The SpreadsheetReader type exposes the following members.

Public methodSpreadsheetReader
Initializes a new instance of the SpreadsheetReader class
Public methodClose
Closes and releases all related resources.
(Inherited from ReaderBase.)
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetHeader
Returns the column header value for a given columnIndex.
Public methodGetIndex
Gets the corresponding column index for a given headerName.
Public methodGetSheetIndex
Returns the index of the sheet with the given name.
Public methodGetSheetName
Returns the name of the sheet at the given index.
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Public methodReadRecord
Advances the record cursor to the next record.
(Overrides ReaderBaseReadRecord.)
Public methodReset
Resets the position of the record cursor to the first record for use with the ReadRecord method.
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public propertyColumnCount
Returns the count of columns found on the current record when looping with the ReadRecord method.
Public propertyCurrentRecord
Gets or sets the current record the reader is on for reading records in a loop using ReadRecord.
Public propertyCurrentSheet
Gets or sets the index of the current sheet in the workbook.
Public propertyHeaderCount
Returns the count of column headers found when HasHeaders is set to true.
Public propertyHeaders
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.
Public propertyItemInt32
Returns the current column value for a given column index.
(Inherited from ReaderBase.)
Public propertyItemString
Returns the column's value corresponding to the column header name.
Public propertyItemInt32, Int32
Returns the column value at the given record and column indexes.
Public propertyRecordCount
Returns the count of records found in the current sheet.
Public propertySettings
Has all the options that are able to be set that will affect the way records are parsed and accessed.
Public propertySheetCount
Returns the count of sheets found in the workbook.
Public propertySheetNames
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 propertyTable
Returns all data for the current sheet as a DataTable of string columns.
Public propertyValues
Returns the columns values for the current record as a string array.
(Inherited from ReaderBase.)
See Also