using IronXL; using System.Linq; //Supported spreadsheet formats for reading include: XLSX, XLS, CSV and TSV WorkBook workbook = WorkBook.Load("test.xlsx"); WorkSheet sheet = workbook.WorkSheets.First(); //Select cells easily in Excel notation and return the calculated value int cellValue = sheet["A2"].IntValue; // Read from Ranges of cells elegantly. foreach (var cell in sheet["A2:A10"]) { Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text); } //Calculate aggregate values such as Min, Max and Sum decimal sum = sheet["A2:A10"].Sum(); //Linq compatible decimal max = sheet["A2:A10"].Max(c => c.DecimalValue);

Imports IronXL Imports System.Linq 'Supported spreadsheet formats for reading include: XLSX, XLS, CSV and TSV Private workbook As WorkBook = WorkBook.Load("test.xlsx") Private sheet As WorkSheet = workbook.WorkSheets.First() 'Select cells easily in Excel notation and return the calculated value Private cellValue As Integer = sheet("A2").IntValue ' Read from Ranges of cells elegantly. For Each cell In sheet("A2:A10") Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text) Next cell 'Calculate aggregate values such as Min, Max and Sum Dim sum As Decimal = sheet("A2:A10").Sum() 'Linq compatible Dim max As Decimal = sheet("A2:A10").Max(Function(c) c.DecimalValue)

using IronXL; using IronXL.Formatting; using IronXL.Formatting.Enums; using IronXL.Styles; WorkBook workbook = WorkBook.Load("test.xlsx"); WorkSheet sheet = workbook.DefaultWorkSheet; //Create a specific conditional formatting rule. ConditionalFormattingRule rule = sheet.ConditionalFormatting.CreateConditionalFormattingRule(ComparisonOperator.LessThan, "8"); //Set different style options. rule.FontFormatting.IsBold = true; rule.FontFormatting.FontColor = "#123456"; rule.BorderFormatting.RightBorderColor = "#ffffff"; rule.BorderFormatting.RightBorderType = BorderType.Thick; rule.PatternFormatting.BackgroundColor = "#54bdd9"; rule.PatternFormatting.FillPattern = FillPattern.Diamonds; //Add formatting with the specified region. sheet.ConditionalFormatting.AddConditionalFormatting("A3:A8", rule); ConditionalFormattingRule rule1 = sheet.ConditionalFormatting.CreateConditionalFormattingRule(ComparisonOperator.Between, "7", "10"); rule1.FontFormatting.IsItalic = true; rule1.FontFormatting.UnderlineType = FontUnderlineType.Single; sheet.ConditionalFormatting.AddConditionalFormatting("A3:A9", rule1); workbook.SaveAs("ApplyConditionalFormatting.xlsx");

Imports IronXL Imports IronXL.Formatting Imports IronXL.Formatting.Enums Imports IronXL.Styles Private workbook As WorkBook = WorkBook.Load("test.xlsx") Private sheet As WorkSheet = workbook.DefaultWorkSheet 'Create a specific conditional formatting rule. Private rule As ConditionalFormattingRule = sheet.ConditionalFormatting.CreateConditionalFormattingRule(ComparisonOperator.LessThan, "8") 'Set different style options. rule.FontFormatting.IsBold = True rule.FontFormatting.FontColor = "#123456" rule.BorderFormatting.RightBorderColor = "#ffffff" rule.BorderFormatting.RightBorderType = BorderType.Thick rule.PatternFormatting.BackgroundColor = "#54bdd9" rule.PatternFormatting.FillPattern = FillPattern.Diamonds 'Add formatting with the specified region. sheet.ConditionalFormatting.AddConditionalFormatting("A3:A8", rule) Dim rule1 As ConditionalFormattingRule = sheet.ConditionalFormatting.CreateConditionalFormattingRule(ComparisonOperator.Between, "7", "10") rule1.FontFormatting.IsItalic = True rule1.FontFormatting.UnderlineType = FontUnderlineType.Single sheet.ConditionalFormatting.AddConditionalFormatting("A3:A9", rule1) workbook.SaveAs("ApplyConditionalFormatting.xlsx")

