ExcelTableReader Methods

Commits all the changes made to this DataSet since it was loaded or since the last time AcceptChanges was called.

Begins the initialization of a DataSet that is used on a form or used by another component. The initialization occurs at run time.

Clears the DataSet of any data by removing all rows in all tables.

Copies the structure of the DataSet, including all DataTable schemas, relations, and constraints. Does not copy any data.

Transforms an Excel column letter to a column index.

Copies both the structure and data for this DataSet.

Creates an new instance of ExcelTableReader..

Creates an new instance of ExcelTableReader..

Returns a DataTableReader with one result set per DataTable, in the same sequence as the tables appear in the Tables collection.

Returns a DataTableReader with one result set per DataTable.

Gets a DateTimeOffset corresponding from the specified value obtained from Excel.

Determines the SchemaSerializationMode for a DataSet.

Determines the SchemaSerializationMode for a DataSet.

Releases all resources used by the MarshalByValueComponent.

Releases the unmanaged resources used by the MarshalByValueComponent and optionally releases the managed resources.

Ends the initialization of a DataSet that is used on a form or used by another component. The initialization occurs at run time.

Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.

Retrieves the value of a cell, given a file name, sheet name and address name.

Gets a copy of the DataSet that contains all changes made to it since it was loaded or since AcceptChanges was last called.

Gets a copy of the DataSet containing all changes made to it since it was last loaded, or since AcceptChanges was called, filtered by DataRowState.

Returns a collection of all of the defined names that are contained within the workbook.

Populates a serialization information object with the data needed to serialize the DataSet.

Returns a serializable XMLSchema instance.

Deserializes the table data from the binary or XML stream.

Gets the implementer of the IServiceProvider.

Gets the tables of all worksheets in the document.

Gets the worksheets of the document.

Returns the XML representation of the data stored in the DataSet.

Returns the XML Schema for the XML representation of the data stored in the DataSet.

Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows.

Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows, filtered by DataRowState.

Transforms a column index to an Excel column letter.

Applies the XML schema from the specified XmlReader to the DataSet.

Applies the XML schema from the specified Stream to the DataSet.

Applies the XML schema from the specified TextReader to the DataSet.

Applies the XML schema from the specified file to the DataSet.

Deserialize all of the tables data of the DataSet from the binary or XML stream.

Inspects the format of the serialized representation of the DataSet.

Fills a DataSet with values from a data source using the supplied IDataReader, using an array of DataTable instances to supply the schema and namespace information.

Fills a DataSet with values from a data source using the supplied IDataReader, using an array of strings to supply the names for the tables within the DataSet.

Fills a DataSet with values from a data source using the supplied IDataReader, using an array of DataTable instances to supply the schema and namespace information.

Merges a specified DataSet and its schema into the current DataSet.

Merges a specified DataTable and its schema into the current DataSet.

Merges an array of DataRow objects into the current DataSet.

Merges a specified DataSet and its schema into the current DataSet, preserving or discarding any changes in this DataSet according to the given argument.

Merges a specified DataSet and its schema with the current DataSet, preserving or discarding changes in the current DataSet and handling an incompatible schema according to the given arguments.

Merges a specified DataTable and its schema into the current DataSet, preserving or discarding changes in the DataSet and handling an incompatible schema according to the given arguments.

Merges an array of DataRow objects into the current DataSet, preserving or discarding changes in the DataSet and handling an incompatible schema according to the given arguments.

Raises the OnPropertyChanging(PropertyChangedEventArgs) event.

Occurs when a DataRelation object is removed from a DataTable.

Occurs when a DataTable is removed from a DataSet.

Sends a notification that the specified DataSet property is about to change.

Reads XML schema and data into the DataSet using the specified XmlReader.

Reads XML schema and data into the DataSet using the specified Stream.

Reads XML schema and data into the DataSet using the specified TextReader.

Reads XML schema and data into the DataSet using the specified file.

Reads XML schema and data into the DataSet using the specified XmlReader and XmlReadMode.

Reads XML schema and data into the DataSet using the specified Stream and XmlReadMode.

Reads XML schema and data into the DataSet using the specified TextReader and XmlReadMode.

Reads XML schema and data into the DataSet using the specified file and XmlReadMode.

Reads the XML schema from the specified XmlReader into the DataSet.

Reads the XML schema from the specified Stream into the DataSet.

Reads the XML schema from the specified TextReader into the DataSet.

Reads the XML schema from the specified file into the DataSet.

Ignores attributes and returns an empty DataSet.

Rolls back all the changes made to the DataSet since it was created, or since the last time AcceptChanges was called.

Clears all tables and removes all relations, foreign constraints, and tables from the DataSet. Subclasses should override Reset to restore a DataSet to its original state.

Gets a value indicating whether Relations property should be persisted.

Gets a value indicating whether Tables property should be persisted.

Splits an Excel cell's address into two parts.

Returns a String containing the name of the Component, if any. This method should not be overridden.

Writes the current data for the DataSet using the specified Stream.

Writes the current data for the DataSet using the specified TextWriter.

Writes the current data for the DataSet to the specified XmlWriter.

Writes the current data for the DataSet to the specified file.

Writes the current data, and optionally the schema, for the DataSet using the specified Stream and XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema.

Writes the current data, and optionally the schema, for the DataSet using the specified TextWriter and XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema.

Writes the current data, and optionally the schema, for the DataSet using the specified XmlWriter and XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema.

Writes the current data, and optionally the schema, for the DataSet to the specified file using the specified XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema.

Writes the DataSet structure as an XML schema to the specified Stream object.

Writes the DataSet structure as an XML schema to a file.

Writes the DataSet structure as an XML schema to the specified TextWriter object.

Writes the DataSet structure as an XML schema to an XmlWriter object.

Writes the DataSet structure as an XML schema to the specified Stream object.

Writes the DataSet structure as an XML schema to a file.

Writes the DataSet structure as an XML schema to the specified TextWriter.

Writes the DataSet structure as an XML schema to the specified XmlWriter.

Casts an object to another type. Returns default(T) if the object is null.

Checks that this object is equal to every object in parameters.

Checks that this object is equal to at least one of the parameters.

Converts an object to String using ToString() method, else returns String.Empty.

Checks if this object is a System.Collections.Generic.List.

Checks if this object is a System.Collections.Generic.List using type as T.

Serializes an object into an XML document.

Serializes an object into an XML document.

Serializes an object using a DataContractJsonSerializer.

Serializes an object using a DataContractJsonSerializer.

Serializes an object using a DataContractJsonSerializer.