EasyXLS is an Excel component that facilitates the export of real XLS files from C#, VB.NET, Java, C++, PHP or ASP classic.

It is a common practice to save HTML files with XLS extension to export reports as Excel. But sometimes you need real XLS binary files for having access to full Excel feature, not only cell data and cell formatting. If your Excel file must include autofilters, pivot tables, conditional formatting, macros or charts, EasyXLS Excel component is the best solution and offers all of these features and even more. Your Excel file can also have multiple sheets.

Using EasyXLS, you can export a GridView, DataGridView, DataGrid, DataTable, DataSet, JTable or ResultSet data structures to Excel with one single line of code.

The exported data can be arranged in predefined or custom formats and if necessary, the data can be protected from unintentional editing actions or secured with passwords.

Furthermore, EasyXLS component handles very well big volume of data. Large Excel files can be exported with less memory consumption and at a reasonable speed.

EasyXLS also includes a calculation engine, that allows not only to add formulas to your Excel, but also to calculate them, if necessary.

Read more details on how to export data to xls file in C#, VB.NET, Java, C++, PHP.

Nice formatted reports
EasyXLS can be used to create nice formatted Excel reports. The exported reports can be in XLSX, XLS, XLSM or XLSB file format.

EasyXLS Excel library can be integrated in various programming languages like C#, VB.NET, C++.NET, Java, PHP, ASP classic or C++ or more. The library can be included in any environment that supports .NET, Java or COM technology.

Predefined formats
The report can have a predefined look or a custom formatting. EasyXLS comes with 50 predefined auto formats. Also, custom color and font schemes can be set for report appearance. Themes of colors can be applied for Office 2007-2013 documents.

Data protection
The data in cells can be protected from unintended editing, if data must keep its integrity. Excel file can also be protected with password when the file is opened or modified. EasyXLS also support encrypted Excel files.

Full support
EasyXLS supports all formatting settings that Microsoft Excel offers for spreadsheet design like number and date format, text alignment, font settings, border settings, fill settings (background, pattern gradient) and cell protection.

Read more about how to format Excel cells, Excel rows or Excel columns. Code samples and more technical details can be found at this link.