Elerium Excel .NET Specifications
|
Let your .NET application read/write Excel spreadsheets.
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).