Comment exporter un fichier vers CSV en C#

1.1 What is .NET Framework?

Microsoft created the proprietary .NET Framework, a software framework that is mostly compatible with Microsoft Windows. It served as the main Common Language Infrastructure (CLI) implementation until the cross-platform .NET project took its place. It offers language compatibility across several different programming languages and comes with a sizable class library called the Framework Class Library (FCL).

1.2 What is CSV?

A text file format called "comma-separated values" divides values into separate columns using commas. Tabular data is stored in plain text in a CSV format file, where each line typically corresponds to a single data record. In the CSV file, each record has the same number of fields, which are separated by commas.

2.0 IronXL Library Features

Microsoft Excel documents can be read and converted to CSV files using the IronXL for .NET C# Excel library. Without installing Microsoft Office or Microsoft.Office.Interop.Excel, users can utilize IronXL, a stand-alone .NET software library. It is capable of reading several spreadsheet formats.

IronXL's simple C# API makes it easy to read, edit, and produce Excel spreadsheets in a .NET context. IronXL provides complete support for Xamarin, Linux, macOS, Azure, .NET Core, and .NET Framework.

• IronXL, a C# library compatible with both .NET Core and .NET Framework, is among the best for Excel spreadsheets.
• IronXL supports almost every .NET Framework, including Web apps, Windows Forms, and Console.
• IronXL can be used with Linux, macOS, and Windows operating systems.
• IronXL has quick and easy access to Excel files.
• IronXL is capable of reading a wide range of Excel file types, including XLSX, CSV, XLS, XLST, TSV, XLSM, and more. The functions for importing, updating, and exporting data tables and datasets are only a few of the library's numerous options.
• For the Excel spreadsheet, IronXL is capable of producing calculations.
• IronXL supports numerous data types for Excel columns, including text, integers, dates, currencies, formulae, and percentages.
• IronXL can handle multiple values in the form of dates, currencies, percentages, text, numbers, formulas, and more Excel column data types.

To know how to export data into Excel refer to this tutorial.

3.0 Creating a New Project in Visual Studio

Open Visual Studio and create a .NET project before using the IronXL library. Visual Studio can be used in any version, though the most recent version is recommended. To keep things simple, this article will be using the Console Application for this example.

Open Visual Studio, go to "File" menu and select "New Project". From the various .NET project templates choose the "Console App".

Enter the project's location and name after that.

Create a new project in Visual Studio

The Framework drop-down menu can be used to choose a .NET Framework. .NET Framework 4.7 is selected for this project. Next, click on the Create button.

The program.cs file will open when the application generates the solution, allowing you to enter the code and build/run the program.

The Program.cs file will open once the Console Application project is successfully created.

To test the code, the next step is to add the IronXL library.

Install the IronXL library, since it is required for the next fix. To do this, enter the following command into the NuGet Package Manager Console:

Install-Package IronXL -Version 2023.8.29

Install the IronXL package in the NuGet Package Manager Console

Another option is to use the NuGet Package Manager to look for the package "IronXL", then choose the necessary package to download from this list of all the NuGet packages connected to IronXL.

Install the IronXL package using the NuGet Package Manager

4.0 Export to CSV file

using IronXL;
using IronXL.Options;
using System;

class Program
{
    static void Main(string[] args)
    {
        // Array of student names
        string[] students = { "AAA", "BBB", "CCC", "DDD", "EEE", "FFF" };

        // Create a new workbook with an Excel file format of XLS
        var workBook = WorkBook.Create(ExcelFileFormat.XLS);

        // Get the default worksheet (where student data will be written)
        var workSheet = workBook.DefaultWorkSheet;

        // Start adding data to worksheet from row 1
        int rowCount = 1;
        foreach (var student in students)
        {
            // Set the value in column A for student ID
            workSheet["A" + rowCount].Value = rowCount.ToString();

            // Set the value in column B for student name
            workSheet["B" + rowCount].Value = student.ToString();
            rowCount++;
        }

        // Save the workbook as a CSV file with a specified delimiter
        workBook.SaveAsCsv("Sample.csv", ";");

        // Alternately, convert the workbook to a stream
        var stream = workBook.ToStream();
    }
}

using IronXL;
using IronXL.Options;
using System;

class Program
{
    static void Main(string[] args)
    {
        // Array of student names
        string[] students = { "AAA", "BBB", "CCC", "DDD", "EEE", "FFF" };

        // Create a new workbook with an Excel file format of XLS
        var workBook = WorkBook.Create(ExcelFileFormat.XLS);

        // Get the default worksheet (where student data will be written)
        var workSheet = workBook.DefaultWorkSheet;

        // Start adding data to worksheet from row 1
        int rowCount = 1;
        foreach (var student in students)
        {
            // Set the value in column A for student ID
            workSheet["A" + rowCount].Value = rowCount.ToString();

            // Set the value in column B for student name
            workSheet["B" + rowCount].Value = student.ToString();
            rowCount++;
        }

        // Save the workbook as a CSV file with a specified delimiter
        workBook.SaveAsCsv("Sample.csv", ";");

        // Alternately, convert the workbook to a stream
        var stream = workBook.ToStream();
    }
}

Imports IronXL
Imports IronXL.Options
Imports System

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Array of student names
		Dim students() As String = { "AAA", "BBB", "CCC", "DDD", "EEE", "FFF" }

		' Create a new workbook with an Excel file format of XLS
		Dim workBook = WorkBook.Create(ExcelFileFormat.XLS)

		' Get the default worksheet (where student data will be written)
		Dim workSheet = workBook.DefaultWorkSheet

		' Start adding data to worksheet from row 1
		Dim rowCount As Integer = 1
		For Each student In students
			' Set the value in column A for student ID
			workSheet("A" & rowCount).Value = rowCount.ToString()

			' Set the value in column B for student name
			workSheet("B" & rowCount).Value = student.ToString()
			rowCount += 1
		Next student

		' Save the workbook as a CSV file with a specified delimiter
		workBook.SaveAsCsv("Sample.csv", ";")

		' Alternately, convert the workbook to a stream
		Dim stream = workBook.ToStream()
	End Sub
End Class

5.0 Conclusion

One of the most popular Excel add-ons is IronXL. It doesn't rely on any other outside libraries. It is self-contained and does not require the installation of Microsoft Excel. It operates via several channels.

IronXL provides a complete solution for all programmatically executed Microsoft Excel document-related tasks. It is possible to perform calculations, sort strings or numbers, trim, add, locate and replace, merge and unmerge, save files, and more. You can define cell data types in addition to checking spreadsheet data. It lets you read and write files and makes dealing with Excel data easier.

IronXL offers a free trial license, which gives users a chance to try all its key features for free.

IronXL is available for $799 at launch. If users would like updates and help with the software, they can also choose to pay a one-year subscription charge. For an additional fee, IronXL offers protection for unlimited redistribution. To find more accurate pricing information, please visit IronXL's license page.