Download Download IronXL Free

bring Excel Various issues can arise when importing data into programming scenarios involving a .NET environment, especially related to interoperability aspects.

Iron XL is a specialized library designed to allow developers to bring their Excel spreadsheet data into .NET and .NET Core environments, and allow them to read and write XSLX, XLS and CSV formats.

The dedicated API allows users to create, read, manipulate, save and even export Excel data in an intuitive way, and is also available for .NET Standard, Xamarin, Windows Mobile, Mono and Azure Cloud platforms. The library’s export capabilities cover a variety of output formats, some of which include TSV, JSON, and the proprietary Excel format.

Working with data between Excel, SQL, and GridView primarily works by accessing spreadsheets as System.Data.DataSet and System.Data.DataTable objects. If the user wishes to include original Excel formulas, these formulas will be recalculated each time the worksheet is edited. Standard worksheet syntax is supported, as well as combination and range operations.

Last but not least, aesthetics are also available, with users still able to define the characteristics of the fonts used, backgrounds, borders or other relevant aspects such as alignment.