/// <summary>
/// 2017/08/11 AKB Nguyen Thanh Tung
/// Set Border for Range
/// </summary>
/// <param name="strRange">Range</param>
/// <param name="border">Border</param>
public void SetBorderRange(string strRange, emBorder border, Color color, emLineStyle lineStyle = emLineStyle.xlContinuous, emBorderWeight weight = emBorderWeight.xlThin)
{
try
{
_parameters = new object[1];
_parameters[0] = strRange;
_mobjRange = GetProperty(_mobjWorkSheet, "Range", _parameters);
_parameters[0] = border;
_mobjRange2 = GetProperty(_mobjRange, "Borders", _parameters);
_parameters[0] = weight;
SetProperty(_mobjRange2, "Weight", _parameters);
_parameters[0] = color;
SetProperty(_mobjRange2, "Color", _parameters);
_parameters[0] = lineStyle;
SetProperty(_mobjRange2, "LineStyle", _parameters);
}
catch (Exception e)
{
XWriteLogs(System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), e.Message);
}
finally
{
FreeMemory();
}
}
/// <summary>
/// 2017/08/11 AKB Nguyen Thanh Tung
/// Set All Boder for Range
/// </summary>
/// <param name="strRange">Range</param>
public void SetBorderAllRange(string strRange, Color color, emLineStyle lineStyle = emLineStyle.xlContinuous, emBorderWeight weight = emBorderWeight.xlThin)
{
try
{
SetBorderRange(strRange, emBorder.xlEdgeTop, color, lineStyle, weight);
SetBorderRange(strRange, emBorder.xlEdgeBottom, color, lineStyle, weight);
SetBorderRange(strRange, emBorder.xlEdgeLeft, color, lineStyle, weight);
SetBorderRange(strRange, emBorder.xlEdgeRight, color, lineStyle, weight);
SetBorderRange(strRange, emBorder.xlInsideHorizontal, color, lineStyle, weight);
SetBorderRange(strRange, emBorder.xlInsideVertical, color, lineStyle, weight);
}
catch (Exception e)
{
XWriteLogs(System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), e.Message);
}
finally
{
FreeMemory();
}
}
