Style Cells, Borders, and Fonts in Excel with C#

VB C#

using IronSoftware.Drawing;
using IronXL;
using IronXL.Styles;
using System.Linq;

WorkBook workBook = WorkBook.Load("sample.xls");
WorkSheet workSheet = workBook.WorkSheets.First();

var range = workSheet["A1:H10"];

var cell = range.First();

// Set background color of the cell with an rgb string
cell.Style.SetBackgroundColor("#428D65");

// Apply styling to the whole range.

// Set underline property to the font
// FontUnderlineType is enum that stands for different types of font underlying
range.Style.Font.Underline = FontUnderlineType.SingleAccounting;

// Define whether to use horizontal line through the text or not
range.Style.Font.Strikeout = false;

// Define whether the font is bold or not
range.Style.Font.Bold = true;

// Define whether the font is italic or not
range.Style.Font.Italic = false;

// Get or set script property of a font
// Font script enum stands for available options
range.Style.Font.FontScript = FontScript.Super;

// Set the type of the border line
// There are also TopBorder,LeftBorder,RightBorder,DiagonalBorder properties
// BorderType enum indicates the line style of a border in a cell
range.Style.BottomBorder.Type = BorderType.MediumDashed;

// Indicate whether the cell should be auto-sized
range.Style.ShrinkToFit = true;

// Set alignment of the cell
range.Style.VerticalAlignment = VerticalAlignment.Bottom;

// Set border color
range.Style.DiagonalBorder.SetColor("#20C96F");

// Define border type and border direction as well
range.Style.DiagonalBorder.Type = BorderType.Thick;

// DiagonalBorderDirection enum stands for direction of diagonal border inside cell
range.Style.DiagonalBorderDirection = DiagonalBorderDirection.Forward;

// Set background color of cells
range.Style.SetBackgroundColor(Color.Aquamarine);

// Set fill pattern of the cell
// FillPattern enum indicates the style of fill pattern
range.Style.FillPattern = FillPattern.Diamonds;

// Set the number of spaces to intend the text
range.Style.Indention = 5;

// Indicate if the text is wrapped
range.Style.WrapText = true;

workBook.SaveAs("stylingOptions.xls");

Imports IronSoftware.Drawing
Imports IronXL
Imports IronXL.Styles
Imports System.Linq

Private workBook As WorkBook = WorkBook.Load("sample.xls")
Private workSheet As WorkSheet = workBook.WorkSheets.First()

Private range = workSheet("A1:H10")

Private cell = range.First()

' Set background color of the cell with an rgb string
cell.Style.SetBackgroundColor("#428D65")

' Apply styling to the whole range.

' Set underline property to the font
' FontUnderlineType is enum that stands for different types of font underlying
range.Style.Font.Underline = FontUnderlineType.SingleAccounting

' Define whether to use horizontal line through the text or not
range.Style.Font.Strikeout = False

' Define whether the font is bold or not
range.Style.Font.Bold = True

' Define whether the font is italic or not
range.Style.Font.Italic = False

' Get or set script property of a font
' Font script enum stands for available options
range.Style.Font.FontScript = FontScript.Super

' Set the type of the border line
' There are also TopBorder,LeftBorder,RightBorder,DiagonalBorder properties
' BorderType enum indicates the line style of a border in a cell
range.Style.BottomBorder.Type = BorderType.MediumDashed

' Indicate whether the cell should be auto-sized
range.Style.ShrinkToFit = True

' Set alignment of the cell
range.Style.VerticalAlignment = VerticalAlignment.Bottom

' Set border color
range.Style.DiagonalBorder.SetColor("#20C96F")

' Define border type and border direction as well
range.Style.DiagonalBorder.Type = BorderType.Thick

' DiagonalBorderDirection enum stands for direction of diagonal border inside cell
range.Style.DiagonalBorderDirection = DiagonalBorderDirection.Forward

' Set background color of cells
range.Style.SetBackgroundColor(Color.Aquamarine)

' Set fill pattern of the cell
' FillPattern enum indicates the style of fill pattern
range.Style.FillPattern = FillPattern.Diamonds

' Set the number of spaces to intend the text
range.Style.Indention = 5

' Indicate if the text is wrapped
range.Style.WrapText = True

workBook.SaveAs("stylingOptions.xls")

Install-Package IronXL.Excel

Style Cells, Borders, and Fonts in Excel with C#

IronXL allows C# developers to style any Excel Cell and Range in C#. IronXL covers most of the styling available in Microsoft Excel, such as fonts, text alignment, borders, colors, backgrounds, and patterns. The code example below shows a wide range of styles configurable with IronXL.

Individual Cell and Range borders (bottom, top, left, right, and diagonal) can be set to 14 different border styles such as dotted, dashed, and double, to name a few, using the enum BorderType. You can enable or disable the ShrinkToFit and WrapText properties to have more control over how the spreadsheet organizes cell sizes.

