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!
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!