IronXL

Bringing Excel data into a programming scenario that involves a .NET environment can be the subject of various issues, especially those that pertain due to interoperability aspects.

IronXL is a purpose-fit library that was designed in order to allow developers to bring their Excel spreadsheet data into .NET and .NET Core environments and it will allow them to both read and write XSLX, XLS and CSV formats.

The dedicated API allows one to create, read, manipulate, save or even export Excel data into an intuitive manner also for .NET Standard, Xamarin, Windows Mobile, Mono and Azure Cloud platforms. The exporting capabilities of the library encompass a wide range of output formats, some of which include TSV, JSON and the proprietary Excel formats.

The main working principle for manipulating data between Excel, SQL and GridViews is accessing the spreadsheets as System.Data.DataSet and System.Data.DataTable objects. In case users wish to include their original Excel formulae, those will be recalculated each time a worksheet is edited. Standard worksheet syntax is supported, and so are combinations and range manipulation.

Last but not least, aesthetics are also available and users will still be able to define characteristics for the used fonts, background, borders or other relevant aspects such as alignment.