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.
Exporting GridView to Excel file is a common task for almost all ASP.NET applications that involves displaying reports of data to users. Usually the report from the screen must be exported to different file formats. The Excel file formats, like XLS, XLSX, XLSM and XLSB, are some of them.
EasyXLS Excel library lets you export the GridView in a very simple and fast way and it allows you to format the report according to requirements.
The library can be integrated in ASP.NET web applications and can be used from C#, VB.NET or C++.NET.
The exported Excel file can have multiple sheets and each of them can contain another GridView, if necessary, or additional data.
EasyXLS allows you to export the GridView and the Excel file will have a similar look like your screen report. The library offers all the formatting features for the Excel cells including background, foreground, borders and alignment options. The data from the Excel cells can be locked from unintentional editing events. Even more, the exported Excel file can be password secured when the file is opened or edited.
EasyXLS handles very well big volume of data and it works without Excel installed and without OLE Automation.
Check here some source code samples:
Export GridView to Excel in C#
Export GridView to Excel in VB.NET
EasyXLS is a Java Excel library that offers direct methods that allow exporting a ResultSet to Excel file in Java.
The export methods are easy to use and the task can be performed even in one single line of code.
Export SQL data to Excel using Java
EasyXLS makes it simple to extract data from database and export data to Excel in XLS, XLSX, XLSM or XLSB file formats. The data can be exported to nice formatted Excel reports. EasyXLS component allows you to export data from any database, including MS SQL Server or MySQL.
Export ResultSet to Open XML file format
EasyXLS supports Open XML file format and allows the export of XLSX files. It also supports XLSM and XLSB files.
Export ResultSet to Excel 97, Excel 2013, Excel 2007, Excel 2010, Excel 2013
EasyXLS supports all MS Excel 97-2013 file formats: XLS, XLSX, XLSM and XLSB. It also supports text file formats like XML Spreadsheet, CSV, TXT and HTML.
EasyXLS Java Excel library integration
EasyXLS Excel library can be integrated in any Java applications, applets, servlets or JSP pages or programming languages that permit Java development like ColdFusion.
Check out this code sample on how to easily export ResultSet to Excel in Java!
It’s never been easier. EasyXLS Excel library provides methods for exporting the DataSet to Excel with one single line of code.
See more details and code samples about how to export DataSet to Excel in C# and VB.NET.
Export SQL data to Excel using C# or VB.NET
EasyXLS makes it easy to take out data from database and export data to Excel in XLS and XLSX file formats. The data can be arranged in nice formatted reports. The component allows you to export data from any database, including MS SQL Server or MySQL.
Export to Excel in ASP.NET from DataSet
EasyXLS component can be used from ASP.NET web applications. If the data is displayed in a GridView, see export GridView to Excel in ASP.NET.
Export data from DataSet to Excel in C# and VB.NET from windows application
EasyXLS component can also be used from WinForms and windows applications. If data is displayed in a DataGridView, see how to export DataGridView to Excel in C#.
Export DataSet to Excel Open XML
EasyXLS supports Open XML file format and allows the export of XLSX files. It also supports XLSM and XLSB files.
Export DataSet to Excel 2003
EasyXLS supports Excel 2003 file format and allows the export of XLS files. It also supports XML Spreadsheet, CSV, TXT and HTML files.
ALL WITHOUT MS Excel installed, WITHOUT Interop!
EasyXLS Excel library is your key!
The DataTable can be the result of a SQL query or the data source for a GridView, DataGridView and DataGrid.
Export SQL query to Excel file
The result of a SQL query can be instantly exported to Excel with one line of code using EasyXLS Excel library. See more details about how to export DataSet to Excel.
Export GridView to Excel file
If the data source of the GridView is a DataTable and the intention is to export simply the data contained by the DataTable, see more details about how to export DataTable to Excel. If you want to export also the GridView formatting to Excel, check how to export GridView to Excel.
Export DataGridView to Excel file
If the data source of the DataGridView is a DataTable and the intention is to export simply the data contained by the DataTable, see more details about how to export DataTable to Excel. If you want to export also the DataGridView formatting to Excel, check how to export DataGridView to Excel.
Export DataGrid to Excel file
If the data source of the DataGrid is a DataTable and the intention is to export simply the data contained by the DataTable, see more details about how to export DataTable to Excel. If you want to export also the DataGrid formatting to Excel, check how to export DataGrid to Excel.
Encoding for CSV, TXT and HTML files
EasyXLS will allow setting a custom character encoding like Unicode, ASCII, UFT-8 and UTF-32 when reading or writing CSV, TXT or HTML files.
The feature was already available for XLS, XLSX, XLSM and XLSB file formats and now was extended to text file formats.
The countries that use Greek alphabet, Cyrillic alphabet, Han script or special Latin characters will be able now to use the full functionality of our Excel library.
Format data labels for charts
EasyXLS will allow setting the data labels properties like:
- label position
- number format
- fill settings (no fill, solid fill, gradient fill, picture or texture fill, automatic)
- border color (no line, solid line, gradient line, automatic)
- border style (width, compound type, dash type, cap type, join type)
- shadow settings (presets, color, transparency)
- font settings (font name, font size, foreground, alignment)
- 3-D format settings(bevel, surface, lighting)
Best Features
EasyXLS covers all the major features that a Microsoft Excel file has, for all Excel file formats like XLS, XLSX, XLSM, XLSB and common file formats like XML, HTML, CSV and TXT.
EasyXLS can be used from:
- C#, VB.NET, J#, C++.NET or any other .NET compatible software
- PHP, ASP, C++, VB6, VBS or other software that supports COM technology
- JAVA, JSP, JSF, ColdFusion or any other software that can be integrated with Java
For the complete list of features please check the presentation brochure.
Best Performance
EasyXLS works without Microsoft Excel. It is faster than OLE Automation and handles very well large Excel files with a big volume of data.
Best Support
EasyXLS provides the best quality support to his customers. 24 hours of customer support including emails and phone calls.
EasyXLS, your Excel API library, has a more intuitive look now.
All the useful information is one click away. Our team is trying to offer you the best experience and focus on what is significant to you.
Enter the website and see more pictures that reveal EasyXLS library potential at its best. Check out the Feature Tour, Picture Gallery and the User Guide.
Have a look at our new demo, Grid & Chart Excel Viewer, an auxiliary .NET tool that displays an Excel file into a gridview.
We would appreciate it if you took a couple of moments and filled our survey, to let us know if you like our new website.