public void SetBorder(VTBorderStyle borderStyle, VTBorderIndex borderIndex = VTBorderIndex.All)
{
if (borderIndex == VTBorderIndex.All)
{
Range.Borders.LineStyle = GetBorderStyle(borderStyle);
}
else
{
XlBordersIndex xlBorderIndex = GetBorderIndex(borderIndex);
Range.Borders[xlBorderIndex].LineStyle = GetBorderStyle(borderStyle);
}
}
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 XlBordersIndex GetBorderIndex(VTBorderIndex borderIndex)
{
XlBordersIndex xlBorderIndex;
switch (borderIndex)
{
case VTBorderIndex.Around: xlBorderIndex = XlBordersIndex.xlAround;
break;
case VTBorderIndex.DiagonalDown: xlBorderIndex = XlBordersIndex.xlDiagonalDown;
break;
case VTBorderIndex.DiagonalUp: xlBorderIndex = XlBordersIndex.xlDiagonalUp;
break;
case VTBorderIndex.EdgeBottom: xlBorderIndex = XlBordersIndex.xlEdgeBottom;
break;
case VTBorderIndex.EdgeLeft: xlBorderIndex = XlBordersIndex.xlEdgeLeft;
break;
case VTBorderIndex.EdgeRight: xlBorderIndex = XlBordersIndex.xlEdgeRight;
break;
case VTBorderIndex.EdgeTop: xlBorderIndex = XlBordersIndex.xlEdgeTop;
break;
case VTBorderIndex.InsideAll: xlBorderIndex = XlBordersIndex.xlInsideAll;
break;
case VTBorderIndex.InsideHorizontal: xlBorderIndex = XlBordersIndex.xlInsideHorizontal;
break;
case VTBorderIndex.InsideVertical: xlBorderIndex = XlBordersIndex.xlInsideVertical;
break;
default: xlBorderIndex = XlBordersIndex.xlInsideAll;
break;
}
return(xlBorderIndex);
}
public void SetBorder(VTBorderStyle borderStyle, VTBorderWeight borderWeight, VTBorderIndex borderIndex = VTBorderIndex.All)
{
SetBorder(borderStyle, borderIndex);
SetBorder(borderWeight, borderIndex);
}
public void SetBorder(VTBorderStyle boderStyle, VTBorderIndex borderIndex, int firstRow, int firstCoumn, int lastRow, int lastColumn)
{
IVTRange range = new VTRange(Worksheet.Range[firstRow, firstCoumn, lastRow, lastColumn], this);
range.SetBorder(boderStyle, borderIndex);
}
