Elerium Excel .NET Writer makes it simple for C#, VB.NET, and ASP.NET developers to generate high-quality Excel documents (XLS, XLSX, CSV).
Elerium Excel .NET Writer is a software solution that caters to the needs of developers using C#, VB.NET, and ASP.NET. With its easy-to-use interface, developers can create Excel documents (XLS, XLSX, CSV) without the installation of additional applications or Microsoft Excel.
The Excel .NET Writer is easily integrated into C#, VB.NET or ASP.NET projects / websites, thanks to a comprehensive installation package containing C# and VB.NET sample codes for quick start. This component is completely managed and can be used for projects on C#, VB.NET or ASP.NET platforms.
Among its many features, Excel files can be created in several popular formats, such as XLSX, XLS, and CSV. The component comes with various methods for writing Excel files, as seen in the C# and VB.NET examples. It supports different cell data types, including numbers, strings, dates, and floating points.
Additionally, multiple Excel worksheets are supported, as well as worksheet Headers/Footers. Users can also hide/show, hide/unhide rows/columns, and utilize password protection on Excel files. Excel Encryption/Decryption and worksheet protection are also available.
The Excel .NET Writer also offers a variety of formatting options, such as number formatting (number, currency, date, time, fraction, etc.), font formatting (size, color, font type, italic, and strikeout properties, boldness, underlining, subscript/superscript), Cell alignment (vertical, horizontal), Excel spreadsheet Row height and Column width. It also provides cell styles (rotation, indentation, and text wrapping), cell background and fill pattern and cell borders (color and style).
Other features include defined cell names, merged cells in Excel spreadsheet, rich text for excel cells, calculation of math expressions, excel formulas, Unicode support, international characters, and Right-to-left text(Arabic). Excel Panes (vertical, horizontal, both), multithreading support, and Export data from DataTable to Excel are also supported.
Overall, Elerium Excel .NET Writer offers a comprehensive set of features for Excel document creation and supports different platforms. With its ease of use and multiple functionalities, developers can create Excel documents efficiently and effectively.
The Excel .NET Writer is easily integrated into C#, VB.NET or ASP.NET projects / websites, thanks to a comprehensive installation package containing C# and VB.NET sample codes for quick start. This component is completely managed and can be used for projects on C#, VB.NET or ASP.NET platforms.
Among its many features, Excel files can be created in several popular formats, such as XLSX, XLS, and CSV. The component comes with various methods for writing Excel files, as seen in the C# and VB.NET examples. It supports different cell data types, including numbers, strings, dates, and floating points.
Additionally, multiple Excel worksheets are supported, as well as worksheet Headers/Footers. Users can also hide/show, hide/unhide rows/columns, and utilize password protection on Excel files. Excel Encryption/Decryption and worksheet protection are also available.
The Excel .NET Writer also offers a variety of formatting options, such as number formatting (number, currency, date, time, fraction, etc.), font formatting (size, color, font type, italic, and strikeout properties, boldness, underlining, subscript/superscript), Cell alignment (vertical, horizontal), Excel spreadsheet Row height and Column width. It also provides cell styles (rotation, indentation, and text wrapping), cell background and fill pattern and cell borders (color and style).
Other features include defined cell names, merged cells in Excel spreadsheet, rich text for excel cells, calculation of math expressions, excel formulas, Unicode support, international characters, and Right-to-left text(Arabic). Excel Panes (vertical, horizontal, both), multithreading support, and Export data from DataTable to Excel are also supported.
Overall, Elerium Excel .NET Writer offers a comprehensive set of features for Excel document creation and supports different platforms. With its ease of use and multiple functionalities, developers can create Excel documents efficiently and effectively.
What's New
Version 2.2:
- New methods for operation with excel CellRange.
- Added new excel mathematics functions.
- Fixed bug of calculating complex formulas.
- Fixed bug in column insertion function.
- Fixed bug in row insertion function.
- Fixed bug in write function for Excel XLSX format.