Skip to footer content
USING IRONXL

How To Set Background Color in Excel Cell Using C#

This article will discuss the C# Excel library that can be used to manage and manipulate Excel files using C#.

IronXL is a popular C# library that provides a comprehensive set of features for working with Excel files. It allows you to read, write, and manipulate Excel spreadsheets using a simple and intuitive API. IronXL supports various formatting options, including setting the background color of cells and also font color.

1. IronXL

In the world of software development, working with Excel files is a common requirement, whether it's for data processing, reporting, or data analysis. To facilitate Excel manipulation in C# applications, the IronXL library comes to the rescue.

IronXL provides developers with a comprehensive set of APIs and functionalities to interact with Excel workbooks, worksheets, cells, formulas, styles, and more. It leverages the capabilities of the Office Open XML (OOXML) format, which is the default file format for Excel since Microsoft Office 2007. This means that IronXL is compatible with a wide range of Excel versions, making it a versatile choice for Excel automation tasks.

With IronXL, you can effortlessly create, edit, and manipulate Excel files programmatically using C#. It offers an intuitive and straightforward API that simplifies complex tasks such as reading data from multiple worksheets, writing data to specific cells, applying formatting and styling, performing calculations, and even generating charts.

2. Prerequisites

Prerequisites for working with IronXL:

  1. Development Environment: You should have an integrated development environment (IDE) such as Visual Studio installed on your computer.
  2. C# Knowledge: Basic knowledge of the C# programming language.
  3. IronXL: You need to have the IronXL library installed in your project. This can be done using the NuGet Package Manager in Visual Studio or through the command line interface.
  4. Excel File: You should have an existing Excel file, or create a new one that you want to modify and set the background color of specific cells.

3. Create a new C# Project

To work with IronXL, first, you need to create a new project in Visual Studio.

  1. Open Visual Studio, go to Files and click on New Project.

    How To Set Background Color in Excel Cell Using C#, Figure 1: Create a new project in Visual Studio Create a new project in Visual Studio

  2. A new window will appear, in this new window select "Console Application" and click on the Next button.

    How To Set Background Color in Excel Cell Using C#, Figure 2: Select a Console Application for the new project Select a Console Application for the new project

  3. In the last window Select the target framework, set the location and name of this new project, and click on the Create button.

Your new project in Visual Studio is created.

4. Installing IronXL

IronXL offers many ways to install this library, but those are the most effective approaches:

  1. Install IronXL Using NuGet Package Manager
  2. Install IronXL Using Package Manager Console

4.1 Install IronXL Using NuGet Package Manager

To add the IronXL library to your Visual Studio project using the NuGet Package Manager, search for IronXL in the Browse tab:

After finding IronXL in the search results, simply choose the package and initiate the installation process. Once the installation is finished, you can begin utilizing the IronXL library within your project.

The following screenshot demonstrates the process of accessing the NuGet Package Manager within Visual Studio.

How To Set Background Color in Excel Cell Using C#, Figure 3: Navigate to NuGet Package Manager Navigate to NuGet Package Manager

IronXL in search results:

How To Set Background Color in Excel Cell Using C#, Figure 4: Search and install the IronXL package in NuGet Package Manager UI Search and install the IronXL package in NuGet Package Manager UI

4.2 Using the Visual Studio Command Line

A popular method among developers for package installation is through the command line interface. To install IronXL using the command line, follow these steps:

  1. In Visual Studio, navigate to Tools > NuGet Package Manager > Package Manager Console.
  2. Open the Package Manager Console tab.
  3. Enter the following command in the console:

    Install-Package IronXL
    Install-Package IronXL
    SHELL
  4. Press Enter to execute the command. This will initiate the download and installation of the IronXL package for the current project.

Once the process is complete, you can start utilizing the IronXL library in your project.

How To Set Background Color in Excel Cell Using C#, Figure 5: Install the IronXL package in the Package Manager Console Install the IronXL package in the Package Manager Console

5. Setting Cell Background Color In Excel File Using IronXL

IronXL is the best choice when it comes to manipulating Excel files and changing its cell's background color. This section will explain how you can easily set the Excel Cell background color in an Excel Document. First, we need a sample Excel document to change its cell color.

How To Set Background Color in Excel Cell Using C#, Figure 6: a sample Excel file a sample Excel file

The following source code will show how to do so.

using IronXL;
using IronXL.Styles;
using System.Linq;

// Load an existing Excel workbook
WorkBook workBook = WorkBook.Load("datatable.xlsx");

// Accesses the first worksheet from the workbook
WorkSheet workSheet = workBook.WorkSheets.First();

// Define a range of cells in the worksheet (A1 to A10)
var range = workSheet["A1:A10"];

// Select the first cell in the defined range
var cell = range.First();

// Set background color of the selected cell using an RGB color string
cell.Style.SetBackgroundColor("#428D65");

