‪Export DataSet to Excel file with formatting in C#.NET using EasyXLS Excel library! The DataSet can contain data from a SQL database, GridView, DataGridView, DataGrid or other.
http://www.easyxls.com/manual/tutorials/csharp/export-dataset-to-excel-with-formatting.html

Import Excel data to DataGridView, in C# and VB.NET, from an Excel sheet or from the active Excel sheet.

http://www.easyxls.com/manual/FAQ/import-excel-to-datagridview.html

Have you ever had a WinForm that shows a nice report inside a DataGridView? It looks great! Now, you want to export this report to Excel and you’re asking yourself, “How can I do this?”. You have the button that it says “Export to Excel”, but now “What should I do?”. If this is your case, you are now on the right page. If you have never confronted with this situation, who knows, maybe tomorrow will surprise you and you can be ready from now on. See..you’re still on the right page.

EasyXLS Excel library makes such tasks so much easier to achieve. When it comes to export data to Excel, EasyXLS is the best choice. It offers all kind of methods and solutions that make complicated things uncomplicated when Excel files are involved.

Now, let’s get back to our DataGridView and “Export to Excel” button. Using EasyXLS, you can export DataGridView to XLSX, XLS, XLSM or XLSB file formats. The Excel file can also have multiple sheets and you can choose the right sheet where the DataGridView can fit. Do you have a huge DataGridView? EasyXLS handles very well exporting large data to Excel. If I have captured your attention, see here how to export DataGridView to Excel in C# and VB.NET.

In most of the cases the data source of the DataGridView is a DataTable. If so, have you ever thought that the export to Excel can be done with one line of code? Check this sample on exporting DataTable to Excel file in C# and VB.NET.

Now get your keyboard back to work. Happy coding!

EasyXLS 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.

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.