C# CSV 解析器（逐步教程）

2.1. Using the Visual Studio NuGet Package Manager

The NuGet Package Manager UI is available in Visual Studio to install the package directly into the project. The below screenshot shows how to open it.

Installing IronXL using Visual Studio NuGet Package Manager GUI

The Package Manager UI provides a Browse feature that displays a list of the package libraries that are offered on the NuGet website. Enter the "IronXL" keyword, as in the below screenshot, to find the IronXL package.

Locate the IronXL library in NuGet Package Manager by searching for it in the Browse section

Select the IronXL.Excel package and click the Install button to add it to the project.

2.2. Using the Visual Studio Command-Line

In the Visual Studio menu, go to Tools > NuGet Package Manager > click on Package Manager Console.

Access the NuGet Package Manager Console within Visual Studio from the Tools menu

The Package Manager Console will appear at the bottom of the screen. Just type the following command then press enter, and IronXL will be installed.

Install-Package IronXL.Excel

Install the IronXL library through Command-Line

3.1. Parse a CSV File from an XLSX File

Open Microsoft Excel and create a new XLSX file. Populate its rows and columns with some mock data. The below image shows the file used for all conversions in this tutorial.

Sample Excel data

Once you have your file ready, write the following example code and execute the program.

using IronXL;

class Program
{
    static void Main()
    {
        // Load the XLSX file into a WorkBook object
        WorkBook wb = WorkBook.Load("test.xlsx");
        // Save the WorkBook as a CSV file
        wb.SaveAsCsv("Parsed CSV.csv");
    }
}

using IronXL;

class Program
{
    static void Main()
    {
        // Load the XLSX file into a WorkBook object
        WorkBook wb = WorkBook.Load("test.xlsx");
        // Save the WorkBook as a CSV file
        wb.SaveAsCsv("Parsed CSV.csv");
    }
}

Imports IronXL

Friend Class Program
	Shared Sub Main()
		' Load the XLSX file into a WorkBook object
		Dim wb As WorkBook = WorkBook.Load("test.xlsx")
		' Save the WorkBook as a CSV file
		wb.SaveAsCsv("Parsed CSV.csv")
	End Sub
End Class

After the execution is completed a new file named Parsed CSV.csv will be created. Reading CSV files can be done in any editor or reader you like. The below image shows the output of the above command - our generated CSV data. In the output file, double quotation marks represent bold values.

The result of invoking WorkBook.SaveAsCsv method on the sample Excel Workbook

3.2. Parse CSV File from XLS File

In this example, we will see how to convert XLS files into CSV format.

First, let's create an example XLS file that we can convert to CSV format.

A sample XLS file

Next, we will execute the block of code below to convert the sample XLS file into a CSV file.

using IronXL;

class Program
{
    static void Main()
    {
        // Load the XLS file into a WorkBook object
        WorkBook wb = WorkBook.Load("XLS.xls");
        // Save the WorkBook as a CSV file
        wb.SaveAsCsv("Example2.csv");
    }
}

using IronXL;

class Program
{
    static void Main()
    {
        // Load the XLS file into a WorkBook object
        WorkBook wb = WorkBook.Load("XLS.xls");
        // Save the WorkBook as a CSV file
        wb.SaveAsCsv("Example2.csv");
    }
}

Imports IronXL

Friend Class Program
	Shared Sub Main()
		' Load the XLS file into a WorkBook object
		Dim wb As WorkBook = WorkBook.Load("XLS.xls")
		' Save the WorkBook as a CSV file
		wb.SaveAsCsv("Example2.csv")
	End Sub
End Class

After the execution of the above code is finished, you will have a newly generated CSV file.

The result CSV file from saving using the code above

3.3. Parse CSV file From TSV file

Spreadsheet applications frequently employ TSV files, or Tab-Separated Values files, to transfer data across databases. It saves a data table with tabs separating the data columns and each record being on a different line.

IronXL offers a CSV parser to parse CSV files from TSV format for better data management.

Let's get started with the example.

A sample TSV spreadsheet

using IronXL;

class Program
{
    static void Main()
    {
        // Load the TSV file into a WorkBook object
        WorkBook wb = WorkBook.Load("TSV.tsv");
        // Save the WorkBook as a CSV file
        wb.SaveAsCsv("Example3.csv");
    }
}

using IronXL;

class Program
{
    static void Main()
    {
        // Load the TSV file into a WorkBook object
        WorkBook wb = WorkBook.Load("TSV.tsv");
        // Save the WorkBook as a CSV file
        wb.SaveAsCsv("Example3.csv");
    }
}

Imports IronXL

Friend Class Program
	Shared Sub Main()
		' Load the TSV file into a WorkBook object
		Dim wb As WorkBook = WorkBook.Load("TSV.tsv")
		' Save the WorkBook as a CSV file
		wb.SaveAsCsv("Example3.csv")
	End Sub
End Class

Below is the output in CSV format. The output CSV file