//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; IRange rangeB2 = worksheet.Range["B2"]; //set left, top, right, bottom borders together. rangeB2.Borders.LineStyle = BorderLineStyle.DashDot; rangeB2.Borders.Color = Color.Green; //set top border individually. rangeB2.Borders[BordersIndex.EdgeTop].LineStyle = BorderLineStyle.Medium; rangeB2.Borders[BordersIndex.EdgeTop].Color = Color.Red; //set diagonal down border individually. rangeB2.Borders[BordersIndex.DiagonalDown].LineStyle = BorderLineStyle.Hair; rangeB2.Borders[BordersIndex.DiagonalDown].Color = Color.Blue; //set diagonal up border individually. rangeB2.Borders[BordersIndex.DiagonalUp].LineStyle = BorderLineStyle.Dotted; rangeB2.Borders[BordersIndex.DiagonalUp].Color = Color.Blue; // Save to an excel file workbook.Save("AddBordersToCell.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) Dim rangeB2 As IRange = worksheet.Range!B2 'set left, top, right, bottom borders together. rangeB2.Borders.LineStyle = BorderLineStyle.DashDot rangeB2.Borders.Color = Color.Green 'set top border individually. rangeB2.Borders(BordersIndex.EdgeTop).LineStyle = BorderLineStyle.Medium rangeB2.Borders(BordersIndex.EdgeTop).Color = Color.Red 'set diagonal down border individually. rangeB2.Borders(BordersIndex.DiagonalDown).LineStyle = BorderLineStyle.Hair rangeB2.Borders(BordersIndex.DiagonalDown).Color = Color.Blue 'set diagonal up border individually. rangeB2.Borders(BordersIndex.DiagonalUp).LineStyle = BorderLineStyle.Dotted rangeB2.Borders(BordersIndex.DiagonalUp).Color = Color.Blue ' save to an excel file workbook.Save("AddBordersToCell.xlsx")