// Save the modified workbook to a new file
workBook.SaveAs("stylingOptions3.xlsx");
using IronXL;
using IronXL.Styles;
using System.Linq;

// Load an existing Excel workbook
WorkBook workBook = WorkBook.Load("datatable.xlsx");

// Accesses the first worksheet from the workbook
WorkSheet workSheet = workBook.WorkSheets.First();

// Define a range of cells in the worksheet (A1 to A10)
var range = workSheet["A1:A10"];

// Select the first cell in the defined range
var cell = range.First();

// Set background color of the selected cell using an RGB color string
cell.Style.SetBackgroundColor("#428D65");

// Save the modified workbook to a new file
workBook.SaveAs("stylingOptions3.xlsx");
Imports IronXL
Imports IronXL.Styles
Imports System.Linq

' Load an existing Excel workbook
Private workBook As WorkBook = WorkBook.Load("datatable.xlsx")

' Accesses the first worksheet from the workbook
Private workSheet As WorkSheet = workBook.WorkSheets.First()

' Define a range of cells in the worksheet (A1 to A10)
Private range = workSheet("A1:A10")

' Select the first cell in the defined range
Private cell = range.First()

' Set background color of the selected cell using an RGB color string
cell.Style.SetBackgroundColor("#428D65")

' Save the modified workbook to a new file
workBook.SaveAs("stylingOptions3.xlsx")
$vbLabelText   $csharpLabel

The above code example opens an Excel file using the WorkBook.Load method. Then, it loads the first worksheet using the workBook.WorkSheets.First() method. Next, the SetBackgroundColor method adds color to the selected cell. Finally, save the Excel WorkBook file using WorkBook.SaveAs.

Here is an output screenshot of the above source code example.

How To Set Background Color in Excel Cell Using C#, Figure 7: The formatted Excel file The formatted Excel file

As you can see, the background color of cell A1 in column A is changed to green.

6. Conclusion

Setting the background color of Excel cells using C# can be achieved with the help of libraries like IronXL. IronXL provides a comprehensive set of APIs and functionalities to interact with Excel files, allowing you to read, write, and manipulate Excel spreadsheets programmatically. By using IronXL, you can easily set the background color of cells in an Excel file by specifying the RGB color code. This can be beneficial for improving readability and highlighting important information in your Excel spreadsheets.

With its intuitive API and compatibility with various Excel versions, IronXL is a powerful and versatile choice for Excel automation tasks in C#.

You can get a related tutorial at the following Excel cell formatting tutorial. For more information on IronXL, visit another read Excel file tutorial. Visit the API reference page to know more about the class calls of the interface IStyle.

IronXL is available to users for a free trial and can be licensed for commercial use with its Lite package starting from $749 only.

Frequently Asked Questions

What is a popular C# library for working with Excel files?

IronXL is a popular C# library that provides a comprehensive set of features for working with Excel files. It allows you to read, write, and manipulate Excel spreadsheets using a simple and intuitive API, including setting the background color of cells.

What are the prerequisites for using a C# Excel library?

To work with IronXL, you need a development environment like Visual Studio, basic knowledge of C#, the IronXL library installed in your project, and an Excel file to modify.

How do I install a C# Excel library using NuGet Package Manager?

To install IronXL using NuGet Package Manager, search for IronXL in the Browse tab of the NuGet Package Manager in Visual Studio, select the package, and initiate the installation process.

Can I install a C# Excel library using Visual Studio Command Line?

Yes, to install IronXL using the Visual Studio Command Line, navigate to Tools > NuGet Package Manager > Package Manager Console, and enter the command 'Install-Package IronXL' to initiate the download and installation.

How can I set the background color of an Excel cell using a C# library?

You can set the background color of an Excel cell using IronXL by defining a range of cells, selecting the specific cell, and using the SetBackgroundColor method with an RGB color string.

Is a C# Excel library compatible with all Excel versions?

IronXL is compatible with a wide range of Excel versions as it leverages the capabilities of the Office Open XML (OOXML) format, the default file format for Excel since Microsoft Office 2007.

What are the benefits of using a C# Excel library for automation?

IronXL provides an intuitive API that simplifies complex tasks like reading, writing, and formatting Excel files, making it a powerful choice for Excel automation tasks in C#.

Is there a free trial for a C# Excel library?

Yes, IronXL is available for a free trial, and it can be licensed for commercial use with its Lite package.

Where can I find more tutorials on using a C# Excel library?

You can find more tutorials, like the Excel cell formatting tutorial, on the IronXL website, along with API reference pages to explore class calls further.

Regan Pun
Software Engineer
Regan graduated from the University of Reading, with a BA in Electronic Engineering. Before joining Iron Software, his previous job roles had him laser-focused on single tasks; and what he most enjoys at Iron Software is the spectrum of work he gets to undertake, whether it’s adding value to sales, technical support, product development or marketing. He enjoys understanding the way developers are using the Iron Software library, and using that knowledge to continually improve documentation and develop the products.