Property | Type | Description | |
---|---|---|---|
m_aoCurrentSubrangeValues | ].Object[ | ||
m_iCurrentRowOneBased | |||
m_oColumnIndexesOneBased | Int32>.Dictionary | ||
m_oCurrentSubrange | Range | ||
m_oTable | ListObject |
Method | Description | |
---|---|---|
ExcelTableReader ( ListObject table ) : System |
Initializes a new instance of the ExcelTableReader class. If table has hidden columns, an exception is thrown. Use the ExcelColumnHider class to temporarily show all hidden columns if necessary. |
|
GetRows ( ) : IEnumerable |
Method | Description | |
---|---|---|
GetRangeForCellInCurrentRow ( String sColumnName ) : Range | ||
TryGetDoubleFromCellInCurrentRow ( String sColumnName, Double &dDouble ) : System.Boolean | ||
TryGetInt32FromCellInCurrentRow ( String sColumnName, |
||
TryGetNonEmptyStringFromCellInCurrentRow ( String sColumnName, String &sNonEmptyString ) : System.Boolean |
Method | Description | |
---|---|---|
AssertValid ( ) : void |
public ExcelTableReader ( ListObject table ) : System | ||
table | ListObject | /// The table to read. The table must have no hidden columns. /// |
return | System |
protected GetRangeForCellInCurrentRow ( String sColumnName ) : Range | ||
sColumnName | String | |
return | Range |
protected TryGetDoubleFromCellInCurrentRow ( String sColumnName, Double &dDouble ) : System.Boolean | ||
sColumnName | String | |
dDouble | Double | |
return | System.Boolean |
protected TryGetInt32FromCellInCurrentRow ( String sColumnName, |
||
sColumnName | String | |
iInt32 | ||
return | System.Boolean |
protected TryGetNonEmptyStringFromCellInCurrentRow ( String sColumnName, String &sNonEmptyString ) : System.Boolean | ||
sColumnName | String | |
sNonEmptyString | String | |
return | System.Boolean |
protected Object[,] m_aoCurrentSubrangeValues | ||
return | ].Object[ |
protected Int32,System m_iCurrentRowOneBased | ||
return |
protected Dictionary |
||
return | Int32>.Dictionary |