using IronSoftware.Drawing; using IronXL; using IronXL.Styles; WorkBook workbook = WorkBook.Load("test.xls"); WorkSheet sheet = workbook.WorkSheets.First(); var range = sheet["A1:H10"]; var cell = range.First(); //This is how we set background color of the cell with an rgb string cell.Style.SetBackgroundColor("#428D65"); //Styling can be applied to the whole range. //This is how we set underline property to the font //FontUnderlineType is enum that stands for different types of font underlying range.Style.Font.Underline = FontUnderlineType.SingleAccounting; //This is how we define whether to use horizontal line through the text or not range.Style.Font.Strikeout = false; //This is how we define whether the font is bold or not range.Style.Font.Bold = true; //This is how we define whether the font is italic or not range.Style.Font.Italic = false; //This is how we can get or set script property of a font //Font script enum stands for available options range.Style.Font.FontScript = FontScript.Super; //This is how we can 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; //This is how we can indicate whether the cell should be auto-sized range.Style.ShrinkToFit = true; //This is how we can set alignment of the cell range.Style.VerticalAlignment = VerticalAlignment.Bottom; //This is how we can set border color range.Style.DiagonalBorder.SetColor("#20C96F"); //We need to 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); //This is how we can set fill pattern of the cell //FillPattern enum indicates the style of fill pattern range.Style.FillPattern = FillPattern.Diamonds; //This is how we can set the number of spaces to intend the text range.Style.Indention = 5; //This is how we can indicate if the text is wrapped range.Style.WrapText = true; workbook.SaveAs("StylingOptions.xls");

Imports IronSoftware.Drawing Imports IronXL Imports IronXL.Styles Private workbook As WorkBook = WorkBook.Load("test.xls") Private sheet As WorkSheet = workbook.WorkSheets.First() Private range = sheet("A1:H10") Private cell = range.First() 'This is how we set background color of the cell with an rgb string cell.Style.SetBackgroundColor("#428D65") 'Styling can be applied to the whole range. 'This is how we set underline property to the font 'FontUnderlineType is enum that stands for different types of font underlying range.Style.Font.Underline = FontUnderlineType.SingleAccounting 'This is how we define whether to use horizontal line through the text or not range.Style.Font.Strikeout = False 'This is how we define whether the font is bold or not range.Style.Font.Bold = True 'This is how we define whether the font is italic or not range.Style.Font.Italic = False 'This is how we can get or set script property of a font 'Font script enum stands for available options range.Style.Font.FontScript = FontScript.Super 'This is how we can 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 'This is how we can indicate whether the cell should be auto-sized range.Style.ShrinkToFit = True 'This is how we can set alignment of the cell range.Style.VerticalAlignment = VerticalAlignment.Bottom 'This is how we can set border color range.Style.DiagonalBorder.SetColor("#20C96F") 'We need to 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) 'This is how we can set fill pattern of the cell 'FillPattern enum indicates the style of fill pattern range.Style.FillPattern = FillPattern.Diamonds 'This is how we can set the number of spaces to intend the text range.Style.Indention = 5 'This is how we can indicate if the text is wrapped range.Style.WrapText = True workbook.SaveAs("StylingOptions.xls")

using IronXL; using IronXL.Drawing.Charts; WorkBook workbook = WorkBook.Load("test.xlsx"); WorkSheet sheet = workbook.DefaultWorkSheet; //Set the chart type and it's position on the worksheet. var chart = sheet.CreateChart(ChartType.Scatter, 10, 2, 18, 5); //Add the series to the chart //Both axes of the scatter chart are value axes. //The first parameter is the address of the range for horizontal(value) axis. //The second parameter is the address of the range for vertical(value) axis. var series = chart.AddSeries("B3:B8", "A3:A8"); var rnd = new Random(); foreach (var cell in sheet["C3:C8"]) { //Populate one more column with random values cell.Value = rnd.Next(10); } //For scatter chart there is an option to to add set of data only for vertical axis. chart.AddSeries("C3:C8"); //The set of data in the horizontal axis starts from one in ascending order. //Set the chart title. series.Title = "Scatter Chart"; //Set the legend position. //Can be removed by setting it to None. chart.SetLegendPosition(LegendPosition.Top); //Plot all the data that was added to the chart before. //Multiple call of this method leads to plotting multiple charts instead of modyfying the existing chart. //Yet there is no possibility to remove chart or edit it's series/position. //We can just create new one. chart.Plot(); workbook.SaveAs("CreateScatterChart.xlsx");

