 | XlsxDataReader Class |
Provides a datasource for the .Net Framework SqlBulkCopy class
which allows data to be rapidly imported from an Excel 2007 spreadsheet into SQL Server.
Inheritance HierarchySystemObject
DataStreams.CommonDataReaderBase
DataStreams.CommonSpreadsheetDataReader
DataStreams.XlsxXlsxDataReader
DataStreams.CommonDataReaderBase
DataStreams.CommonSpreadsheetDataReader
DataStreams.XlsxXlsxDataReader
Namespace: DataStreams.Xlsx
Assembly: DataStreams (in DataStreams.dll) Version: 5.20.0.0
SyntaxThe XlsxDataReader type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | XlsxDataReader(Stream) |
Constructs a XlsxDataReader object using
a Stream object as the data source.
|
| XlsxDataReader(String) |
Creates a XlsxDataReader object using a
spreadsheet file as the data source.
|
Methods| Name | Description | |
|---|---|---|
| Close |
Closes and releases all related resources.
(Inherited from DataReaderBase.) |
| Equals | (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.) |
See Also