/// <summary>
/// Gets the Escel range from worksheet.
/// </summary>
/// <param name="worksheet">The worksheet.</param>
/// <param name="area">The area.</param>
/// <returns></returns>
public static ExcelRange getExcelRange(this selectRangeArea area, ExcelWorksheet worksheet)
{
area = area.normalizeRange();
ExcelRange range = null;
try
{
range = worksheet.Cells[area.TopLeft.y + 1, area.TopLeft.x + 1, area.BottomRight.y + 1, area.BottomRight.x + 1];
}
catch (Exception ex)
{
throw ex;
}
return(range);
}
