UTILISATION D'IRONXL

Travailler avec Excel dans .NET Core

Mis à jour:juillet 28, 2025

.NET Core Excel Overview

In this modern era, we need a better way to work with Excel Spreadsheets in our .NET Core applications. In the following tutorial, we will learn how to access spreadsheets in .NET Core Excel projects and modify their values using C#.

.NET Core Excel Editing

Download the IronXL Library
Assign values to a cell range
Edit cells using user inputs
Edit multiple cells using a static value

Step 1

1. Download IronXL Library

For an easy way to work with Excel files in .NET Core, try IronXL. Download IronXL DLL or install with NuGet for free use in development projects.

# Install IronXL using the .NET CLI
dotnet add package IronXL.Excel

# Install IronXL using the .NET CLI
dotnet add package IronXL.Excel

SHELL

How to Tutorial

2. .NET Core Excel Editing Project

Now that you've downloaded IronXL, let's get started. Load an Excel file in the project and access the WorkSheet where data needs to be edited and changes made.

3. Edit Specific Cell Value

For editing Excel files, add the reference IronXL to your project and import the library by using IronXL.

3.1. Load a Sample File

In the following case, our Excel file name is sample.xlsx and it exists in the bin> Debug> netcoreapp3.1 folder of the project. We will use this code to edit the value new value in cell A1 of sample.xlsx.

// Anchor: Load a sample file
using IronXL;

static void Main(string[] args)
{
    // Load the Excel workbook
    WorkBook wb = WorkBook.Load("sample.xlsx");

    // Get the first worksheet named "Sheet1"
    WorkSheet ws = wb.GetWorkSheet("Sheet1");

    // Access cell A1 and set its value to "new value"
    ws["A1"].Value = "new value";

    // Save the changes to the Excel workbook
    wb.SaveAs("sample.xlsx");
}

// Anchor: Load a sample file
using IronXL;

static void Main(string[] args)
{
    // Load the Excel workbook
    WorkBook wb = WorkBook.Load("sample.xlsx");

    // Get the first worksheet named "Sheet1"
    WorkSheet ws = wb.GetWorkSheet("Sheet1");

    // Access cell A1 and set its value to "new value"
    ws["A1"].Value = "new value";

    // Save the changes to the Excel workbook
    wb.SaveAs("sample.xlsx");
}

' Anchor: Load a sample file
Imports IronXL

Shared Sub Main(ByVal args() As String)
	' Load the Excel workbook
	Dim wb As WorkBook = WorkBook.Load("sample.xlsx")

	' Get the first worksheet named "Sheet1"
	Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

	' Access cell A1 and set its value to "new value"
	ws("A1").Value = "new value"

	' Save the changes to the Excel workbook
	wb.SaveAs("sample.xlsx")
End Sub

$vbLabelText $csharpLabel

4. Assign Value to Multiple Cells

It is very easy to edit multiple cells and assign static values at a time by using a colon :. Its left side indicates the starting cell and the right side indicates the last cell of a specific column.

sheet[From:To]

This will edit new value from cell A1 to A9 of column A.

// Anchor: Assign Value to Multiple Cells
using IronXL;

static void Main(string[] args)
{
    WorkBook wb = WorkBook.Load("sample.xlsx");
    WorkSheet ws = wb.GetWorkSheet("Sheet1");

    // Set the value "new value" for cells from A1 to A9
    ws["A1:A9"].Value = "new value";

    wb.SaveAs("sample.xlsx");
}

// Anchor: Assign Value to Multiple Cells
using IronXL;

static void Main(string[] args)
{
    WorkBook wb = WorkBook.Load("sample.xlsx");
    WorkSheet ws = wb.GetWorkSheet("Sheet1");

    // Set the value "new value" for cells from A1 to A9
    ws["A1:A9"].Value = "new value";

    wb.SaveAs("sample.xlsx");
}

' Anchor: Assign Value to Multiple Cells
Imports IronXL

Shared Sub Main(ByVal args() As String)
	Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
	Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

	' Set the value "new value" for cells from A1 to A9
	ws("A1:A9").Value = "new value"

	wb.SaveAs("sample.xlsx")
End Sub

$vbLabelText $csharpLabel

5. Edit Cells with User Inputs

