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

Compare to Other Components

May 17, 2023

EPPlus Read Excel to Datatable C# (IronXL Tutorial)

EPPlus is a powerful open-source library for creating and manipulating Excel files in C#. It provides a simple and intuitive API that allows developers to generate, read, and modify Excel spreadsheets programmatically,

May 9, 2023

A Comparison Between IronXL and FastExcel for .NET

In this article, we will compare IronXL and FastExcel v4, highlighting the strengths and weaknesses of each library, and providing examples of how to use both in C#.

February 16, 2023

A Comparison of IronXL and GemBox.Spreadsheet

IronXL and Gembox.Spreadsheet both provide the methods to create, edit, and read Excel documents in the .NET framework.

October 25, 2022

A Comparison of IronXL and ClosedXML

IronXL and ClosedXML both provide methods to create, edit, and read Excel documents in the .NET framework.

June 10, 2022

A Comparison between IronXL and GrapeCity Excel Viewer

GrapeCity's embedded bi platform offers limitless high-speed visual data exploration, allowing the everyday user to become data-driven to easily report solutions.

June 8, 2022

A Comparison between IronXL and Syncfusion Excel

How does the Syncfusion Excel (XlsIO) library with IronXL? Learn about Syncfusion Excel alternatives and find the best choice to use in your next C# .NET project.

May 23, 2022

A Comparison between IronXL and Spire XLS

Spire.XLS for .NET is an object model Excel API that allows you to generate new Excel documents from templates, edit existing Excel documents, and convert Excel files in the .NET platform..

May 19, 2022

A Comparison between IronXL and CsvWriter

A .NET library for writing CSV files. Extremely fast, flexible, and easy to use. Supports writing of custom class objects.

May 10, 2022

A Comparison between IronXL and CsvHelper

A .NET library for reading and writing CSV files. Extremely fast, flexible, and easy to use. Supports reading and writing of custom class objects.

March 30, 2022

A Comparison between IronXL and Aspose Cells

IronXL and Aspose Cells both provide the methods to create, edit, and read excel documents in .NET Framework. The next question is to decide which C# Excel library is best suited for your project.

March 29, 2022

A Comparison between IronXL and Microsoft Office Interop Excel

IronXL and Microsoft Excel Interop both provide the methods to create, edit, and read excel documents in .NET Framework. The next question is to decide which C# Excel library is best suited for your project.

March 24, 2022

A Comparison between IronXL and Epplus

EPPLus has an API that allows you to work with Office Excel documents. EPPlus is a.NET library that reads and writes Office OpenXML-formatted Excel files. This library is available as a package from NuGet.

December 2, 2021

A Comparison of IronXL and NPOI

NPOI is the .NET version of the POI Java project at http://poi.apache.org/. POI is an open-source project that can help you read/write xls, doc, ppt files. It has a wide range of applications.

November 19, 2021

A Comparison of IronXL and Aspose Cells

Aspose.Cells for .NET is a spreadsheet programming library that allows software developers to manipulate and convert spreadsheet files from within their own applications