Edit Overview
MyXLS is a .NET 2.0 library that writes and reads native
Excel files quickly and easily, including formatting and multiple sheets. Generate
Excel files for ASP.NET sites or .NET applications. Doesn't require
Excel on the server or any licensing. Compatible with
Excelversions 97 and up.
Features
- Pure .NET code - no P/Invokes, Interop assemblies, or Excel COM automation behind the scenes.
- No other dependencies - add and reference the MyXls dll in your project and go!
- Fast! (we will be adding some performance metrics)
- Lightweight! The dll is only ~100 KB
- Free to use, no licensing restrictions.
- Open Source Project
- The files generated are 100% compatible with Excel versions 97 and up. Files are BIFF8, which is Excel 97-2003's native format, and fully forward compatible with Excel 2007.
- Create any number of Worksheets
- Name Worksheets
- Write values to any cell on any Worksheet - values don't have to be in contiguous ranges
- Supports a good portion of Excel's formatting capabilities (bold, underline, italic, rotation, etc)
- Supports writing Metadata - values displayed in Excel's File->Properties dialog box