How to set the default font name and size in C# and .NET
Working with spreadsheets is an important part of automating business processes, reporting, and analytics. The SautinSoft Excel .NET library provides rich functionality for creating, editing, and configuring Excel files programmatically. One of the most common tasks is to set standard display parameters — a specific font and its size, which will be automatically applied to cells or a worksheet.
In this article, we will explain in detail how to set the default font name and size for a worksheet in Excel using C# and .NET.
Advantages:
- Report automation. When generating large volumes of tables, it is important to ensure a uniform style so that the final image looks professional.
- Simplify subsequent editing. By setting a standard font and size, you eliminate the need for manual formatting of each file.
- Ensuring corporate standards. Many companies require the use of certain standards for paperwork.
- Increased efficiency. Automatic installation of styles significantly saves time when preparing reports.
Step-by-step guide:
- Add SautinSoft.Excel from Nuget.
- Create a new Excel document.
- Set default font name and size
- Add an empty worksheet.
- Inserting data.
- Save the Excel document.
Complete code
GitHubusing System;
using System.Collections.Generic;
using System.IO;
using SautinSoft.Excel;
namespace Example
{
class Program
{
static void Main(string[] args)
{
// Get your free key here:
// https://sautinsoft.com/start-for-free/
CreateExcelFontsSizeFromFile();
}
/// <summary>
/// Create a XLSX document with different fonts and size into ExcelDocument .
/// </summary>
/// <remarks>
/// Details: https://www.sautinsoft.com/products/excel/help/net/developer-guide/create-xlsx-font-size-net-csharp-vb.php
/// </remarks>
static void CreateExcelFontsSizeFromFile()
{
string outFile = @"..\..\..\Result.xlsx";
// The file format is detected automatically from the file extension: ".xlsx".
ExcelDocument excel = new ExcelDocument();
// Set default font name and size
excel.DefaultFontName = "Segoe UI";
excel.DefaultFontSize = 20;
// Add an empty worksheet to the file
excel.Worksheets.Add("Page 1");
var worksheet = excel.Worksheets["Page 1"];
// Sample data
List<List<object>> data = new List<List<object>>() {
new List<object> { "Date", "Product", "Category", "Quantity", "Unit Price", "Total Cost" },
new List<object> { new DateOnly(2024, 12, 1).ToString(), "Apples", "Fruits", 15, 1.2, "=D2*E2" },
new List<object> { new DateOnly(2024, 12, 1).ToString(), "Bread", "Bakery", 10, 0.8, "=D3*E3" },
new List<object> { new DateOnly(2024, 12, 2).ToString(), "Milk", "Dairy", 20, 1.5, "=D4*E4" },
new List<object> { new DateOnly(2024, 12, 2).ToString(), "Oranges", "Fruits", 10, 1.8, "=D5*E5" },
new List<object> { new DateOnly(2024, 12, 3).ToString(), "Chocolates", "Sweets", 5, 2.5, "=D6*E6" },
new List<object> { new DateOnly(2024, 12, 3).ToString(), "Potatoes", "Vegetables", 25, 0.5, "=D7*E7" },
};
// Inserting data
int i = 1;
foreach (var row in data)
{
int j = 0;
foreach (var item in row)
{
worksheet.Cells["ABCDEFGHIJKLMNOPQRSTUVWXYZ"[j] + i.ToString()].Value = item;
j++;
}
i++;
}
// Saving the excel document
excel.Save(outFile);
// Important for Linux: Install MS Fonts
// sudo apt install ttf-mscorefonts-installer -y
// Open the result for demonstration purposes.
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile) { UseShellExecute = true });
}
}
}Option Infer On
Imports System
Imports System.Collections.Generic
Imports System.IO
Imports SautinSoft.Excel
Namespace Example
Friend Class Program
Shared Sub Main(ByVal args() As String)
' Get your free key here:
' https://sautinsoft.com/start-for-free/
CreateExcelFontsSizeFromFile()
End Sub
''' <summary>
''' Create a XLSX document with different fonts and size into ExcelDocument .
''' </summary>
''' <remarks>
''' Details: https://www.sautinsoft.com/products/excel/help/net/developer-guide/create-xlsx-font-size-net-csharp-vb.php
''' </remarks>
Private Shared Sub CreateExcelFontsSizeFromFile()
Dim outFile As String = "..\..\..\Result.xlsx"
' The file format is detected automatically from the file extension: ".xlsx".
Dim excel As New ExcelDocument()
' Set default font name and size
excel.DefaultFontName = "Segoe UI"
excel.DefaultFontSize = 20
' Add an empty worksheet to the file
excel.Worksheets.Add("Page 1")
Dim worksheet = excel.Worksheets("Page 1")
' Sample data
Dim data As New List(Of List(Of Object))() _
From {
New List(Of Object) From {"Date", "Product", "Category", "Quantity", "Unit Price", "Total Cost"},
New List(Of Object) From {(New DateOnly(2024, 12, 1)).ToString(), "Apples", "Fruits", 15, 1.2, "=D2*E2"},
New List(Of Object) From {(New DateOnly(2024, 12, 1)).ToString(), "Bread", "Bakery", 10, 0.8, "=D3*E3"},
New List(Of Object) From {(New DateOnly(2024, 12, 2)).ToString(), "Milk", "Dairy", 20, 1.5, "=D4*E4"},
New List(Of Object) From {(New DateOnly(2024, 12, 2)).ToString(), "Oranges", "Fruits", 10, 1.8, "=D5*E5"},
New List(Of Object) From {(New DateOnly(2024, 12, 3)).ToString(), "Chocolates", "Sweets", 5, 2.5, "=D6*E6"},
New List(Of Object) From {(New DateOnly(2024, 12, 3)).ToString(), "Potatoes", "Vegetables", 25, 0.5, "=D7*E7"}
}
' Inserting data
Dim i As Integer = 1
For Each row In data
Dim j As Integer = 0
For Each item In row
worksheet.Cells("ABCDEFGHIJKLMNOPQRSTUVWXYZ".Chars(j) + i.ToString()).Value = item
j += 1
Next item
i += 1
Next row
' Saving the excel document
excel.Save(outFile)
' Important for Linux: Install MS Fonts
' sudo apt install ttf-mscorefonts-installer -y
' Open the result for demonstration purposes.
System.Diagnostics.Process.Start(New System.Diagnostics.ProcessStartInfo(outFile) With {.UseShellExecute = True})
End Sub
End Class
End Namespace
If you need a new code example or have a question: email us at support@sautinsoft.com or ask at Online Chat (right-bottom corner of this page) or use the Form below: