Elerium Excel .NET 2.2
lerium Excel .NET is a professional .NET component that can be used in any type of .NET (C#, VB.NET) projects. Developers can easily add functionality of create/read/write Excel files (XLS, XLSX, CSV) to WinForms / ASP.NET applications. Elerium Excel .NET has rich set of methods to edit the cells of Excel Worksheets either XLS XLSX or CSV files. Code Examples (C# VB.NET) shows how to adjust cell styles, fonts, borders etc.
Elerium Excel .NET is a standalone component that compatible with .NET 2.0 and higher and does not depend on third-party libraries and Microsoft Office Automation.
Key features:
- Excel files XLSX, XLS, CSV.
- Methods for Reading / Writing Excel files (see C# VB.NET examples).
- Various cell data types (numbers, strings, dates, floating point etc.)
- Multiple Excel worksheets.
- Number formatting (number,currency, date, time, fraction etc.)
- Font formatting (size, color, font type, italic and strikeout properties, boldness, underlining, subscript and superscript).
- Cell alignment (vertical, horizontal).
- Excel spreadsheet Row height and Column width.
- Cell styles (rotation, indentation, text wrapping).
- Cell borders (color, style).
- Cell Background and Fill Pattern.
- Merged Cells in Excel spreadsheet.
- Rich Text for excel cells.
- Excel Encryption / Decryption.
- PASSWORD protection of Excel file.
- Worksheet protection.
- Hiding / Showing an excel worksheet.
- The ability to hide and unhide Row/Column.
- Calculation of math expressions.
- Excel Formulas.
- Unicode support, international characters.
- Right-to-left text(Arabic).
- Defined cell names.
- Excel worksheet Headers/Footers.
- Excel Panes (vertical, horizontal, both).
- Multithreading support.
- Export data between Excel and DataTable.
- Template support (create new workbooks using existing workbook as a template).
Requirements
Changes: 2.2
- Added new excel mathematics functions.
- Fixed bug in calculation of complex formulas.
- Fixed bug in column insertion function.
- Fixed bug in row insertion function.
- Fixed bug in write method for Excel XLSX format.