Here is an alternative case where we can take the values from the users and edit the Excel file.

// Anchor: Edit Cells with User Inputs
using System;
using IronXL;

static void Main(string[] args)
{
    string _from, _to, newValue;

    // Capture user inputs
    Console.Write("Enter Starting Cell: ");
    _from = Console.ReadLine();

    Console.Write("Enter Last Cell: ");
    _to = Console.ReadLine();

    Console.Write("Enter value: ");
    newValue = Console.ReadLine();

    // Load the Excel workbook and access the worksheet
    WorkBook wb = WorkBook.Load("sample.xlsx");
    WorkSheet ws = wb.GetWorkSheet("Sheet1");

    // Assign the user-entered value to the specified cell range
    ws[_from + ":" + _to].Value = newValue;

    // Save changes to the workbook
    wb.SaveAs("sample.xlsx");

    Console.WriteLine("Successfully Changed...!");
    Console.ReadKey();
}

// Anchor: Edit Cells with User Inputs
using System;
using IronXL;

static void Main(string[] args)
{
    string _from, _to, newValue;

    // Capture user inputs
    Console.Write("Enter Starting Cell: ");
    _from = Console.ReadLine();

    Console.Write("Enter Last Cell: ");
    _to = Console.ReadLine();

    Console.Write("Enter value: ");
    newValue = Console.ReadLine();

    // Load the Excel workbook and access the worksheet
    WorkBook wb = WorkBook.Load("sample.xlsx");
    WorkSheet ws = wb.GetWorkSheet("Sheet1");

    // Assign the user-entered value to the specified cell range
    ws[_from + ":" + _to].Value = newValue;

    // Save changes to the workbook
    wb.SaveAs("sample.xlsx");

    Console.WriteLine("Successfully Changed...!");
    Console.ReadKey();
}

' Anchor: Edit Cells with User Inputs
Imports System
Imports IronXL

Shared Sub Main(ByVal args() As String)
	Dim _from, _to, newValue As String

	' Capture user inputs
	Console.Write("Enter Starting Cell: ")
	_from = Console.ReadLine()

	Console.Write("Enter Last Cell: ")
	_to = Console.ReadLine()

	Console.Write("Enter value: ")
	newValue = Console.ReadLine()

	' Load the Excel workbook and access the worksheet
	Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
	Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

	' Assign the user-entered value to the specified cell range
	ws(_from & ":" & _to).Value = newValue

	' Save changes to the workbook
	wb.SaveAs("sample.xlsx")

	Console.WriteLine("Successfully Changed...!")
	Console.ReadKey()
End Sub

$vbLabelText $csharpLabel

The above code will display a console for user inputs and then update the specified Excel cells with the entered value.

Work with Excel in .NET Core, Figure 1: Console Application UI with user input Console Application UI with user input

Values changed from B4 to B9 in ExcelSheet, as can be seen:

Work with Excel in .NET Core, Figure 2: The new value is filled from B4 to B9 The new value is filled from B4 to B9

6. Edit Multiple Cells with Static Value

It is very easy to edit multiple cells and assign dynamic values. Let's see the following example:

// Anchor: Edit Multiple Cells with Static Value
using IronXL;

static void Main(string[] args)
{
    WorkBook wb = WorkBook.Load("sample.xlsx");
    WorkSheet ws = wb.GetWorkSheet("Sheet1");

    // Ensure 'from' and 'to' are defined for the intended cell range
    int from = 1;
    int to = 9;

    // Iterate over a range of cells and update them with dynamic values
    for (int i = from; i <= to; i++)
    {
        ws["A" + i].Value = "Value" + i;
    }

    // Save the changes to the Excel file
    wb.SaveAs("sample.xlsx");
}

// Anchor: Edit Multiple Cells with Static Value
using IronXL;

static void Main(string[] args)
{
    WorkBook wb = WorkBook.Load("sample.xlsx");
    WorkSheet ws = wb.GetWorkSheet("Sheet1");

    // Ensure 'from' and 'to' are defined for the intended cell range
    int from = 1;
    int to = 9;

    // Iterate over a range of cells and update them with dynamic values
    for (int i = from; i <= to; i++)
    {
        ws["A" + i].Value = "Value" + i;
    }

    // Save the changes to the Excel file
    wb.SaveAs("sample.xlsx");
}

