ELERIUM EXCEL .NET Author OVERVIEW
Elerium Excel .NET Writer is a wonderful resolution for C#, VB.NET and ASP.NET developers that makes it possible for to simply and efficiently develop Excel paperwork (XLS, XLSX, CSV), with no the want to set up further applications and Microsoft Excel. The Excel .NET Author can be easily implemented in C#, VB.NET or ASP.NET tasks/web sites. The installation bundle of the Excel Author consists of C# and VB.NET samples for quick start off.
The element is completely managed and available in tasks both C#, VB.NET or ASP.NET.
Essential attributes:
– Excel files XLSX, XLS, CSV.
– Techniques for Creating Excel files (see C# VB.NET examples).
– Various cell information sorts (numbers, strings, dates, floating level etc.)
– Multiple Excel worksheets.
– Excel worksheet Headers/Footers.
– Hiding / Exhibiting an excel worksheet.
– The capability to hide and unhide Row/Column.
– PASSWORD protection of Excel file.
– Excel Encryption / Decryption.
– Worksheet protection.
– Variety formatting (variety,currency, date, time, fraction etc.)
– Font formatting (dimension, colour, font variety, italic and strikeout properties, boldness, underlining, subscript and superscript).
– Cell alignment (vertical, horizontal).
– Excel spreadsheet Row height and Column width.
– Cell types (rotation, indentation, text wrapping).
– Cell Background and Fill Pattern.
– Cell borders (colour, fashion).
– Defined cell names.
– Merged Cells in Excel spreadsheet.
– Rich Text for excel cells.
– Calculation of math expressions.
– Excel Formulas.
– Unicode assistance, international characters.
– Appropriate-to-left text(Arabic).
– Excel Panes (vertical, horizontal, the two).
– Multithreading help.
– Export data from DataTable to Excel.
