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 IronSoftware.Drawing; using IronXL; using IronXL.Styles; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); var range = workSheet["A1:H10"]; var cell = range.First(); // Set background color of the cell with an rgb string cell.Style.SetBackgroundColor("#428D65"); // Apply styling to the whole range. // Set underline property to the font // FontUnderlineType is enum that stands for different types of font underlying range.Style.Font.Underline = FontUnderlineType.SingleAccounting; // Define whether to use horizontal line through the text or not range.Style.Font.Strikeout = false; // Define whether the font is bold or not range.Style.Font.Bold = true; // Define whether the font is italic or not range.Style.Font.Italic = false; // Get or set script property of a font // Font script enum stands for available options range.Style.Font.FontScript = FontScript.Super; // Set the type of the border line // There are also TopBorder,LeftBorder,RightBorder,DiagonalBorder properties // BorderType enum indicates the line style of a border in a cell range.Style.BottomBorder.Type = BorderType.MediumDashed; // Indicate whether the cell should be auto-sized range.Style.ShrinkToFit = true; // Set alignment of the cell range.Style.VerticalAlignment = VerticalAlignment.Bottom; // Set border color range.Style.DiagonalBorder.SetColor("#20C96F"); // Define border type and border direction as well range.Style.DiagonalBorder.Type = BorderType.Thick; // DiagonalBorderDirection enum stands for direction of diagonal border inside cell range.Style.DiagonalBorderDirection = DiagonalBorderDirection.Forward; // Set background color of cells range.Style.SetBackgroundColor(Color.Aquamarine); // Set fill pattern of the cell // FillPattern enum indicates the style of fill pattern range.Style.FillPattern = FillPattern.Diamonds; // Set the number of spaces to intend the text range.Style.Indention = 5; // Indicate if the text is wrapped range.Style.WrapText = true; workBook.SaveAs("stylingOptions.xls");

Published November 15, 2023

How to Save A CSV File in C#

Saving data to a Comma-Separated Values (CSV) file is a common and fundamental operation in many software applications, and C# provides a robust and versatile environment for accomplishing this task.

Whether you're working with structured data, user-generated content, or application-generated records, C# offers a variety of libraries and methods to efficiently save information to CSV files and also to write CSV files using class program.

This introductory paragraph will explore the essential concepts and approaches in C# for saving data to CSV, highlighting the importance of this process in data management and interchange.

Whether you're dealing with business data, scientific research, or any other domain, mastering the art of saving data to CSV in C# is an indispensable skill for software developers and data analysts alike. In this article we will use IronXL's market leading data manipulating library to save spreadsheets as a CSV File and how it can be used also in writing data to CSV files.

How to Save a CSV File

Install the C# library for Saving Spreadsheets into CSV File.
Utilize the using IronXL method to import the IronXL.
Load an existing spreadsheet using WorkBook.Load method.
Access the worksheet using workBook.WorkSheets.
Save the Spreadsheet as CSV file using SaveAs method.

IronXL

IronXL stands at the forefront of simplifying the process of saving data to CSV files within C# applications, offering developers a versatile and efficient toolkit. Seamlessly integrating into C#

Whether you're working on a data-driven application, a reporting tool, or simply need a reliable solution for exporting data, IronXL proves to be a powerful ally. IronXL comes handy when creating CSV files, saving CSV files, and writing CSV files using C#.

In this article, we explore the capabilities and features that make IronXL an indispensable asset for C# developers looking to streamline the task of saving data to CSV files, ensuring simplicity without compromising on flexibility or precision.

Create a New Visual Studio Project

Before you can install IronXL, you'll need to either create a new Visual Studio C# project or load an existing one. Here's a step-by-step guide on creating a new project in Visual Studio.

Open Visual Studio and navigate to the "File" menu. A dropdown menu will appear; choose "New" from this menu, triggering another side menu to appear. In this side menu, select "Project."
A new window will open. In this window, use the search bar to look for "console app" and choose the Console Application with the C# option. Click on the "Next" button.
A configuration window will pop up. Enter the project name, set the project location, and then click "Next."
The final window will appear. In this window, select the target framework and click on the "Create" button.

Installing CSV Library IronXL

Now that you've set up your project, let's get the IronXL C# library installed. Follow these steps to integrate IronXL into your C#

