using IronXL; using System; using System.Linq; // Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV WorkBook workBook = WorkBook.Load("sample.xlsx"); // Select worksheet at index 0 WorkSheet workSheet = workBook.WorkSheets[0]; // Get any existing worksheet WorkSheet firstSheet = workBook.DefaultWorkSheet; // Select a cell and return the converted value int cellValue = workSheet["A2"].IntValue; // Read from ranges of cells elegantly. foreach (var cell in workSheet["A2:A10"]) { Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text); } // Calculate aggregate values such as Min, Max and Sum decimal sum = workSheet["A2:A10"].Sum(); // Linq compatible decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);

USING IRONXL

Create a CSV file using C#

Updated December 21, 2023

Create and output a CSV file easily with IronXL's free for development. The following code shows you how.

How to Create a CSV file using C#

Add IronXL Package
Load existing WorkBook and save as CSV File

Step 1

1. Add IronXL Package

First, you must have IronXL installed. There are various options. You can download it directly: https://ironsoftware.com/csharp/excel/docs/

Or you can import the IronXL NuGet package by following the next few steps

Right-click on the Solution in the Solution Explorer
Click Manage NuGet Packages
Browse for IronXL.Excel
Click Install

Install-Package IronXL.Excel

Create a CSV file using C#, Figure 1: IronXL.Excel NuGet Package IronXL.Excel NuGet Package

How to Tutorial

2. Save Workbook as CSV

Easy as that!

Here is the code for this little project. This code loads an existing Excel Workbook, and then simply saves it in the CSV format by using the SaveAsCsv method.

The Normal Excel workbook contains the following data:

Create a CSV file using C#, Figure 2: Excel data to be converted to CSV

/**
Save as CSV file
anchor-save-workbook-as-csv
**/
using IronXL;
WorkBook wb = WorkBook.Load("Normal_Excel_File.xlsx"); //Import .xls, .csv, or .tsv file
wb.SaveAsCsv("SaveAsCSV.csv", ","); //Saved as : SaveAsCSV.Sheet1.csv

/**
Save as CSV file
anchor-save-workbook-as-csv
**/
using IronXL;
WorkBook wb = WorkBook.Load("Normal_Excel_File.xlsx"); //Import .xls, .csv, or .tsv file
wb.SaveAsCsv("SaveAsCSV.csv", ","); //Saved as : SaveAsCSV.Sheet1.csv

'''
'''Save as CSV file
'''anchor-save-workbook-as-csv
'''*
Imports IronXL
Private wb As WorkBook = WorkBook.Load("Normal_Excel_File.xlsx") 'Import .xls, .csv, or .tsv file
wb.SaveAsCsv("SaveAsCSV.csv", ",") 'Saved as : SaveAsCSV.Sheet1.csv

VB C#

Additionally, the IronXL Excel library provides the following features:

A broad set of functions, including data manipulation, data export, data import and importing from other sources.
Support chart management that is fully compatible with Excel.
Support for Excel's most popular file formats (.xlsx) and other file formats.
Support for cell formatting such as text alignment, font size, color, etc.
Ability to control the way that cells are displayed in an Excel workbook (e.g. gridlines).