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); }