如何在 C# 中使用 Excel 单元格背景颜色

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.

   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.

   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

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.

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")

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.

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 $799 only.