Elerium Excel .NET Writer Specifications
|
Create Excel files (XLS, XLSX) using professional .NET component.
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) - 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.