Originally Posted On: Csharp Write to CSV File | IronXL (ironsoftware.com)
Ever wondered how to quickly use C# to write to CSV? Wonder no more! IronXL provides a very quick and easy way to write data into CSV files in .NET.
Code ExamplesSave as CSV FileVB
C#
- private void button3_Click(object sender, EventArgs e)
- {
- WorkBook wb = WorkBook.Load("Normal_Excel_File.xlsx"); //Import .xls, .csv, or .tsv file
- wb.SaveAs("Excel_To_CSV.csv"); //Exported as : Excel_To_CSV.Sheet1.csv
- }
Step 11. Add IronXL to Your Project
Just in case you haven’t installed IronXL yet, here’s 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 into the Developer Command Prompt:
PM> Install-Package IronPdf
Or you can download directly from the Iron Software website, here: https://ironsoftware.com/csharp/excel/docs/
How to Tutorial2. 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# and IronXL
- using IronXL;
Copy code to clipboardVB
C#
2. Save Workbook to CSV
The following code makes use of the Workbook object’s Load method to load a file into Excel.
Then, it uses the SaveAs method to save the file in the desired format – in this case: CSV.
What’s interesting here is that it appends the name of the worksheet onto the filename, which is a quite nifty reminder on where the data is coming from.
- private void button3_Click(object sender, EventArgs e)
- {
- WorkBook wb = WorkBook.Load("Normal_Excel_File.xlsx"); //Import .xls, .csv, or .tsv file
- wb.SaveAs("Excel_To_CSV.csv"); //Exported as : Excel_To_CSV.Sheet1.csv
- }
Copy code to clipboardVB
C#
The output CSV file looks like the following when opened in a normal Text Editor such as Notepad.
Figure 2 – Output CSV file