ExpertXLS Excel Library for .NET
The ExpertXLS Excel Library for .NET can be linked into any type of .NET 2.0, .NET 3.5 or .NET 4.0 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 (.xlsx) format.
The library is a .NET managed assembly and does not depend on Microsoft Office Excel. The library can also be used from ASP.NET applications running in more restrictive environments like servers where the trust level for the ASP.NET application was restricted to Medium Trust by the server administrator.
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 (.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 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
- Support for workbook windows and structure protection
- Support for worksheet data protection
- Read and write password protection for .xls workbooks
- Support for worksheet page setup - headers, footers, size, margins, orientation
- Support for workbook properties - author, subject, comments