Jan
14
Posted on 14-01-2019
Filed Under (Uncategorized) by Oana

easyXLS export dataset excel vbnetExport DataSet to Excel file in VB.NET from ASP.NET web pages or windows application by EasyXLS! XLS, XLSX, XLSM, XLSB spreadsheets in .NET.

https://www.easyxls.com/manual/tutorials/vb-net/export-dataset-to-excel.html

(0) Comments    Read More   
Dec
18
Posted on 18-12-2017
Filed Under (Uncategorized) by Oana

easyxls export dataset excelExport DataSet to Excel file in J#.NET with cell formatting from ASP.NET or windows application! XLS, XLSX, XLSM, XLSB spreadsheets in .NET.

https://www.easyxls.com/manual/tutorials/jsharp/export-dataset-to-excel-with-formatting.html

(0) Comments    Read More   
Apr
07
Posted on 07-04-2016
Filed Under (Uncategorized) by Oana

excel export dataset jsharp
Export DataSet to Excel file in J#.NET from ASP.NET web pages or windows application!
http://www.easyxls.com/manual/tutorials/jsharp/export-dataset-to-excel.html

(0) Comments    Read More   
Jun
29
Posted on 29-06-2015
Filed Under (Uncategorized) by Oana

Import Excel sheet to DataSet in C#‪Import Excel sheet to DataSet in C#.NET using EasyXLS Excel library! The data is imported from a specific Excel sheet.
http://www.easyxls.com/manual/tutorials/csharp/import-excel-sheet-to-dataset.html

(0) Comments    Read More   
Jun
22
Posted on 22-06-2015
Filed Under (Uncategorized) by Oana

Import Excel file to DataSet in C#‪Import Excel file to DataSet in C#.NET using EasyXLS Excel library! Learn how to do it and save valuable time with EasyXLS!
http://www.easyxls.com/manual/tutorials/csharp/import-excel-to-dataset.html

(0) Comments    Read More   
May
04
Posted on 04-05-2015
Filed Under (Uncategorized) by Oana

Export DataSet to Excel file in C#‪Export DataSet to Excel file in C#, 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.html

(0) Comments    Read More   
Dec
01
Posted on 01-12-2014
Filed Under (Uncategorized) by Oana

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

(0) Comments    Read More   
Nov
24
Posted on 24-11-2014
Filed Under (Uncategorized) by Oana

Export large data to Excel in C#, VB.NET, Java, C++, PHP and other programming languagesEasyXLS 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:

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.

(0) Comments    Read More   
Aug
27
Posted on 27-08-2014
Filed Under (Uncategorized) by Daniela

Export data to XLSX file in .NET or JavaEasyXLS 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.

(0) Comments    Read More   
Jun
10
Posted on 10-06-2014
Filed Under (Uncategorized) by Oana

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!

(0) Comments    Read More