The ExcelDataSet type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | ExcelDataSet(String, String) |
Creates a new instance of the ExcelDataSet class.
|
| ExcelDataSet(String, String, IEnumerable<(Of <<'(DBColumn>)>>)) |
Creates a new instance of the ExcelDataSet class representing a data set that does not yet exist
|
Methods
| Name | Description | |
|---|---|---|
| CloseConnection |
Closes the connection to the database or, if the source is a file, closes the file. Ignored if connection is not open.
(Inherited from OleDbDataSet.) |
| CommitTransaction |
Ends a transaction by committing all changes.
(Inherited from OleDbDataSet.) |
| CreateTable |
Creates a new table in the database or a new file containing the fields in the Fields property.
(Overrides OleDbDataSet..::..CreateTable()()()().) |
| Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
 | Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
| GetEnumerator | Returns an enumerator that iterates through the collection. (Overrides OleDbDataSet..::..GetEnumerator()()()().) |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| OpenConnection |
Opens the connection to the database or, if the source is a file, opens the file. Ignored if connection is already open.
(Inherited from OleDbDataSet.) |
| PrepareForWrite |
Prepares the data set for one or more calls to WriteRecord(IDictionary<(Of <<'(DBColumn, Object>)>>)).
(Inherited from OleDbDataSet.) |
| RollbackTransaction |
Ends a transaction by reverting all changes.
(Inherited from OleDbDataSet.) |
| StartTransaction |
Begins a transaction. Transactions must be ended by calling either CommitTransaction()()()() or RollbackTransaction()()()() (Inherited from OleDbDataSet.) |
| ToString | Returns a String that represents the current Object. (Inherited from Object.) |
| WriteRecord |
Writes a single record to the database.
(Inherited from OleDbDataSet.) |
Properties
| Name | Description | |
|---|---|---|
 | ConnectionState |
The state of the connection to the database or the source file.
(Inherited from OleDbDataSet.) |
 | DBMS | (Inherited from OleDbDataSet.) |
| Fields | |
| FilePath |
The full file path to the spreadsheet.
|
| TableName |
The database table or file path where the data resides.
(Inherited from OleDbDataSet.) |
