XlsDataReader Class

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

Public NotInheritable Class XlsDataReader
	Inherits SpreadsheetDataReader

The XlsDataReader type exposes the following members.

Constructors

	Name	Description
	XlsDataReader(Stream)	Constructs a XlsDataReader object using a Stream object as the data source.
	XlsDataReader(String)	Creates a XlsDataReader object using a spreadsheet file as the data source.

Methods

	Name	Description
	Close	Closes and releases all related resources. (Inherited from DataReaderBase.)
	Equals	Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetSheetIndex	Returns the index of the sheet with the given name. (Inherited from SpreadsheetDataReader.)
	GetSheetName	Returns the name of the sheet at the given index. (Inherited from SpreadsheetDataReader.)
	GetType	Gets the type of the current instance. (Inherited from Object.)
	ToString	Returns a string that represents the current object. (Inherited from Object.)

Properties

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

Events

	Name	Description
	ReadRecord	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.)