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

VIDEOS

How to Set Cell Background Patterns and Color in Excel

Name: IronXL
Brand: Iron Software
Availability: InStock
Rating: 4.67 (175 reviews)

Regan Pun

February 26, 2024

In this tutorial, we explore setting cell background patterns and colors in Excel using the IronXL and Iron Software Drawing Library. After installing the required packages via NuGet, we dive into the code, where the namespaces IronXL and IronXL.Styles are included for Excel manipulation. Aliasing Iron Software.Drawing DoColor as Color helps in clarity. We create a new workbook and set background fill patterns for cells A1 and A2. Cell A1 features alternating bars with an aquamarine color, while cell A2 displays thick vertical bands in a color defined by the hex code #AF2F. The workbook is saved as 'set background pattern.xlsx'. Running the project shows the successful application of these styles. The tutorial concludes by encouraging viewers to try out the software and explore its capabilities further with a trial subscription link provided.

Get stated with IronXL now.

Regan Pun

Chat with engineering team now

Software Engineer

Regan graduated from the University of Reading, with a BA in Electronic Engineering. Before joining Iron Software, his previous job roles had him laser-focused on single tasks; and what he most enjoys at Iron Software is the spectrum of work he gets to undertake, whether it’s adding value to sales, technical support, product development or marketing. He enjoys understanding the way developers are using the Iron Software library, and using that knowledge to continually improve documentation and develop the products.

< PREVIOUS
How to Read Excel File in Blazor NET

NEXT >
How to Auto Resize Rows and Columns in Excel