Click or drag to resize
SpreadsheetDataReader Class
Provides a datasource for the .Net Framework SqlBulkCopy class which allows data to be rapidly imported from an Excel spreadsheet into SQL Server.
Inheritance Hierarchy

Namespace: DataStreams.Common
Assembly: DataStreams (in DataStreams.dll) Version: 5.20.0.0
Syntax
public abstract class SpreadsheetDataReader : DataReaderBase

The SpreadsheetDataReader type exposes the following members.

Constructors
  NameDescription
Public methodSpreadsheetDataReader
Initializes a new instance of the SpreadsheetDataReader class
Top
Methods
  NameDescription
Public methodClose
Closes and releases all related resources.
(Inherited from DataReaderBase.)
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 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 methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
Properties
  NameDescription
Public propertyColumns
Collection of columns to include in the source data.
Public propertyCurrentSheet
Gets or sets the index of the current sheet in the workbook.
Public propertySettings
Has all the options that are able to be set that will affect the way records are parsed.
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.
Top
Events
  NameDescription
Public eventReadRecord
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.
(Inherited from DataReaderBase.)
Top
See Also