Read / Write Excel spreadsheats in .NET
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).
|