ExpertXls Excel Spreadsheets Library for .NET NuGet Package

Create Excel spreadsheets for Office 97/2003 or Office 2007+ on the fly with an easy to use .NET library.

No 3rd party dependencies. No Microsoft Office Excel dependencies.

The ExpertXLS Excel Library for .NET can be linked into any type of .NET project, either ASP.NET web sites or Windows Forms and WPF applications, to enable your application to create new Excel documents from scratch or to edit existing Excel documents. The ExpertXLS Excel Library for .Net offers support both for the old Excel 97-2003 format (.xls) and for the new Excel 2007 or above (.xlsx) format.



The integration is extremely easy and no additional installation is necessary in order to get started. The library is delivered as a strong named assembly that can be directly referenced by your project. The downloaded archive contains C# and VB.NET samples for ASP.NET and Windows Forms and the complete API documentation.

Features

- Easy integration, no installation or setup is necessary
- Deployed as single strong named .NET assembly
- Can be used from any .NET application (ASP.NET, Windows Forms, WPF))
- Does not depend on Microsoft Office Excel
- Can run in Medium Trust environments (like shared hosting)
- Can run on 32-bit and 64-bit Windows servers
- Create new Excel documents or edit existing Excel documents
- Support for Excel 97-2003 (.xls) and Excel 2007 or above (.xlsx) formats
- Load a workbook from a stream or from a file
- Save a workbook to a stream or to a file
- Load data from CSV files and save data to CSV format
- Load data from a .NET DataTable or save data to a DataTable object
- Add chart shapes or chart worksheets to a workbook
- Add formulas and array formulas to a worksheet
- Add global styles to a workbook
- Advanced support for Excel 2007 and above gradients and textures
- Add named ranges at worksheet or workbook level
- Add images to a worksheet
- Add hyperlinks and comments to a worksheet
- Support for data validation.