ExcelTableReader Class |
Namespace: MicaSystems.Utils.Excel
public class ExcelTableReader : DataSet, IDisposable
The ExcelTableReader type exposes the following members.
Name | Description | |
---|---|---|
ExcelTableReader |
Initializes a new instance of the ExcelTableReader class.
|
Name | Description | |
---|---|---|
CaseSensitive | Gets or sets a value indicating whether string comparisons within DataTable objects are case-sensitive. (Inherited from DataSet.) | |
Container | Gets the container for the component. (Inherited from MarshalByValueComponent.) | |
DataSetName | Gets or sets the name of the current DataSet. (Inherited from DataSet.) | |
DefaultViewManager | Gets a custom view of the data contained in the DataSet to allow filtering, searching, and navigating using a custom DataViewManager. (Inherited from DataSet.) | |
DesignMode | Gets a value indicating whether the component is currently in design mode. (Inherited from MarshalByValueComponent.) | |
EnforceConstraints | Gets or sets a value indicating whether constraint rules are followed when attempting any update operation. (Inherited from DataSet.) | |
Events | Gets the list of event handlers that are attached to this component. (Inherited from MarshalByValueComponent.) | |
ExtendedProperties | Gets the collection of customized user information associated with the DataSet. (Inherited from DataSet.) | |
HasErrors | Gets a value indicating whether there are errors in any of the DataTable objects within this DataSet. (Inherited from DataSet.) | |
IsInitialized | Gets a value that indicates whether the DataSet is initialized. (Inherited from DataSet.) | |
Locale | Gets or sets the locale information used to compare strings within the table. (Inherited from DataSet.) | |
Namespace | Gets or sets the namespace of the DataSet. (Inherited from DataSet.) | |
Prefix | Gets or sets an XML prefix that aliases the namespace of the DataSet. (Inherited from DataSet.) | |
Relations | Get the collection of relations that link tables and allow navigation from parent tables to child tables. (Inherited from DataSet.) | |
RemotingFormat | Gets or sets a SerializationFormat for the DataSet used during remoting. (Inherited from DataSet.) | |
SchemaSerializationMode | Gets or sets a SchemaSerializationMode for a DataSet. (Inherited from DataSet.) | |
Site | (Inherited from DataSet.) | |
SpreadSheetDocument |
Gets the OpenXml document.
| |
Tables | Gets the collection of tables contained in the DataSet. (Inherited from DataSet.) |
Name | Description | |
---|---|---|
AcceptChanges | Commits all the changes made to this DataSet since it was loaded or since the last time AcceptChanges() was called. (Inherited from DataSet.) | |
BeginInit | Begins the initialization of a DataSet that is used on a form or used by another component. The initialization occurs at run time. (Inherited from DataSet.) | |
Clear | Clears the DataSet of any data by removing all rows in all tables. (Inherited from DataSet.) | |
Clone | Copies the structure of the DataSet, including all DataTable schemas, relations, and constraints. Does not copy any data. (Inherited from DataSet.) | |
ColumnAddressToIndex |
Transforms an Excel column letter to a column index.
| |
Copy | Copies both the structure and data for this DataSet. (Inherited from DataSet.) | |
Create(Byte[]) |
Creates an new instance of ExcelTableReader..
| |
Create(MemoryStream) |
Creates an new instance of ExcelTableReader..
| |
CreateDataReader() | Returns a DataTableReader with one result set per DataTable, in the same sequence as the tables appear in the Tables collection. (Inherited from DataSet.) | |
CreateDataReader(DataTable[]) | Returns a DataTableReader with one result set per DataTable. (Inherited from DataSet.) | |
DateSerialToDateTime |
Gets a DateTimeOffset corresponding from the specified value obtained from Excel.
| |
DetermineSchemaSerializationMode(XmlReader) | Determines the SchemaSerializationMode for a DataSet. (Inherited from DataSet.) | |
DetermineSchemaSerializationMode(SerializationInfo, StreamingContext) | Determines the SchemaSerializationMode for a DataSet. (Inherited from DataSet.) | |
Dispose() | Releases all resources used by the MarshalByValueComponent. (Inherited from MarshalByValueComponent.) | |
Dispose(Boolean) | Releases the unmanaged resources used by the MarshalByValueComponent and optionally releases the managed resources. (Inherited from MarshalByValueComponent.) | |
EndInit | Ends the initialization of a DataSet that is used on a form or used by another component. The initialization occurs at run time. (Inherited from DataSet.) | |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from MarshalByValueComponent.) | |
GetCellValue |
Retrieves the value of a cell, given a file name, sheet name and address name.
| |
GetChanges() | Gets a copy of the DataSet that contains all changes made to it since it was loaded or since AcceptChanges() was last called. (Inherited from DataSet.) | |
GetChanges(DataRowState) | 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. (Inherited from DataSet.) | |
GetDefinedNames |
Returns a collection of all of the defined names that are contained within the workbook.
| |
GetObjectData | Populates a serialization information object with the data needed to serialize the DataSet. (Inherited from DataSet.) | |
GetSchemaSerializable | Returns a serializable XMLSchema instance. (Inherited from DataSet.) | |
GetSerializationData | Deserializes the table data from the binary or XML stream. (Inherited from DataSet.) | |
GetService | Gets the implementer of the IServiceProvider. (Inherited from MarshalByValueComponent.) | |
GetTables |
Gets the tables of all worksheets in the document.
| |
GetWorksheets |
Gets the worksheets of the document.
| |
GetXml | Returns the XML representation of the data stored in the DataSet. (Inherited from DataSet.) | |
GetXmlSchema | Returns the XML Schema for the XML representation of the data stored in the DataSet. (Inherited from DataSet.) | |
HasChanges() | Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows. (Inherited from DataSet.) | |
HasChanges(DataRowState) | Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows, filtered by DataRowState. (Inherited from DataSet.) | |
IndexToColumnAddress |
Transforms a column index to an Excel column letter.
| |
InferXmlSchema(XmlReader,String[]) | (Inherited from DataSet.) | |
InferXmlSchema(Stream,String[]) | (Inherited from DataSet.) | |
InferXmlSchema(TextReader,String[]) | Applies the XML schema from the specified TextReader to the DataSet. (Inherited from DataSet.) | |
InferXmlSchema(String,String[]) | Applies the XML schema from the specified file to the DataSet. (Inherited from DataSet.) | |
InitializeDerivedDataSet | Deserialize all of the tables data of the DataSet from the binary or XML stream. (Inherited from DataSet.) | |
IsBinarySerialized | Inspects the format of the serialized representation of the DataSet. (Inherited from DataSet.) | |
Load(IDataReader, LoadOption,DataTable[]) | 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. (Inherited from DataSet.) | |
Load(IDataReader, LoadOption,String[]) | 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. (Inherited from DataSet.) | |
Load(IDataReader, LoadOption, FillErrorEventHandler,DataTable[]) | 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. (Inherited from DataSet.) | |
Merge(DataSet) | Merges a specified DataSet and its schema into the current DataSet. (Inherited from DataSet.) | |
Merge(DataTable) | (Inherited from DataSet.) | |
Merge(DataRow[]) | (Inherited from DataSet.) | |
Merge(DataSet, Boolean) | Merges a specified DataSet and its schema into the current DataSet, preserving or discarding any changes in this DataSet according to the given argument. (Inherited from DataSet.) | |
Merge(DataSet, Boolean, MissingSchemaAction) | 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. (Inherited from DataSet.) | |
Merge(DataTable, Boolean, MissingSchemaAction) | 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. (Inherited from DataSet.) | |
Merge(DataRow[], Boolean, MissingSchemaAction) | 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. (Inherited from DataSet.) | |
OnPropertyChanging | Raises the OnPropertyChanging(PropertyChangedEventArgs) event. (Inherited from DataSet.) | |
OnRemoveRelation | Occurs when a DataRelation object is removed from a DataTable. (Inherited from DataSet.) | |
OnRemoveTable | (Inherited from DataSet.) | |
RaisePropertyChanging | Sends a notification that the specified DataSet property is about to change. (Inherited from DataSet.) | |
ReadXml(XmlReader) | (Inherited from DataSet.) | |
ReadXml(Stream) | (Inherited from DataSet.) | |
ReadXml(TextReader) | Reads XML schema and data into the DataSet using the specified TextReader. (Inherited from DataSet.) | |
ReadXml(String) | Reads XML schema and data into the DataSet using the specified file. (Inherited from DataSet.) | |
ReadXml(XmlReader, XmlReadMode) | (Inherited from DataSet.) | |
ReadXml(Stream, XmlReadMode) | (Inherited from DataSet.) | |
ReadXml(TextReader, XmlReadMode) | (Inherited from DataSet.) | |
ReadXml(String, XmlReadMode) | Reads XML schema and data into the DataSet using the specified file and XmlReadMode. (Inherited from DataSet.) | |
ReadXmlSchema(XmlReader) | (Inherited from DataSet.) | |
ReadXmlSchema(Stream) | (Inherited from DataSet.) | |
ReadXmlSchema(TextReader) | Reads the XML schema from the specified TextReader into the DataSet. (Inherited from DataSet.) | |
ReadXmlSchema(String) | Reads the XML schema from the specified file into the DataSet. (Inherited from DataSet.) | |
ReadXmlSerializable | Ignores attributes and returns an empty DataSet. (Inherited from DataSet.) | |
RejectChanges | Rolls back all the changes made to the DataSet since it was created, or since the last time AcceptChanges() was called. (Inherited from DataSet.) | |
Reset | 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. (Inherited from DataSet.) | |
ShouldSerializeRelations | Gets a value indicating whether Relations property should be persisted. (Inherited from DataSet.) | |
ShouldSerializeTables | Gets a value indicating whether Tables property should be persisted. (Inherited from DataSet.) | |
SplitAddress |
Splits an Excel cell's address into two parts.
| |
ToString | Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from MarshalByValueComponent.) | |
WriteXml(Stream) | (Inherited from DataSet.) | |
WriteXml(TextWriter) | Writes the current data for the DataSet using the specified TextWriter. (Inherited from DataSet.) | |
WriteXml(XmlWriter) | (Inherited from DataSet.) | |
WriteXml(String) | Writes the current data for the DataSet to the specified file. (Inherited from DataSet.) | |
WriteXml(Stream, XmlWriteMode) | 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. (Inherited from DataSet.) | |
WriteXml(TextWriter, XmlWriteMode) | 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. (Inherited from DataSet.) | |
WriteXml(XmlWriter, XmlWriteMode) | 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. (Inherited from DataSet.) | |
WriteXml(String, XmlWriteMode) | 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. (Inherited from DataSet.) | |
WriteXmlSchema(Stream) | (Inherited from DataSet.) | |
WriteXmlSchema(String) | Writes the DataSet structure as an XML schema to a file. (Inherited from DataSet.) | |
WriteXmlSchema(TextWriter) | Writes the DataSet structure as an XML schema to the specified TextWriter object. (Inherited from DataSet.) | |
WriteXmlSchema(XmlWriter) | (Inherited from DataSet.) | |
WriteXmlSchema(Stream, Converter<Type, String>) | (Inherited from DataSet.) | |
WriteXmlSchema(String, Converter<Type, String>) | Writes the DataSet structure as an XML schema to a file. (Inherited from DataSet.) | |
WriteXmlSchema(TextWriter, Converter<Type, String>) | Writes the DataSet structure as an XML schema to the specified TextWriter. (Inherited from DataSet.) | |
WriteXmlSchema(XmlWriter, Converter<Type, String>) | (Inherited from DataSet.) |
Name | Description | |
---|---|---|
Disposed | Adds an event handler to listen to the Disposed event on the component. (Inherited from MarshalByValueComponent.) | |
Initialized | Occurs after the DataSet is initialized. (Inherited from DataSet.) | |
MergeFailed | Occurs when a target and source DataRow have the same primary key value, and EnforceConstraints is set to true. (Inherited from DataSet.) |
Name | Description | |
---|---|---|
As<T> |
Casts an object to another type. Returns default(T) if the object is null.
(Defined by Utils_Other.) | |
EqualsAll |
Checks that this object is equal to every object in parameters.
(Defined by Utils_Other.) | |
EqualsAny |
Checks that this object is equal to at least one of the parameters.
(Defined by Utils_Other.) | |
GetString |
Converts an object to String using ToString() method, else returns String.Empty.
(Defined by Utils_Other.) | |
IsGenericList() | Overloaded.
Checks if this object is a System.Collections.Generic.List.
(Defined by Utils_Linq.) | |
IsGenericList(Type) | Overloaded.
Checks if this object is a System.Collections.Generic.List using type as T.
(Defined by Utils_Linq.) | |
Serialize() | Overloaded.
Serializes an object into an XML document.
(Defined by Utils_Xml.) | |
Serialize(String) | Overloaded.
Serializes an object into an XML document.
(Defined by Utils_Xml.) | |
SerializeJson() | Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.) | |
SerializeJson(List<Type>) | Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.) | |
SerializeJson(DataContractJsonSerializerSettings) | Overloaded.
Serializes an object using a DataContractJsonSerializer.
(Defined by Utils_String.) |