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")

Using IronXL

November 15, 2022

How to Generate an Excel File on Razor Pages

This tutorial will teach you a very easy method for generating and exporting Excel files or Excel reports with dummy data and header rows in Razor Page Models using IronXL.

September 16, 2022

How to Use a CSV Parser in C#

IronXL makes it very easy for you to create a CSV parser.

June 30, 2022

Read CSV File Using C# (Code Example Tutorial)

Read CSV File in C#, I came upon a program called IronXL. Excel in the NuGet Package Manager console, which does not require office interop or the installation of MS Office.

June 29, 2022

C# Open Excel File Programmatically (Code Example Tutorial)

Creating the xlsx files programmatically requires many lines of code that can get complicated very quickly.

June 28, 2022

How to Highlight Every Other Row in Excel

There are several reasons why we might want to highlight rows in Excel. One of the most common reasons is to show data that is relevant and important.

June 27, 2022

Datatable to Excel in C# (Code Example Tutorial)

I'll teach you how to make an Excel file and programmatically export Datatable to an Excel sheet without any problem using IronXL.

June 24, 2022

How to Move Rows in Excel

We can move rows or selected cells in Microsoft Excel. There are several methods for doing this. Let's suppose we have these rows in Microsoft Excel and we need to move a row.

February 26, 2022

How to Merge Cells in Excel: Step by Step Tutorial

By locking, cells will not be able to edit and customize. You can hide the essential function cells too. This function is beneficial for confidentiality. You can lock a cell in Microsoft Excel by entering a password

February 25, 2022

How to Lock Cells in Excel: a Step by Step Tutorial

December 10, 2021

Reading CSV Files in C#: a Tutorial

CSVs are very popular import and export data formats used in spreadsheets and databases.It is possible to Read and Write CSV Data with the help of the CSV Help library.

October 8, 2020

Create a CSV file using C#

It is extremely easy to create and output a CSV file with IronXL.

October 7, 2020

Generate Excel Files in C#

Generate Excel File C#, including XLSX, JSON, CSV, XML and other formats for your C# project.

October 6, 2020

Work with Excel in .NET Core

.NET Core Excel overview and example projects. Code samples show how to work with Excel in .NET Core.