| ExcelWorksheetData Methods |
The ExcelWorksheetData type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | ArrayT |
Returns the content of the cell at columnName cast to an array.
|
| Bool(Int32) |
Returns the content of the nth cell cast to a bool.
|
| Bool(String) |
Returns the content of the cell at columnName cast to a bool.
|
| Bool(Int32, Boolean) |
Returns the content of the nth cell cast to a bool. If the cell is empty then 'emptyValue' is returned.
|
| Bool(String, Boolean) |
Returns the content of the cell at columnName cast to a bool. If the cell is empty then 'emptyValue' is returned.
|
| Byte(Byte) |
Returns the content of the nth cell cast to a byte.
|
| Byte(String) |
Returns the content of the cell at columnName cast to a byte.
|
| Byte(Byte, Byte) |
Returns the content of the nth cell cast to a byte. If the cell is empty then 'emptyValue' is returned.
|
| Byte(String, Byte) |
Returns the content of the cell at columnName cast to a byte. If the cell is empty then 'emptyValue' is returned.
|
 | Bytes(Int32) |
Returns the content of the nth cell as an array of bytes.
|
| Bytes(String) |
Returns the content of the cell at columnName as an array of bytes.
|
| Char(Int32) |
Returns the content of the nth cell cast to a char.
|
| Char(String) |
Returns the content of the cell at columnName cast to a char.
|
| Char(Int32, Char) |
Returns the content of the nth cell cast to a char. If the cell is empty then 'emptyValue' is returned.
|
| Char(String, Char) |
Returns the content of the cell at columnName cast to a char. If the cell is empty then 'emptyValue' is returned.
|
| ColumnExists |
Returns true if there is a column with the name passed across.
|
| ConvertString |
Converts the raw value to a value of the type passed across.
|
| DateTime(Int32) |
Returns the content of the nth cell cast to a DateTime.
|
| DateTime(String) |
Returns the content of the cell at columnName cast to a DateTime.
|
| DateTime(Int32, DateTime) |
Returns the content of the nth cell cast to a DateTime. If the cell is empty then 'emptyValue' is returned.
|
| DateTime(String, DateTime) |
Returns the content of the cell at columnName cast to a DateTime. If the cell is empty then 'emptyValue' is returned.
|
| Decimal(Int32) |
Returns the content of the nth cell cast to a decimal.
|
| Decimal(String) |
Returns the content of the cell at columnName cast to a decimal.
|
| Decimal(Int32, Decimal) |
Returns the content of the nth cell cast to a decimal. If the cell is empty then 'emptyValue' is returned.
|
| Decimal(String, Decimal) |
Returns the content of the cell at columnName cast to a decimal. If the cell is empty then 'emptyValue' is returned.
|
| Double(Int32) |
Returns the content of the nth cell cast to a double.
|
| Double(String) |
Returns the content of the cell at columnName cast to a double.
|
| Double(Int32, Double) |
Returns the content of the nth cell cast to a double. If the cell is empty then 'emptyValue' is returned.
|
| Double(String, Double) |
Returns the content of the cell at columnName cast to a double. If the cell is empty then 'emptyValue' is returned.
|
| Equals | (Inherited from Object.) |
| EString(Int32) |
Returns the content of the nth cell as a string. If the cell content is "" then String.Empty is returned. If the cell is empty then null is returned.
|
| EString(String) |
Returns the content of the cell at columnName as a string. If the cell content is "" then String.Empty is returned. If the cell is empty then null is returned.
|
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| Float(Int32) |
Returns the content of the nth cell cast to a float.
|
| Float(String) |
Returns the content of the cell at columnName cast to a float.
|
| Float(Int32, Single) |
Returns the content of the nth cell cast to a float. If the cell is empty then 'emptyValue' is returned.
|
| Float(String, Single) |
Returns the content of the cell at columnName cast to a float. If the cell is empty then 'emptyValue' is returned.
|
| GetColumnT(Int32, T) |
Returns the content of the column cast to type or a default value if the column has no value.
|
| GetColumnT(String, T) |
Returns the content of the column cast to type or a default value if the column has no value.
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetNullableColumnT(Int32) |
Returns the content of the column cast to a nullable of the type or null if the column has no value.
|
| GetNullableColumnT(String) |
Returns the content of the column cast to a nullable of the type or null if the column has no value.
|
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| Int(Int32) |
Returns the content of the nth cell cast to an int.
|
| Int(String) |
Returns the content of the cell at columnName cast to an int.
|
| Int(Int32, Int32) |
Returns the content of the nth cell cast to an int. If the cell is empty then 'emptyValue' is returned.
|
| Int(String, Int32) |
Returns the content of the cell at columnName cast to an int. If the cell is empty then 'emptyValue' is returned.
|
| Long(Int32) |
Returns the content of the nth cell cast to a long.
|
| Long(String) |
Returns the content of the cell at columnName cast to a long.
|
| Long(Int32, Int64) |
Returns the content of the nth cell cast to a long. If the cell is empty then 'emptyValue' is returned.
|
| Long(String, Int64) |
Returns the content of the cell at columnName cast to a long. If the cell is empty then 'emptyValue' is returned.
|
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| NBool(Int32) |
Returns the content of the nth cell cast to a nullable bool.
|
| NBool(String) |
Returns the content of the cell at columnName cast to a nullable bool.
|
| NByte(Byte) |
Returns the content of the nth cell cast to a nullable byte.
|
| NByte(String) |
Returns the content of the cell at columnName cast to a nullable byte.
|
| NChar(Int32) |
Returns the content of the nth cell cast to a nullable char.
|
| NChar(String) |
Returns the content of the cell at columnName cast to a nullable char.
|
| NDateTime(Int32) |
Returns the content of the nth cell cast to a nullable DateTime.
|
| NDateTime(String) |
Returns the content of the cell at columnName cast to a nullable DateTime.
|
| NDecimal(Int32) |
Returns the content of the nth cell cast to a nullable decimal.
|
| NDecimal(String) |
Returns the content of the cell at columnName cast to a nullable decimal.
|
| NDouble(Int32) |
Returns the content of the nth cell cast to a nullable double.
|
| NDouble(String) |
Returns the content of the cell at columnName cast to a nullable double.
|
| NFloat(Int32) |
Returns the content of the nth cell cast to a nullable float.
|
| NFloat(String) |
Returns the content of the cell at columnName cast to a nullable float.
|
| NInt(Int32) |
Returns the content of the nth cell cast to a nullable int.
|
| NInt(String) |
Returns the content of the cell at columnName cast to a nullable int.
|
| NLong(Int32) |
Returns the content of the nth cell cast to a nullable long.
|
| NLong(String) |
Returns the content of the cell at columnName cast to a nullable long.
|
| NShort(Int16) |
Returns the content of the nth cell cast to a nullable short.
|
| NShort(String) |
Returns the content of the cell at columnName cast to a nullable short.
|
| ParseEnumT(Int32) |
Returns the content of the nth cell cast to an enum.
|
| ParseEnumT(String) |
Returns the content of the cell at columnName cast to an enum.
|
| Short(Int16) |
Returns the content of the nth cell cast to an short.
|
| Short(String) |
Returns the content of the cell at columnName cast to an short.
|
| Short(Int16, Int16) |
Returns the content of the nth cell cast to an short. If the cell is empty then 'emptyValue' is returned.
|
| Short(String, Int16) |
Returns the content of the cell at columnName cast to an short. If the cell is empty then 'emptyValue' is returned.
|
| String(Int32) |
Returns the string content of the nth cell.
|
| String(String) |
Returns the string content of the cell at columnName.
|
| String(Int32, String) |
Returns the string content of the nth cell. If the cell is empty then 'emptyValue' is returned.
|
| String(String, String) |
Returns the string content of the cell at columnName. If the cell is empty then 'emptyValue' is returned.
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| UInt(Int32) |
Returns the content of the nth cell cast to a uint.
|
| UInt(String) |
Returns the content of the cell at columnName cast to a uint.
|
| UInt(Int32, UInt32) |
Returns the content of the nth cell cast to a uint. If the cell is empty then 'emptyValue' is returned.
|
| UInt(String, UInt32) |
Returns the content of the cell at columnName cast to a uint. If the cell is empty then 'emptyValue' is returned.
|
| ULong(Int32) |
Returns the content of the nth cell cast to a ulong.
|
| ULong(String) |
Returns the content of the cell at columnName cast to a ulong.
|
| ULong(Int32, UInt64) |
Returns the content of the nth cell cast to a ulong. If the cell is empty then 'emptyValue' is returned.
|
| ULong(String, UInt64) |
Returns the content of the cell at columnName cast to a ulong. If the cell is empty then 'emptyValue' is returned.
|
| UShort(Int32) |
Returns the content of the nth cell cast to a ushort.
|
| UShort(String) |
Returns the content of the cell at columnName cast to a ushort.
|
| UShort(Int32, UInt16) |
Returns the content of the nth cell cast to a ushort. If the cell is empty then 'emptyValue' is returned.
|
| UShort(String, UInt16) |
Returns the content of the cell at columnName cast to a ushort. If the cell is empty then 'emptyValue' is returned.
|
See Also