Elerium Excel .NET Writer 2.2

Elerium Excel .NET Writer is a great solution for C#, VB.NET and ASP.NET developers that allows to easily and effectively create Excel documents (XLS, XLSX, CSV), without the need to install additional applications and Microsoft Excel. The Excel .NET Writer can be easily implemented in C#, VB.NET or ASP.NET projects/websites. The installation package of the Excel Writer contains C# and VB.NET samples for quick start.

The component is completely managed and available in projects either C#, VB.NET or ASP.NET.

Key features:

- Excel files XLSX, XLS, CSV.
- Methods for Writing Excel files (see C# VB.NET examples).
- Various cell data types (numbers, strings, dates, floating point etc.)
- Multiple Excel worksheets.
- Excel worksheet Headers/Footers.
- Hiding / Showing an excel worksheet.
- The ability to hide and unhide Row/Column.
- PASSWORD protection of Excel file.
- Excel Encryption / Decryption.
- Worksheet protection.
- 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 Background and Fill Pattern.
- Cell borders (color, style).
- Defined cell names.
- Merged Cells in Excel spreadsheet.
- Rich Text for excel cells.
- Calculation of math expressions.
- Excel Formulas.
- Unicode support, international characters.
- Right-to-left text(Arabic).
- Excel Panes (vertical, horizontal, both).
- Multithreading support.
- Export data from DataTable to Excel.