XLTable Class

Represents an Excel table.

Inheritance Hierarchy

SystemObject
MicaSystems.Utils.ExcelXLTable

Namespace: MicaSystems.Utils.Excel
Assembly: MicaSystems.Utils (in MicaSystems.Utils.dll) Version: 1.0.0.0 (1.1.0.123)

Syntax

public class XLTable

The XLTable type exposes the following members.

Constructors

	Name	Description
	XLTable	Initializes a new instance of the XLTable class.

Properties

	Name	Description
	Columns	Gets the table columns.
	Id	Gets the table id.
	Name	Gets the table name.
	Range	Gets the table range.
	Sheet	Gets the table parent worksheet.
	SpreadsheetDocument	Gets the table parent spreadsheet.

Methods

	Name	Description
	ColumnCount	Gets the count of columns of the table.
	ColumnEndAddress	Gets the name of the ending column of the table.
	ColumnEndIndex	Gets the index of the ending column of the table.
	ColumnStartAddress	Gets the name of the starting column of the table.
	ColumnStartIndex	Gets the index of the starting column of the table.
	GetRow	Gets a row by its index.
	RangeEnd	Gets the end of the range definition.
	RangeStart	Gets the start of the range definition.
	RowCount	Gets the count of rows of the table.
	RowEndIndex	Gets the index of the ending row of the table.
	RowStartIndex	Gets the index of the starting row of the table.
	ToString	Returns a string that represents the current object. (Inherited from Object.)

Extension Methods

	Name	Description
	AsT	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(ListType)	Overloaded. Serializes an object using a DataContractJsonSerializer. (Defined by Utils_String.)
	SerializeJson(DataContractJsonSerializerSettings)	Overloaded. Serializes an object using a DataContractJsonSerializer. (Defined by Utils_String.)