|
|
Elerium Excel .NET
-
Version
2.2
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 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).
|