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

Import Excel file to DataSet in C# or VB.NET! Learn how to do it and save valuable time with EasyXLS!

http://www.easyxls.com/manual/basics/import-excel-to-dataset.html

EasyXLS is an Excel component that can be used to export Excel files programmatically. It also permits the export of large amount of data to Excel file.



EasyXLS is an optimal solution to:

• export large volume of data from MS SQL, MySQL, MS Access, Oracle database
• export large GridView to Excel
• export large DataSet to Excel
• export large DataTable to Excel
• export large ResultSet to Excel

The Excel component supports all MS Excel file formats: XLSX, XLS, XLSM, XLSB and XML Spreadsheet. The below links explains with source code samples how to export data to these file formats:

• How to export data to XLSX file format?
• How to export data to XLS file format?
• How to export data to XLSM file format?
• How to export data to XLSB file format?

However, the recommended file format for large Excel files is the binary format like XLSB or XLS formats. Binary files are faster by default.

For a fast export and better memory management, some steps must be followed. Check the below link for more technical details:
How to export large Excel file?

The Excel component can be used from C#, VB.NET, C++.NET, PHP, ASP classic, C++, Java, VBS, VB6 or ColdFusion.

EasyXLS is an Excel component that facilitates the export of real XLS files from C#, VB.NET, Java, C++, PHP or ASP classic.

It is a common practice to save HTML files with XLS extension to export reports as Excel. But sometimes you need real XLS binary files for having access to full Excel feature, not only cell data and cell formatting. If your Excel file must include autofilters, pivot tables, conditional formatting, macros or charts, EasyXLS Excel component is the best solution and offers all of these features and even more. Your Excel file can also have multiple sheets.

Using EasyXLS, you can export a GridView, DataGridView, DataGrid, DataTable, DataSet, JTable or ResultSet data structures to Excel with one single line of code.

The exported data can be arranged in predefined or custom formats and if necessary, the data can be protected from unintentional editing actions or secured with passwords.

Furthermore, EasyXLS component handles very well big volume of data. Large Excel files can be exported with less memory consumption and at a reasonable speed.

EasyXLS also includes a calculation engine, that allows not only to add formulas to your Excel, but also to calculate them, if necessary.

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

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!