USING IRONXL

How to Use C# Excel Font Style

Published April 29, 2024
Share:

Introduction

One of the most effective programs for manipulating and visualizing data is still Microsoft Excel. Its adaptability includes the ability to structure and customize data to meet individual needs in addition to its extensive feature set. To improve data presentation and make it more legible and visually appealing, font styles are essential. A common way to manipulate font styles with Excel in C# is using the Font property using Microsoft.Office.Interop.Excel. However, this option isn't as flexible or convenient as alternative _solutions._ Hence, this post will discuss using IronXL, on how to use C# Excel to set font style.

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 IronXL to import the IronXL namespace.
  4. Use var workbook = WorkBook to load an Excel file."example.xlsx" is loaded.
  5. Go to var sheet = workbook to select a worksheet.WorkSheets [0];.
  6. var range = sheet ["A1:B2"]; defines a range of cells.
  7. Font properties can be set to range.Font.Styles.Calibri, 12; SetFont."#FF0000" is the font color set. Set Bold to true.Set Italic as true.
  8. Preserve the worksheet by saving it as "sample.xlsx" using the SaveAs() option.

IronXL

Let us take a quick look at IronXL before we get into Excel font styles. Create, read, and manipulate Excel files within C# applications with ease thanks to IronXL, a well-liked C# library. It offers an easy-to-use API for working with Excel files, greatly increasing the accessibility of tasks like reading, writing, and formatting data.

Developers can IronXL to automate processes associated with Excel 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:

  • 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 papers 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 apps. Its extensive feature set and comprehensive set of APIs are easy to integrate into your current .NET apps.

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

How to Use C# Excel Font Style: Figure 1 - The Visual Studio Application page

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.

How to Use C# Excel Font Style: Figure 2 - The Visual Studio Application page: Enter the desired project name

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.

How to Use C# Excel Font Style: Figure 3 - Select the corresponding frameworks for your project

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

How to Use C# Excel Font Style: Figure 4 - Opening the NuGet Package Manager console and enter the installation command

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 has to be downloaded from this list of all of them.

How to Use C# Excel Font Style: Figure 5 - Searching and installing IronXL using the browse feature from NuGet Package Manager

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)
    {
        WorkBook workbook = WorkBook.Load("Demo.xlsx");
        // Select the worksheet
        WorkSheet sheet = workbook.WorkSheets [0];
    // font style code here
        // Save the workbook
        workbook.SaveAs("Sample.xlsx");
    }
}
using IronXL;
class Program
{
    static void Main(string [] args)
    {
        WorkBook workbook = WorkBook.Load("Demo.xlsx");
        // Select the worksheet
        WorkSheet sheet = workbook.WorkSheets [0];
    // font style code here
        // Save the workbook
        workbook.SaveAs("Sample.xlsx");
    }
}
Imports IronXL
Friend Class Program
	Shared Sub Main(ByVal args() As String)
		Dim workbook As WorkBook = WorkBook.Load("Demo.xlsx")
		' Select the worksheet
		Dim sheet As WorkSheet = workbook.WorkSheets (0)
	' font style code here
		' Save the workbook
		workbook.SaveAs("Sample.xlsx")
	End Sub
End Class
VB   C#

The Excel file "example.xlsx" that already exists 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.Color: This function 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.

Setting Font Name

.An IFont interface that exposes the FontName field is given via the Style property. You can specify the preferred font name for the cell using this parameter.

// Select the range of cells
        var fontrange = sheet ["A1:B1"];
    fontrange.Style.Font.Name = "Calibri"; // font name
// Select the range of cells
        var fontrange = sheet ["A1:B1"];
    fontrange.Style.Font.Name = "Calibri"; // font name
' Select the range of cells
		Dim fontrange = sheet ("A1:B1")
	fontrange.Style.Font.Name = "Calibri" ' font name
VB   C#

How to Use C# Excel Font Style: Figure 6 - Code example changing the font style programmatically

Setting Font Color

An IFont interface that exposes the Color property is given by the Style property. You can use a hex code string to set the font color with this property. Six hexadecimal digits are used to define colors in hex codes (e.g., #FF0000 for red, #00FFFF for cyan). To obtain the proper hex code for the color of your typeface, there are numerous color pickers available online.

// Select the range of cells
        var fontrange = sheet ["A1:B1"];
    fontrange.Style.Font.Color = "#FF0000";
// Select the range of cells
        var fontrange = sheet ["A1:B1"];
    fontrange.Style.Font.Color = "#FF0000";
' Select the range of cells
		Dim fontrange = sheet ("A1:B1")
	fontrange.Style.Font.Color = "#FF0000"
VB   C#

How to Use C# Excel Font Style: Figure 7 - Code example changing the font color programmatically

Setting Font Bold

The Bold property is exposed through the IFontFormatting interface that is provided by the Style property. The font's boldness is set by this attribute, which is a boolean value. To make the typeface bold in the selected cell, set the Bold property to true.

// Select the range of cells
        var fontrange = sheet ["A1:B1"];
        fontrange.Style.Font.Bold = true;
// Select the range of cells
        var fontrange = sheet ["A1:B1"];
        fontrange.Style.Font.Bold = true;
' Select the range of cells
		Dim fontrange = sheet ("A1:B1")
		fontrange.Style.Font.Bold = True
VB   C#

How to Use C# Excel Font Style: Figure 8 - Code example changing the font to Bold programmatically

Setting Font Italic

The Italic property is exposed through the IFontFormatting interface that is provided by the Style property. This property, which is a boolean value, controls whether or not the typeface is italic. To make the font italic in the selected cell, set the Italic property to true.

// Select the range of cells
        var fontrange = sheet ["A1:B1"];
        fontrange.Style.Font.Italic = true;
// Select the range of cells
        var fontrange = sheet ["A1:B1"];
        fontrange.Style.Font.Italic = true;
' Select the range of cells
		Dim fontrange = sheet ("A1:B1")
		fontrange.Style.Font.Italic = True
VB   C#

How to Use C# Excel Font Style: Figure 9 - Code example changing the font to Italic programmatically

The above list of codes shows you how to use IronXL to programmatically change the font styles in Excel using C#. You may quickly alter how text appears in Excel spreadsheets by loading an existing workbook, choosing a worksheet, specifying a range of cells, and adjusting font attributes. Although not shown above, you can also similarly modify the font size for a specific cell or the entire worksheet, for a list of attributes regarding the interface IFont refer to here, and to know more about the code example refer to here.

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.

< PREVIOUS
How to Create a new Excel Workbook in C#
NEXT >
How to Rename Excel WorkSheet in C#

Ready to get started? Version: 2024.11 just released

Free NuGet Download Total downloads: 1,086,940 View Licenses >