Formatting Borders
Output: FormattingBorders.xlsx
public void Run()
{
var workbook = new Workbook();
var worksheet = workbook.Worksheets[0];
worksheet.Columns[0].WidthCharacters = 11;
worksheet["A1"].Value = "Left Thick Border";
worksheet["B1"].Borders.Left = new Border(BorderStyle.Thick);
worksheet["A3"].Value = "Right Thick Border";
worksheet["B3"].Borders.Right = new Border(BorderStyle.Thick);
worksheet["A5"].Value = "Top Thick Border";
worksheet["B5"].Borders.Top = new Border(BorderStyle.Thick);
worksheet["A7"].Value = "Bottom Thick Border";
worksheet["B7"].Borders.Bottom = new Border(BorderStyle.Thick);
worksheet["A9"].Value = "Diagonal Up Border";
worksheet["B9"].Borders.SetDiagonalUpBorder(BorderStyle.Thick);
worksheet["A11"].Value = "Diagonal Down Border";
worksheet["B11"].Borders.SetDiagonalDownBorder(BorderStyle.Thick);
worksheet["A13"].Value = "Slant Dash Dot";
worksheet["B13"].Borders.SetBoxBorder(BorderStyle.SlantDashDot);
worksheet["A15"].Value = "Box Red";
worksheet["B15"].Borders.SetBoxBorder(BorderStyle.Thick, SpreadsheetColor.Red);
worksheet["A17"].Value = "Thin Cross Green";
worksheet["B17"].Borders.SetDiagonalCrossBorder(BorderStyle.Thin, SpreadsheetColor.Green);
workbook.SaveAs("FormattingBorders.xlsx");
}