We can easily use IronExcel to read Excel files in any C# or VB .NET application, including those developed with .NET Framework, Core, and Standard. We use IronExcel to read in an XLS or XLSX file and can then manipulate the data, including formulas.
Version: 2021.1IronXL (Excel) is a C# VB .NET class library with functionality for reading, generating, and updating Excel spreadsheets.
License: Free To Try $399.00
Operating System: Windows
Iron Excel can be used for a host of applications, including accounting and finance systems, content management, and data import.
Iron Excel is different from Office Interop not only that it requires very little to be installed on the target machine, but also, IronExcel is unique in its usability.
The API is incredibly easy to use and install within any .NET project, including C# projects which read Excel files, create Excel files, and export or import data from Excel. This saves hours or weeks of development.
You can read data from Excel in C# to summarize data or export it to a database.
You can also use it to validate or write data to an Excel document, edit existing documents, and extract content such as text and images from documents.
The API supports formatting the cells in the worksheet so you can make beautiful spreadsheets that impress your audience.
You can add Excel document processing to your integration pipeline to automate repetitive tasks such as data entry.
Developers don't need to install any software for IronXL to run.
Install the NuGet package from https://www.nuget.org / packages / Ironxl.excel in Visual Studio and Read the API document here: https://ironsoftware.com / csharp / excel / docs/. The NuGet package contains a dll to read excel file with C#.
The documentation comes with a set of four sample applications that demonstrate how to read data from Excel, write data from a Web API to an Excel document, validate data in an Excel document, import Excel data into a database, and add formula to perform complex calculations in the worksheet.
IronXL is free for development use and can be used liberally on machines where Visual Studio is in use.
IronXL offers commercial licensing for deployment when your ASP .NET Core website is deployed to a staging or live web server.
Contact us now for more information on licensing.
Version 2021.1: Released New version of IronXL in C# to Read Excel Files. Supports XLSX, XLS, CSV and .Net Core, .net standard and .NET Framework projects.