/// <summary>
/// Creates a ExcelWorkSheetDimension using a string with Cell Range representation like 'A1:B5'.
/// </summary>
/// <param name="dimension">a string with Cell Range representation like 'A1:B5'</param>
public ExcelWorkSheetDimension(String dimension)
{
String[] dimensions = dimension.Split(':');
this.topLeft = dimensions[0];
this.bottomRight = dimensions[1];
if (!ExcelCell.IsValidCellAddress(topLeft) || (!ExcelCell.IsValidCellAddress(BottomRight)))
{
throw new ArgumentException("No valid excel sheet dimension!");
}
firstRow = ExcelCell.GetRowNumber(topLeft);
firstCol = ExcelCell.GetColumnNumber(topLeft);
lastCol = ExcelCell.GetColumnNumber(bottomRight);
lastRow = ExcelCell.GetRowNumber(bottomRight);
}
