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

IronXL Blog

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.