' Anchor: Edit Multiple Cells with Static Value
Imports IronXL

Shared Sub Main(ByVal args() As String)
	Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
	Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

	' Ensure 'from' and 'to' are defined for the intended cell range
	Dim from As Integer = 1
	Dim [to] As Integer = 9

	' Iterate over a range of cells and update them with dynamic values
	For i As Integer = From To [to]
		ws("A" & i).Value = "Value" & i
	Next i

	' Save the changes to the Excel file
	wb.SaveAs("sample.xlsx")
End Sub

$vbLabelText $csharpLabel

7. Read Excel Files In-Depth Tutorial

Dive in with further details and multiple projects and code examples if you want to learn more about how to Read Excel Files C# with this tutorial.

Tutorial Quick Access

Investigate the API Reference

Documentation is provided for IronXL, featuring all namespaces, feature sets, methods fields, classes, and enums.

API Reference

Questions Fréquemment Posées

Quel est l'objectif d'utiliser Excel dans les applications .NET Core ?

Excel est utilisé dans les applications .NET Core pour une gestion et une manipulation efficaces des données. IronXL permet aux développeurs de charger, éditer et enregistrer des fichiers Excel de manière programmatique en utilisant C#, améliorant ainsi la productivité et les capacités de gestion des données.

Comment puis-je installer la bibliothèque Excel dans un projet .NET Core ?

Vous pouvez installer la bibliothèque IronXL dans un projet .NET Core en utilisant le gestionnaire de packages NuGet avec la commande : dotnet add package IronXL.Excel. Alternativement, vous pouvez télécharger le fichier DLL directement depuis le site IronXL.

Quelles sont les étapes pour charger un fichier Excel dans .NET Core ?

Pour charger un fichier Excel dans .NET Core en utilisant IronXL, utilisez la méthode WorkBook.Load. Par exemple, WorkBook wb = WorkBook.Load("sample.xlsx"); chargera le classeur Excel nommé 'sample.xlsx'.

Puis-je éditer une plage de cellules dans une feuille Excel en utilisant .NET Core ?

Oui, avec IronXL, vous pouvez éditer une plage de cellules dans une feuille Excel simultanément. Utilisez la syntaxe ws["A1:A9"].Value = "nouvelle valeur"; pour attribuer une valeur à plusieurs cellules, où ws est un objet WorkSheet.

Comment gérer les entrées de l'utilisateur lors de l'édition de fichiers Excel dans .NET Core ?

IronXL permet de gérer les entrées utilisateur en les capturant via la console ou une interface utilisateur, qui peuvent ensuite être utilisées pour définir la plage de cellules et la valeur pour les mises à jour dans le tableur Excel.

Quel langage de programmation est utilisé pour la manipulation d'Excel dans .NET Core ?

C# est utilisé pour manipuler des fichiers Excel de manière programmatique dans les applications .NET Core en utilisant la bibliothèque IronXL.

Existe-t-il un tutoriel pour travailler avec des fichiers Excel dans .NET Core ?

Oui, des tutoriels exhaustifs sur la lecture et la manipulation de fichiers Excel en utilisant C# avec IronXL sont disponibles. Des ressources supplémentaires et des projets d'exemples peuvent être trouvés sur le site Web d'IronXL.

Quelles sont les exigences de compatibilité pour l'utilisation de la bibliothèque Excel dans .NET Core ?

IronXL prend en charge diverses versions de .NET Core. Des informations détaillées sur la compatibilité peuvent être trouvées dans la documentation d'IronXL sur leur site Web.

Où puis-je accéder à la documentation API pour la bibliothèque Excel ?

La documentation API pour IronXL est disponible en ligne, fournissant des détails sur tous les espaces de noms, méthodes et fonctionnalités. Visitez le site Web d'IronXL pour accéder à cette ressource.

Jordi Bardia

Discutez maintenant avec l'équipe d'ingénierie

Ingénieur logiciel

Jordi est le plus compétent en Python, C# et C++, et lorsqu'il ne met pas à profit ses compétences chez Iron Software, il programme des jeux. Partageant les responsabilités des tests de produit, du développement de produit et de la recherche, Jordi apporte une immense valeur à l'amé...