private XlLineStyle GetBorderStyle(VTBorderStyle borderStyle)
{
XlLineStyle lineStyle;
switch (borderStyle)
{
case VTBorderStyle.Dashed: lineStyle = XlLineStyle.xlDash;
break;
case VTBorderStyle.Dotted: lineStyle = XlLineStyle.xlDot;
break;
case VTBorderStyle.Double: lineStyle = XlLineStyle.xlDouble;
break;
case VTBorderStyle.Hidden: lineStyle = XlLineStyle.xlLineStyleNone;
break;
case VTBorderStyle.Solid: lineStyle = XlLineStyle.xlContinuous;
break;
default: lineStyle = XlLineStyle.xlContinuous;
break;
}
return(lineStyle);
}
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(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);
}