Imports IronXL Imports IronXL.Drawing.Charts Private workbook As WorkBook = WorkBook.Load("test.xlsx") Private sheet As WorkSheet = workbook.DefaultWorkSheet 'Set the chart type and it's position on the worksheet. Private chart = sheet.CreateChart(ChartType.Scatter, 10, 2, 18, 5) 'Add the series to the chart 'Both axes of the scatter chart are value axes. 'The first parameter is the address of the range for horizontal(value) axis. 'The second parameter is the address of the range for vertical(value) axis. Private series = chart.AddSeries("B3:B8", "A3:A8") Private rnd = New Random() For Each cell In sheet("C3:C8") 'Populate one more column with random values cell.Value = rnd.Next(10) Next cell 'For scatter chart there is an option to to add set of data only for vertical axis. chart.AddSeries("C3:C8") 'The set of data in the horizontal axis starts from one in ascending order. 'Set the chart title. series.Title = "Scatter Chart" 'Set the legend position. 'Can be removed by setting it to None. chart.SetLegendPosition(LegendPosition.Top) 'Plot all the data that was added to the chart before. 'Multiple call of this method leads to plotting multiple charts instead of modyfying the existing chart. 'Yet there is no possibility to remove chart or edit it's series/position. 'We can just create new one. chart.Plot() workbook.SaveAs("CreateScatterChart.xlsx")

using IronXL; using IronXL.Drawing.Charts; WorkBook workbook = WorkBook.Load("test.xlsx"); WorkSheet sheet = workbook.DefaultWorkSheet; //Set the chart type and it's position on the worksheet. var chart = sheet.CreateChart(ChartType.Line, 10, 10, 18, 20); //Add the series to the chart //The first parameter represents the address of the range for horizontal(category) axis. //The second parameter represents the address of the range for vertical(value) axis. var series = chart.AddSeries("B3:B8", "A3:A8"); //Set the chart title. series.Title = "Line Chart"; //Set the legend position. //Can be removed by setting it to None. chart.SetLegendPosition(LegendPosition.Bottom); //We can change the position of the chart. chart.Position.LeftColumnIndex = 2; chart.Position.RightColumnIndex = chart.Position.LeftColumnIndex + 3; //Plot all the data that was added to the chart before. //Multiple call of this method leads to plotting multiple charts instead of modifying the existing chart. //Yet there is no possibility to remove chart or edit it's series/position. //We can just create new one. chart.Plot(); workbook.SaveAs("CreateLineChart.xlsx");

Imports IronXL Imports IronXL.Drawing.Charts Private workbook As WorkBook = WorkBook.Load("test.xlsx") Private sheet As WorkSheet = workbook.DefaultWorkSheet 'Set the chart type and it's position on the worksheet. Private chart = sheet.CreateChart(ChartType.Line, 10, 10, 18, 20) 'Add the series to the chart 'The first parameter represents the address of the range for horizontal(category) axis. 'The second parameter represents the address of the range for vertical(value) axis. Private series = chart.AddSeries("B3:B8", "A3:A8") 'Set the chart title. series.Title = "Line Chart" 'Set the legend position. 'Can be removed by setting it to None. chart.SetLegendPosition(LegendPosition.Bottom) 'We can change the position of the chart. chart.Position.LeftColumnIndex = 2 chart.Position.RightColumnIndex = chart.Position.LeftColumnIndex + 3 'Plot all the data that was added to the chart before. 'Multiple call of this method leads to plotting multiple charts instead of modifying the existing chart. 'Yet there is no possibility to remove chart or edit it's series/position. 'We can just create new one. chart.Plot() workbook.SaveAs("CreateLineChart.xlsx")

using IronXL; using IronXL.Drawing.Charts; WorkBook workbook = WorkBook.Load("test.xlsx"); WorkSheet sheet = workbook.DefaultWorkSheet; //Set the chart type and its position on the worksheet. var chart = sheet.CreateChart(ChartType.Bar, 10, 2, 18, 5); //Add the series to the chart //For bar chart the first parameter is the address of the range for horizontal(value) axis. //The second parameter is the address of the range for vertical(category) axis. var series = chart.AddSeries("A3:A8", "B3:B8"); //Set the chart title. series.Title = "Bar Chart"; //Set the legend position. //Can be removed by settind it to null. chart.SetLegendPosition(LegendPosition.Left); //Plot all the data that was added to the chart before. //Multiple calls of this method leads to plotting multiple charts instead of modifying the existing chart. //Yet there is no possibility to remove chart or edit it's series/position. //We can just create the new one. chart.Plot(); workbook.SaveAs("CreateBarChart.xlsx");

