Adding Text to an Excel document using C# and .NET
In today's world of data processing, programming and automating many routine tasks are becoming a necessity. One such solution is SautinSoft.Excel library. In this article, we will look at how to add text to an Excel document using C# and .NET and why such a function is needed.
Adding text to an Excel document can be used in a variety of scenarios:- Report Automation. Developers can create applications that automatically generate reports by filling them with data from databases or other sources.
- Data processing. When working with large amounts of information, the ability to programmatically add text to tables can speed up the data processing process and minimize the likelihood of errors.
- Dynamic information update. It is often necessary to update Excel data in response to changes in the system. Automated scripts can minimize the time required for manual data entry.
- Generating custom documents. Creating personalized documents for clients, such as invoices or contracts, can be simplified by automation.
Step-by-step guide:
- Add SautinSoft.Excel from Nuget.
- Create a new Excel document and add an empty worksheet.
- Insert the content with different formatting.
- Save the Excel document.
Полный код
GitHubusing System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using SautinSoft.Excel;
using SkiaSharp;
namespace Example
{
class Program
{
static void Main(string[] args)
{
// Get your free key here:
// https://sautinsoft.com/start-for-free/
AllTypesOfText();
}
/// <summary>
/// Using various methods of inserting text into cells.
/// </summary>
/// <remarks>
/// Details: https://www.sautinsoft.com/products/excel/help/net/developer-guide/using-text-xlsx-net-csharp-vb.php
/// </remarks>
static void AllTypesOfText()
{
string outFile = @"..\..\..\Result.xlsx";
// The file format is detected automatically from the file extension: ".xlsx".
ExcelDocument excel = new ExcelDocument();
// Add an empty worksheet to the file.
excel.Worksheets.Add("Page 1");
var worksheet = excel.Worksheets["Page 1"];
// This is a regular string.
worksheet.Cells["A1"].Value = "Hello, World!";
// This is a string with a calculation in C#.
worksheet.Cells["A2"].Value = $"2+2*2 equals {2 + 2 * 2}";
worksheet.Cells["B2"].Value = 2+2*2;
// This is a string created using StringBuilder.
var stringBuilder = new StringBuilder("Hello");
stringBuilder.Append(" World");
stringBuilder.Insert(5, ",");
worksheet.Cells["A3"].Value = stringBuilder;
// This is a RichText string with varied formatting.
var wholeString = new RichText();
var part1 = new RichTextString("Hello", new RichTextFormat() { Italic = true, FontColor = SKColors.Blue });
var part2 = new RichTextString(", ", new RichTextFormat() { FontColor = SKColors.Red });
var part3 = new RichTextString("World!", new RichTextFormat() { Bold = true, FontSize = 18, FontColor = SKColors.Green });
wholeString.Add(part1); wholeString.Add(part2); wholeString.Add(part3);
worksheet.Cells["A4"].Value = wholeString;
// Expand the column to make it look attractive
worksheet.Columns["A"].AutoFit();
// 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 System.Text
Imports SautinSoft.Excel
Imports SkiaSharp
Namespace Example
Friend Class Program
Shared Sub Main(ByVal args() As String)
' Get your free key here:
' https://sautinsoft.com/start-for-free/
AllTypesOfText()
End Sub
''' <summary>
''' Using various methods of inserting text into cells.
''' </summary>
''' <remarks>
''' Details: https://www.sautinsoft.com/products/excel/help/net/developer-guide/using-text-xlsx-net-csharp-vb.php
''' </remarks>
Private Shared Sub AllTypesOfText()
Dim outFile As String = "..\..\..\Result.xlsx"
' The file format is detected automatically from the file extension: ".xlsx".
Dim excel As New ExcelDocument()
' Add an empty worksheet to the file.
excel.Worksheets.Add("Page 1")
Dim worksheet = excel.Worksheets("Page 1")
' This is a regular string.
worksheet.Cells("A1").Value = "Hello, World!"
' This is a string with a calculation in C#.
worksheet.Cells("A2").Value = $"2+2*2 equals {2 + 2 * 2}"
worksheet.Cells("B2").Value = 2+2*2
' This is a string created using StringBuilder.
Dim stringBuilder As New StringBuilder("Hello")
stringBuilder.Append(" World")
stringBuilder.Insert(5, ",")
worksheet.Cells("A3").Value = stringBuilder
' This is a RichText string with varied formatting.
Dim wholeString = New RichText()
Dim part1 = New RichTextString("Hello", New RichTextFormat() With {
.Italic = True,
.FontColor = SKColors.Blue
})
Dim part2 = New RichTextString(", ", New RichTextFormat() With {.FontColor = SKColors.Red})
Dim part3 = New RichTextString("World!", New RichTextFormat() With {
.Bold = True,
.FontSize = 18,
.FontColor = SKColors.Green
})
wholeString.Add(part1)
wholeString.Add(part2)
wholeString.Add(part3)
worksheet.Cells("A4").Value = wholeString
' Expand the column to make it look attractive
worksheet.Columns("A").AutoFit()
' 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
Если вам нужен пример кода или у вас есть вопрос: напишите нам по адресу support@sautinsoft.ru или спросите в онлайн-чате (правый нижний угол этой страницы) или используйте форму ниже: