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

Public MustInherit Class SpreadsheetDataReader
	Inherits DataReaderBase

The SpreadsheetDataReader type exposes the following members.

Constructors

	Name	Description
	SpreadsheetDataReader	Initializes a new instance of the SpreadsheetDataReader class

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.
	GetSheetName	Returns the name of the sheet at the given index.
	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.
	CurrentSheet	Gets or sets the index of the current sheet in the workbook.
	Settings	Has all the options that are able to be set that will affect the way records are parsed.
	SheetCount	Returns the count of sheets found in the workbook.
	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.

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.)