Imports IronXL Imports IronXL.Drawing.Charts Private workbook As WorkBook = WorkBook.Load("test.xlsx") Private sheet As WorkSheet = workbook.DefaultWorkSheet 'Set the chart type and its position on the worksheet. Private chart = sheet.CreateChart(ChartType.Bar, 10, 2, 18, 5) 'Add the series to the chart 'For bar chart the first parameter is the address of the range for horizontal(value) axis. 'The second parameter is the address of the range for vertical(category) axis. Private series = chart.AddSeries("A3:A8", "B3:B8") 'Set the chart title. series.Title = "Bar Chart" 'Set the legend position. 'Can be removed by settind it to null. chart.SetLegendPosition(LegendPosition.Left) 'Plot all the data that was added to the chart before. 'Multiple calls of this method leads to plotting multiple charts instead of modifying the existing chart. 'Yet there is no possibility to remove chart or edit it's series/position. 'We can just create the new one. chart.Plot() workbook.SaveAs("CreateBarChart.xlsx")

Updated September 16, 2022

How to Use a CSV Parser in C#

It's simple to create a CSV parser. With only two lines of code you can load a CSV document and convert it to Excel.

Step 1

1. Download IronXL

Before I show you how to create a CSV parser, we'll first install IronXL to your project (free for development).

You can download directly from the Iron Software website by using the following link: https://ironsoftware.com/csharp/excel/docs/

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

Simply, you can also use the Developer Command Prompt:

PM> Install-Package IronXL.Excel

Figure 1 - IronXL.Excel NuGet Package

How to Tutorial

2. Create a New Project

After you have installed IronXL, create a new project and add the IronXL namespace

using IronXL;

using IronXL;

Imports IronXL

VB C#

3. Load a CSV File into Excel

The following code uses the Workbook object’s Load method to load a CSV file into Excel. This file is then parsed. Lastly, it uses the SaveAs method to save the file in the csv format.

/**
Parse CSV File
anchor-load-a-csv-file-into-excel
**/
private void button4_Click(object sender, EventArgs e)
{
    WorkBook wb = WorkBook.Load("Normal_Excel_File.xlsx"); //Import .xls, .csv, or .tsv file
    wb.SaveAs("Parsed_CSV.csv"); //Exported as : Parsed_CSV.Sheet1.csv
}

/**
Parse CSV File
anchor-load-a-csv-file-into-excel
**/
private void button4_Click(object sender, EventArgs e)
{
    WorkBook wb = WorkBook.Load("Normal_Excel_File.xlsx"); //Import .xls, .csv, or .tsv file
    wb.SaveAs("Parsed_CSV.csv"); //Exported as : Parsed_CSV.Sheet1.csv
}

'''
'''Parse CSV File
'''anchor-load-a-csv-file-into-excel
'''*
Private Sub button4_Click(ByVal sender As Object, ByVal e As EventArgs)
	Dim wb As WorkBook = WorkBook.Load("Normal_Excel_File.xlsx") 'Import .xls, .csv, or .tsv file
	wb.SaveAs("Parsed_CSV.csv") 'Exported as : Parsed_CSV.Sheet1.csv
End Sub

VB C#

Don’t forget to create an Excel Workbook named Normal_Excel_File.xlsx containing the following data:

Figure 2 - Excel data to be converted to CSV

4. Export the Parsed CSV

Interestingly, the exported CSV file will be saved as Parsed_CSV.Sheet1.csv because the data is on Sheet1 inside of the Excel Workbook. Below is what the file would look like in File Explorer when selected.

Figure 3 - Parsed_CSV.Sheet1.csv in File Explorer

You can download the software product from this link.

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

Examples

How to Use a CSV Parser in C#

Create CSV parser for .NET

Step 1

1. Download IronXL

How to Tutorial

2. Create a New Project

3. Load a CSV File into Excel

4. Export the Parsed CSV

Library Quick Access

IronXL API Reference Documentation

IronXL Blog