Elerium 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); 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).
What is new in this release:
Version 2.2:
- New methods for operation with excel CellRange.
- 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.
Requirements:
.NET 2.0
Limitations:
Limited functionality
Comments not found