Click or drag to resize
XlsDataReader 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.Xls
Assembly: DataStreams (in DataStreams.dll) Version: 5.20.0.0
Syntax
public sealed class XlsDataReader : SpreadsheetDataReader

The XlsDataReader type exposes the following members.

Constructors
  NameDescription
Public methodXlsDataReader(Stream)
Constructs a XlsDataReader object using a Stream object as the data source.
Public methodXlsDataReader(String)
Creates a XlsDataReader object using a spreadsheet file as the data source.
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.
(Inherited from SpreadsheetDataReader.)
Public methodGetSheetName
Returns the name of the sheet at the given index.
(Inherited from SpreadsheetDataReader.)
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.
(Inherited from SpreadsheetDataReader.)
Public propertyCurrentSheet
Gets or sets the index of the current sheet in the workbook.
(Inherited from SpreadsheetDataReader.)
Public propertySettings
Has all the options that are able to be set that will affect the way records are parsed.
(Inherited from SpreadsheetDataReader.)
Public propertySheetCount
Returns the count of sheets found in the workbook.
(Inherited from SpreadsheetDataReader.)
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.
(Inherited from SpreadsheetDataReader.)
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