如何在 C# 中使用 Excel 字体样式

How to Use C# Excel Font Style

1. Open or create a project in C#.
2. Use NuGet to install the IronXL library.
3. Use the IronXL namespace in your C# program.
4. Load an Excel file using var workbook = WorkBook.Load("example.xlsx");.
5. Select a worksheet using var sheet = workbook.WorkSheets[0];.
6. Define a range of cells using var range = sheet["A1:B2"];.
7. Set font properties such as style using range.Style.Font.Name = "Calibri";, font size with range.Style.Font.Size = 12;, color with range.Style.Font.Color = "#FF0000";, and other properties like range.Style.Font.Bold = true; and range.Style.Font.Italic = true;.
8. Preserve the worksheet by saving it as "sample.xlsx" using the SaveAs() method.

IronXL

Before diving into Excel font styles, let's quickly introduce IronXL. IronXL is a popular C# library that allows you to create, read, and manipulate Excel files within C# applications easily. It offers a user-friendly API for working with Excel files, making tasks like reading, writing, and formatting data significantly more accessible.

Developers can utilize IronXL to automate Excel-related processes using C#. For C# developers looking to interact with Excel files programmatically, its user-friendly interface and comprehensive documentation make it the go-to option.

Some of IronXL's key characteristics are listed below:

• Excel File Creation & Editing: IronXL facilitates the creation and editing of Excel files, enabling you to start from scratch and make changes to preexisting ones. Worksheets, rows, columns, and cells can all be programmatically added, removed, or altered.
• Excel File Reading: It has strong functionality for reading data from Excel files. Effective data processing and analysis are made possible by the simplicity with which cell values, formulas, formatting, and other metadata may be extracted.
• Writing to Excel Files: IronXL provides easy support for writing data to Excel files. It is perfect for creating reports, exporting data, and automating data input jobs since it allows you to fill cells with values, formulas, and formatting.
• Formatting and Style: The library provides extensive assistance with the formatting and styling of Excel documents. Spreadsheets can be made to look professional and eye-catching by adjusting font styles, colors, borders, alignment, and other aspects.
• Formula Support: You can use IronXL to work programmatically with Excel formulas. Formula dependencies can be easily handled, values can be calculated, and formulae can be specified for specific cells.
• Chart Creation: It lets you make graphs and charts inside Excel documents. For an effective visual representation of data and patterns, you can create a variety of chart formats, such as pie charts, bar charts, and line charts.
• Data Validation: You can set rules and limitations for cell values using IronXL's data validation tools. To guarantee data correctness and integrity, you can validate input using criteria like range, list, date, and custom formulas.
• Protection and Encryption: Excel files can be password-protected and encrypted using the capability provided by the library. To protect your documents from unwanted access, you can set permissions, restrict access, and encrypt important data.
• Integration with .NET apps: IronXL offers C# developers a recognizable and user-friendly programming interface with its smooth integration with .NET applications. Its extensive feature set and comprehensive set of APIs are easy to integrate into your current .NET applications.

IronXL is a feature-rich and adaptable C# library for manipulating Excel that provides a multitude of options to help you simplify your activities connected to Excel. IronXL offers the features and tools you need to be successful, whether you're building data-driven applications, analyzing data, or producing reports. Refer to the documentation here to learn more.

Creating a New Project in Visual Studio

To open the Visual Studio application, select File from the File menu. After selecting "New Project," select "Console application."

After choosing the file location, type the project name into the assigned text field. Subsequently, pick the required .NET Framework by clicking the Create button, as demonstrated in the sample below.

The Visual Studio project's organization will then depend on the selected application. To add code and construct the application, just open the program.cs file. The internet application, Windows, or console can all be used.

The code can then be tested and the library added.

Installing IronXL Library

The following patch requires the installation of the IronXL library. Finally, launch the NuGet Package Manager Console and use the following command to complete the installation.

Install-Package IronXL.Excel

An alternative would be to use the NuGet Package Manager to search for the package "IronXL". We may choose which of the NuGet packages associated with IronXL have to be downloaded from this list of all of them.

Excel font style using IronXL

To begin, allow me to demonstrate how to set font characteristics for a range of cells in a basic way:

using IronXL;

class Program
{
    static void Main(string [] args)
    {
        // Load the existing Excel workbook
        WorkBook workbook = WorkBook.Load("Demo.xlsx");

        // Select the first worksheet
        WorkSheet sheet = workbook.WorkSheets[0];

        // Define the range of cells
        var range = sheet["A1:B2"];

        // Set font characteristics for the range of cells
        range.Style.Font.Name = "Calibri";  // Font name
        range.Style.Font.Size = 12;         // Font size
        range.Style.Font.Color = "#FF0000"; // Font color
        range.Style.Font.Bold = true;       // Bold font
        range.Style.Font.Italic = true;     // Italicized font

        // Save the modified workbook as a new file
        workbook.SaveAs("Sample.xlsx");
    }
}

