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 Read Excel File in Blazor NET

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

Regan Pun

April 17, 2025

In this tutorial, you will learn how to view Excel files within a Blazer Server application by setting up an Excel file viewer using Iron XL. The process involves integrating Iron XL into a Visual Studio project and working with the necessary code. First, import the required 'using' statements for Iron XL and System.Data. Define a table structure in HTML with dynamic headers based on the Excel file's columns, while the rows are filled with data from the file. In the '@code' section, a data table named 'displayDataTable' is declared to store Excel data. The 'openExcelFromDisk' method manages file uploads and data extraction. When an Excel file is uploaded, it is read into a memory stream, which Iron XL loads into a workbook object. The first row's headers become the data table's columns, and subsequent rows are added as data rows. Running the code opens a Blazer web application page where you can navigate to the 'fetch data' menu, open an Excel file, and view its contents. This tutorial demonstrates the simplicity of using Iron XL to create an Excel file viewer in a Blazer server app, enhancing web application capabilities.

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 Set Cell Borders and Alignment in Excel

NEXT >
How to Set Cell Background Patterns and Color in Excel