How to Use Excel Cell Border Style in C#

Install an Excel library to apply cell border styles.
Load the Excel file and set the default Worksheet.
Format the Worksheet using a Style object.
Save the changes to the Excel file.

// Ensure the IronXL package is installed via NuGet Package Manager

using IronXL;
using IronXL.Styles;

class ExcelStyler
{
    static void Main(string[] args)
    {
        // Load an existing Excel file
        WorkBook workbook = WorkBook.Load("example.xlsx");

        // Select the first worksheet in the workbook
        WorkSheet worksheet = workbook.WorkSheets.First();

        // Create a new style or modify an existing style
        Style style = worksheet["A1"].Style;

        // Set font properties
        style.Font.Size = 14; // Set font size
        style.Font.Bold = true; // Set bold font weight
        style.Font.Italic = true; // Set italic font style
        style.Font.Underline = IronXL.Styles.Underline.Single; // Set single underline

        // Set border properties
        style.Border.Bottom.Type = BorderType.Thick; // Set a thick bottom border
        style.Border.Bottom.Color = "#FF0000"; // Set bottom border color to red

        style.Border.Top.Type = BorderType.Dashed; // Set a dashed top border
        style.Border.Right.Type = BorderType.Double; // Set a double right border

        // Set some additional cell properties
        style.ShrinkToFit = true; // Enable Shrink to Fit
        style.WrapText = false; // Disable text wrapping

        // Apply the style to a specific cell
        worksheet["A1"].Style = style;

        // Save changes to the workbook
        workbook.SaveAs("formatted_example.xlsx");
    }
}

// Ensure the IronXL package is installed via NuGet Package Manager

using IronXL;
using IronXL.Styles;

class ExcelStyler
{
    static void Main(string[] args)
    {
        // Load an existing Excel file
        WorkBook workbook = WorkBook.Load("example.xlsx");

        // Select the first worksheet in the workbook
        WorkSheet worksheet = workbook.WorkSheets.First();

        // Create a new style or modify an existing style
        Style style = worksheet["A1"].Style;

        // Set font properties
        style.Font.Size = 14; // Set font size
        style.Font.Bold = true; // Set bold font weight
        style.Font.Italic = true; // Set italic font style
        style.Font.Underline = IronXL.Styles.Underline.Single; // Set single underline

        // Set border properties
        style.Border.Bottom.Type = BorderType.Thick; // Set a thick bottom border
        style.Border.Bottom.Color = "#FF0000"; // Set bottom border color to red

        style.Border.Top.Type = BorderType.Dashed; // Set a dashed top border
        style.Border.Right.Type = BorderType.Double; // Set a double right border

        // Set some additional cell properties
        style.ShrinkToFit = true; // Enable Shrink to Fit
        style.WrapText = false; // Disable text wrapping

        // Apply the style to a specific cell
        worksheet["A1"].Style = style;

        // Save changes to the workbook
        workbook.SaveAs("formatted_example.xlsx");
    }
}

' Ensure the IronXL package is installed via NuGet Package Manager

Imports IronXL
Imports IronXL.Styles

Friend Class ExcelStyler
	Shared Sub Main(ByVal args() As String)
		' Load an existing Excel file
		Dim workbook As WorkBook = WorkBook.Load("example.xlsx")

		' Select the first worksheet in the workbook
		Dim worksheet As WorkSheet = workbook.WorkSheets.First()

		' Create a new style or modify an existing style
		Dim style As Style = worksheet("A1").Style

		' Set font properties
		style.Font.Size = 14 ' Set font size
		style.Font.Bold = True ' Set bold font weight
		style.Font.Italic = True ' Set italic font style
		style.Font.Underline = IronXL.Styles.Underline.Single ' Set single underline

		' Set border properties
		style.Border.Bottom.Type = BorderType.Thick ' Set a thick bottom border
		style.Border.Bottom.Color = "#FF0000" ' Set bottom border color to red

		style.Border.Top.Type = BorderType.Dashed ' Set a dashed top border
		style.Border.Right.Type = BorderType.Double ' Set a double right border

		' Set some additional cell properties
		style.ShrinkToFit = True ' Enable Shrink to Fit
		style.WrapText = False ' Disable text wrapping

		' Apply the style to a specific cell
		worksheet("A1").Style = style

		' Save changes to the workbook
		workbook.SaveAs("formatted_example.xlsx")
	End Sub
End Class

$vbLabelText $csharpLabel

Comments: This C# code snippet shows how to style an Excel cell using the IronXL library. Key functionalities include setting font size, weight, underline styles, and customizing border styles for cells. It also demonstrates saving the modified Excel file using IronXL.