In Visual Studio, navigate to Tools. A dropdown menu will appear. From this menu, select NuGet Package Manager.
In the NuGet Package Manager, access the side menu and choose NuGet Package Manager for Solutions.
A new window will pop up. Go to the browser tab within this window and type "IronXL" in the search bar. You'll see a list of IronXL Packages. Choose the latest package from the list and click on the install button.

Create CSV File by Saving Excel files

IronXL provides a feature for Creating CSV File by Saving Excel Files in CSV format. In this Section we will Save an Excel file as a new CSV file using the C# CSV Library IronXL. The following example code demonstrates the simple tutorial.

Input Excel File

How to Save A CSV File in C#: Figure 7

using IronXL;
WorkBook workBook = WorkBook.Load("test.xlsx");
WorkSheet workSheet = workBook.WorkSheets[0];
workBook.SaveAs("Tesing.csv");

using IronXL;
WorkBook workBook = WorkBook.Load("test.xlsx");
WorkSheet workSheet = workBook.WorkSheets[0];
workBook.SaveAs("Tesing.csv");

Imports IronXL
Private workBook As WorkBook = WorkBook.Load("test.xlsx")
Private workSheet As WorkSheet = workBook.WorkSheets(0)
workBook.SaveAs("Tesing.csv")

VB C#

This above code uses the IronXL library, and create a new CSV file and write data of Excel file in it. Let's break down the code step by step:

1. Importing IronXL

using IronXL;

using IronXL;

Imports IronXL

VB C#

This line imports the necessary classes and functionalities from the IronXL library.

2. Loading an Excel Workbook

WorkBook workBook = WorkBook.Load("test.xlsx");

WorkBook workBook = WorkBook.Load("test.xlsx");

Dim workBook As WorkBook = WorkBook.Load("test.xlsx")

VB C#

This line loads an Excel workbook from the file named "test.xlsx." The WorkBook class is part of the IronXL library and represents an Excel workbook. The variable workBook is now an instance of the WorkBook class that contains the data from the specified Excel file.

3. Accessing a Worksheet

    WorkSheet workSheet = workBook.WorkSheets[0];

    WorkSheet workSheet = workBook.WorkSheets[0];

Dim workSheet As WorkSheet = workBook.WorkSheets(0)

VB C#

This line gets the first worksheet (index 0) from the loaded Excel workbook. The WorkSheet class represents an Excel worksheet, and the variable workSheet now holds a reference to the first worksheet in the workbook.

4. Saving as CSV file

workBook.SaveAs("Testing.csv");

workBook.SaveAs("Testing.csv");

workBook.SaveAs("Testing.csv")

VB C#

This line saves the entire workbook as a CSV (Comma-Separated Values) file named "Testing.csv." The SaveAs method is used to specify the file name and format for saving the workbook. In this case, the format is CSV, its easily converted and saved all the rows of the Excel file into CSV string.

In short, the code loads an Excel workbook from a file, accesses the first worksheet in that workbook, and then saves the entire workbook as a CSV file named "Testing.csv" using the IronXL library.

Output

How to Save A CSV File in C#: Figure 8

Conclusion

This guide provides an overview of the process of saving data to a CSV file using C# with the assistance of the IronXL library. The ability to write data to CSV is a crucial operation in various applications, and IronXL simplifies this task by seamlessly integrating into C#

The step-by-step instructions cover the installation of IronXL through NuGet Packages, creating a new Visual Studio project, and using IronXL to load an Excel workbook, access a worksheet, and save the entire workbook as a CSV file. The provided code snippet demonstrates a practical example of how to achieve this task efficiently.

The ability to write CSV files, or create a new CSV file using C# is extremely useful for developers and by leveraging IronXL, C#

IronXL proves to be a valuable asset, combining simplicity with flexibility and precision, making it an indispensable tool for C# developers working on data-driven applications, reporting tools, or any project that involves exporting data to CSV files.

The ability to write CSV files, or create a new CSV file using C# is extremely useful for developers and

The tutorial and code examples of how to create CSV files are available in this link. The Source Code of Saving CSV file can be found here.

To try IronXL for yourself, opt in for the free trial offered by IronXL. This gives developers the chance to explore everything that IronXL has to offer. If you find IronXL helpful in your projects or feel that it could be beneficial for any upcoming projects, you can purchase a license, with prices starting at just $599 for the Lite version.