public void SetBorder(VTBorderWeight borderWeight, VTBorderIndex borderIndex = VTBorderIndex.All)
{
if (borderIndex == VTBorderIndex.All)
{
Range.Borders.Weight = GetBorderWeight(borderWeight);
}
else
{
XlBordersIndex xlBorderIndex = GetBorderIndex(borderIndex);
Range.Borders[xlBorderIndex].Weight = GetBorderWeight(borderWeight);
}
}
private XlBorderWeight GetBorderWeight(VTBorderWeight borderWeight)
{
XlBorderWeight bWeight;
switch (borderWeight)
{
case VTBorderWeight.HairLine: bWeight = XlBorderWeight.xlHairline;
break;
case VTBorderWeight.Thin: bWeight = XlBorderWeight.xlThin;
break;
case VTBorderWeight.Medium: bWeight = XlBorderWeight.xlMedium;
break;
case VTBorderWeight.Thick: bWeight = XlBorderWeight.xlThick;
break;
default: bWeight = XlBorderWeight.xlUndefined;
break;
}
return(bWeight);
}
public void SetBorder(VTBorderStyle borderStyle, VTBorderWeight borderWeight, VTBorderIndex borderIndex = VTBorderIndex.All)
{
SetBorder(borderStyle, borderIndex);
SetBorder(borderWeight, borderIndex);
}
