Export data to XLSX file in .NET or JavaEasyXLS Excel library makes easier the export of Excel reports in XLSX file format.

The Excel reports can be formatted to have an attractive look, exactly in the preferred mode, or one of the predefined looks can be selected.

The Excel library works without Excel installed and without Interop and it is perfect to be used from server environments or desktop applications.

Data structures like GridView, DataGridView, DataGrid, DataTable, DataSet, JTable and ResultSet can be exported to XLSX file with one single line of code.

EasyXLS can be used from programming languages like C#, VB.NET, C++.NET, J#, Java, PHP, ASP classic, C++, VB6, VBS or ColdFusion.

EasyXLS allows not only the export of data and formatting, but also offers other Excel features like conditional formatting, data validation, comments, images and print options.

Moreover, the data can be exported as charts, pivot tables or pivot charts.

The data can be protected with password and the Excel file can be encrypted.

The export of XLSX file is fast, so it is the best solution for exporting large xlsx files.

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

(0) Comments    Read More   

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.

export data to excel with formatting

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.

(0) Comments    Read More