Comment fusionner les cellules Excel sans perdre de données

Excel's Options to Combine Multiple Cells

Select the choice you want from the drop-down menu by clicking the tiny drop-down arrow next to the Merge & Center button, which will give you access to a few more merging options supplied by Excel, such as Merge Across, Unmerge Cells.

Combine Cells

Using the Merge Across command, each row's individually chosen cells are combined.

Using the Merge Cells command, you can combine the selected cells into one without centering the text or losing data.

Simply pick the merged cell and click the desired alignment in the Alignment group on the Home page to change the text alignment of only the data after merging all the cells.

There are a few things to remember when using Excel's built-in functions to combine adjacent cells:

• Only the content of the upper-left cell will remain after merging, as all data in the other cells will be removed. Therefore, make sure that all the data you want to include in a merged cell is entered in the leftmost cell of the chosen range.
• The selected cells are likely in Edit mode if the Merge and Center button is grayed out. Try merging cells after exiting Edit mode by pressing the Enter key.

Creating a New Project in Visual Studio

Open Visual Studio, select "New project" and choose "Console App" from the File menu. A C# Console Application is used for simplicity.

New Project

In the relevant text box, type the project name and file path. Next, select the necessary .NET Framework by clicking the Create button. The project will now create the program.cs file's structure and open, allowing you to enter the program's code and build or run it.

Project Configuration

The solution's necessary IronXL library must then be downloaded. By entering the following command in the package manager, you can download the package:

Install-Package IronXL.Excel

IronXL

The "IronXL" package can also be found and downloaded using the NuGet Package Manager. Dependency management in your project is made simple with the NuGet Package Manager.

NuGet Package Manager

Merge Cells Using IronXL

IronXL can merge multiple columns/cells in existing Excel sheets. Below is the sample code to merge multiple cells.

using IronXL;

class Program
{
    static void Main()
    {
        // Load the existing Excel workbook
        var excelDoc = WorkBook.Load("demo.xlsx");

        // Get the default worksheet
        WorkSheet workSheet = excelDoc.DefaultWorkSheet;

        // Define the range of cells to merge
        var range = workSheet["A1:C1"];

        // Merge the specified range of cells
        workSheet.Merge(range.RangeAddressAsString);

        // Save the changes made to the workbook
        excelDoc.Save();
    }
}

using IronXL;

class Program
{
    static void Main()
    {
        // Load the existing Excel workbook
        var excelDoc = WorkBook.Load("demo.xlsx");

        // Get the default worksheet
        WorkSheet workSheet = excelDoc.DefaultWorkSheet;

        // Define the range of cells to merge
        var range = workSheet["A1:C1"];

        // Merge the specified range of cells
        workSheet.Merge(range.RangeAddressAsString);

        // Save the changes made to the workbook
        excelDoc.Save();
    }
}

Imports IronXL

Friend Class Program
	Shared Sub Main()
		' Load the existing Excel workbook
		Dim excelDoc = WorkBook.Load("demo.xlsx")

		' Get the default worksheet
		Dim workSheet As WorkSheet = excelDoc.DefaultWorkSheet

		' Define the range of cells to merge
		Dim range = workSheet("A1:C1")

		' Merge the specified range of cells
		workSheet.Merge(range.RangeAddressAsString)

		' Save the changes made to the workbook
		excelDoc.Save()
	End Sub
End Class

In the example code above:

1. The existing Excel workbook is loaded into the IronXL workbook object.
2. The default worksheet is selected.
3. The range of cells (A1:C1) that you want to merge is specified.
4. The Merge method is then called to combine the specified range of cells.
5. Finally, the Save method is called to save the changes to the workbook.

This Merge function merges a group of cells, retaining only the value of the first cell in the range without removing the values from other cells. However, the values from those merged cells are still accessible in IronXL.