How to Set Cell Border and Alignment

using IronXL;
using IronXL.Styles;

// This code demonstrates how to create an Excel workbook, modify a specific cell by adjusting its value,
// borders, and alignment, and then save the workbook to a file.

// Create a new Excel workbook
WorkBook workBook = WorkBook.Create();

// Access the default worksheet within the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Assign a value to cell B2
workSheet["B2"].Value = "B2";

// Set the left and right borders for cell B2 to be medium dashed
workSheet["B2"].Style.LeftBorder.Type = BorderType.MediumDashed;
workSheet["B2"].Style.RightBorder.Type = BorderType.MediumDashed;

// Center align the text within cell B2
workSheet["B2"].Style.Alignment.Horizontal = HorizontalAlignment.Center;

// Save the workbook to a file with the specified name
workBook.SaveAs("setBorderAndAlignment.xlsx");

Imports IronXL

Imports IronXL.Styles



' This code demonstrates how to create an Excel workbook, modify a specific cell by adjusting its value,

' borders, and alignment, and then save the workbook to a file.



' Create a new Excel workbook

Private workBook As WorkBook = WorkBook.Create()



' Access the default worksheet within the workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Assign a value to cell B2

Private workSheet("B2").Value = "B2"



' Set the left and right borders for cell B2 to be medium dashed

Private workSheet("B2").Style.LeftBorder.Type = BorderType.MediumDashed

Private workSheet("B2").Style.RightBorder.Type = BorderType.MediumDashed



' Center align the text within cell B2

Private workSheet("B2").Style.Alignment.Horizontal = HorizontalAlignment.Center



' Save the workbook to a file with the specified name

workBook.SaveAs("setBorderAndAlignment.xlsx")

using IronXL;
using IronXL.Styles;
using IronSoftware.Drawing;

// This script creates a new Excel workbook and sets specific styles for a cell in a worksheet.

// Create a new workbook
WorkBook workBook = WorkBook.Create();

// Access the default worksheet in the newly created workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set the left and right border types of the cell B2 to Thick
workSheet["B2"].Style.LeftBorder.Type = BorderType.Thick;
workSheet["B2"].Style.RightBorder.Type = BorderType.Thick;

// Set the left border color to Aquamarine using the predefined Color enumeration
workSheet["B2"].Style.LeftBorder.SetColor(Color.Aquamarine);

// Set the right border color using a hex color code
workSheet["B2"].Style.RightBorder.SetColor("#FF7F50");

// Save the workbook to a file named "setBorderColor.xlsx"
workBook.SaveAs("setBorderColor.xlsx");

Imports IronXL

Imports IronXL.Styles

Imports IronSoftware.Drawing



' This script creates a new Excel workbook and sets specific styles for a cell in a worksheet.



' Create a new workbook

Private workBook As WorkBook = WorkBook.Create()



' Access the default worksheet in the newly created workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Set the left and right border types of the cell B2 to Thick

Private workSheet("B2").Style.LeftBorder.Type = BorderType.Thick

Private workSheet("B2").Style.RightBorder.Type = BorderType.Thick



' Set the left border color to Aquamarine using the predefined Color enumeration

workSheet("B2").Style.LeftBorder.SetColor(Color.Aquamarine)



' Set the right border color using a hex color code

workSheet("B2").Style.RightBorder.SetColor("#FF7F50")



' Save the workbook to a file named "setBorderColor.xlsx"

workBook.SaveAs("setBorderColor.xlsx")

using IronXL;
using IronXL.Styles;

// This code snippet demonstrates creating an Excel workbook with some basic styling using IronXL library.

// Create a new workbook
WorkBook workBook = WorkBook.Create();

// Access the default worksheet in the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set the string value for cell B2
workSheet["B2"].StringValue = "Top";

// Set the string value for cell B4
workSheet["B4"].StringValue = "Forward";

// Set a thick top border for cell B2
workSheet["B2"].Style.TopBorder.Type = BorderType.Thick;

// Set a thick diagonal border for cell B4
workSheet["B4"].Style.DiagonalBorder.Type = BorderType.Thick;

// Set the diagonal border direction to 'Forward' for cell B4
workSheet["B4"].Style.DiagonalBorderDirection = DiagonalBorderDirection.Forward;

// Save the workbook to a file named "borderLines.xlsx"
// The SaveAs method generates the file at the specified path
workBook.SaveAs("borderLines.xlsx");

Imports IronXL

Imports IronXL.Styles



' This code snippet demonstrates creating an Excel workbook with some basic styling using IronXL library.



' Create a new workbook

Private workBook As WorkBook = WorkBook.Create()



' Access the default worksheet in the workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Set the string value for cell B2

Private workSheet("B2").StringValue = "Top"



' Set the string value for cell B4

Private workSheet("B4").StringValue = "Forward"



' Set a thick top border for cell B2

Private workSheet("B2").Style.TopBorder.Type = BorderType.Thick



' Set a thick diagonal border for cell B4

Private workSheet("B4").Style.DiagonalBorder.Type = BorderType.Thick



' Set the diagonal border direction to 'Forward' for cell B4

Private workSheet("B4").Style.DiagonalBorderDirection = DiagonalBorderDirection.Forward



' Save the workbook to a file named "borderLines.xlsx"

' The SaveAs method generates the file at the specified path

workBook.SaveAs("borderLines.xlsx")