How to Write CSV in .NET

1. Add IronXL to Your Project

Just in case you haven’t installed IronXL yet, here are the quick steps you need to take:

• Open Visual Studio and select the Project menu.
• Click Manage NuGet Packages.
• Search for IronXL.Excel.
• Click Install.

Or use the following command in the Developer Command Prompt:

Install-Package IronXL.Excel

If you would like further guidance from any of our tutorials, please follow this link: https://ironsoftware.com/csharp/excel/docs/

You can even download the file project here.

How to Tutorial

2. Create an Excel Workbook

Let’s create a quick project!

First, create an Excel workbook containing the following information:

Figure 1 - Normal Excel data to be exported to CSV

Then add the IronXL Namespace in order to be able to write to CSV files in C# using IronXL:

using IronXL;

using IronXL;

Imports IronXL

3. Save Workbook to CSV

The following C# code demonstrates how to use the WorkBook object's Load method to load an Excel file. It then uses the SaveAs method to save the file as a CSV:

:path=/static-assets/excel/content-code-examples/how-to/csharp-write-to-csv-file-save.cs

using IronXL;

// Load the existing Excel workbook
WorkBook wb = WorkBook.Load("Normal_Excel_File.xlsx"); // Import .xls, .csv, or .tsv file

// Save the workbook as a CSV file with the worksheet name appended
wb.SaveAs("Excel_To_CSV.csv"); // Exported as: Excel_To_CSV.Sheet1.csv

IRON VB CONVERTER ERROR developers@ironsoftware.com

The output CSV file appears as follows when opened in a text editor such as Notepad.

Figure 2 - Output CSV file

Library Quick Access

IronXL API Reference Documentation

Learn more and share how to merge, unmerge, and work with cells in Excel spreadsheets using the handy IronXL API Reference Documentation.

IronXL API Reference Documentation