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.
Feel free to like and share with your friends our Facebook account
https://www.facebook.com/EasyXLS
Let’s grow EasyXLS together!
We are pleased to announce that our website has a new image.
www.easyxls.com – .NET and Java component to read, write or edit Microsoft Excel files
The home page of the website offers more information at the first glance.
We hope you enjoy our new makeover!