using IronXL;

class Program
{
    static void Main(string [] args)
    {
        // Load the existing Excel workbook
        WorkBook workbook = WorkBook.Load("Demo.xlsx");

        // Select the first worksheet
        WorkSheet sheet = workbook.WorkSheets[0];

        // Define the range of cells
        var range = sheet["A1:B2"];

        // Set font characteristics for the range of cells
        range.Style.Font.Name = "Calibri";  // Font name
        range.Style.Font.Size = 12;         // Font size
        range.Style.Font.Color = "#FF0000"; // Font color
        range.Style.Font.Bold = true;       // Bold font
        range.Style.Font.Italic = true;     // Italicized font

        // Save the modified workbook as a new file
        workbook.SaveAs("Sample.xlsx");
    }
}

Imports IronXL

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the existing Excel workbook
		Dim workbook As WorkBook = WorkBook.Load("Demo.xlsx")

		' Select the first worksheet
		Dim sheet As WorkSheet = workbook.WorkSheets(0)

		' Define the range of cells
		Dim range = sheet("A1:B2")

		' Set font characteristics for the range of cells
		range.Style.Font.Name = "Calibri" ' Font name
		range.Style.Font.Size = 12 ' Font size
		range.Style.Font.Color = "#FF0000" ' Font color
		range.Style.Font.Bold = True ' Bold font
		range.Style.Font.Italic = True ' Italicized font

		' Save the modified workbook as a new file
		workbook.SaveAs("Sample.xlsx")
	End Sub
End Class

The Excel file "Demo.xlsx" is being loaded into the WorkBook object first. It will create a new file with this name if the current one doesn't exist. In this case, we are choosing the workbook's first worksheet (WorkSheet). If the workbook has more than one sheet, you can select a particular sheet by name or index. Within the chosen Excel worksheet, we designate a range of cells from cell A1 to cell B2. This enables us to set font styles for this particular cell range.

For the chosen range of cells, these lines set the following font object properties:

• Font.Name: Defines the font type (Calibri).
• Font.Size: Sets the font size.
• Font.Color: Changes the font color to red (#FF0000 in hexadecimal).
• Font.Bold: Makes the text bold.
• Font.Italic: Apply italics to the text.

Lastly, we save the altered worksheet to a new file called "Sample.xlsx" after applying the font styles. Below is the output generated from the above code.

// Select the range of cells
var fontrange = sheet["A1:B1"];
fontrange.Style.Font.Name = "Calibri"; // Set font name

// Select the range of cells
var fontrange = sheet["A1:B1"];
fontrange.Style.Font.Name = "Calibri"; // Set font name

' Select the range of cells
Dim fontrange = sheet("A1:B1")
fontrange.Style.Font.Name = "Calibri" ' Set font name

// Select the range of cells
var fontrange = sheet["A1:B1"];
fontrange.Style.Font.Color = "#FF0000"; // Set font color

// Select the range of cells
var fontrange = sheet["A1:B1"];
fontrange.Style.Font.Color = "#FF0000"; // Set font color

' Select the range of cells
Dim fontrange = sheet("A1:B1")
fontrange.Style.Font.Color = "#FF0000" ' Set font color

// Select the range of cells
var fontrange = sheet["A1:B1"];
fontrange.Style.Font.Bold = true; // Set font to bold

// Select the range of cells
var fontrange = sheet["A1:B1"];
fontrange.Style.Font.Bold = true; // Set font to bold

' Select the range of cells
Dim fontrange = sheet("A1:B1")
fontrange.Style.Font.Bold = True ' Set font to bold

// Select the range of cells
var fontrange = sheet["A1:B1"];
fontrange.Style.Font.Italic = true; // Set font to italic

// Select the range of cells
var fontrange = sheet["A1:B1"];
fontrange.Style.Font.Italic = true; // Set font to italic

' Select the range of cells
Dim fontrange = sheet("A1:B1")
fontrange.Style.Font.Italic = True ' Set font to italic

Conclusion

Excel spreadsheet readability and visual appeal are greatly improved by the use of font styles. Programmatically changing font styles becomes simple and scalable when using C# and IronXL. If you need to apply styles to specific cells or format large ranges of cells, whether you're creating a new workbook or editing an existing one, IronXL offers an extensive toolkit to fulfill your needs.

By mastering Excel font styles using C# and IronXL, you can create professional-looking spreadsheets that effectively communicate your data and insights. A refined and powerful user experience may be achieved by careful consideration of font styling, whether you're creating dashboards, reports, or data-driven applications.

When it comes to processing and presenting data, the options are endless. Having IronXL in your toolbox gives you the ability to manage a variety of activities linked to Excel in your C# programs. When ready to commit, users can start using IronXL for free. Check here to learn more about the Iron software product.