‪Export data to XLS file in C#.NET using EasyXLS Excel library! The file has multiple sheets and the first sheet is filled with data.
http://www.easyxls.com/manual/tutorials/csharp/export-data-to-xls-file.html

‪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

‪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

‪How many chart types can you create in Excel, using EasyXLS Excel library, in C#, VB.NET, Java, PHP, C++ and other programming languages?

http://www.easyxls.com/manual/basics/excel-chart-types.html

‪Create Excel charts that can be placed in a separate sheet. A chart can have two positions, as a distinct sheet or as an object in a worksheet. EasyXLS also allows you to read Excel files that contain charts and extract chart information.

http://www.easyxls.com/manual/basics/excel-chart-sheet.html

‪Export data to an Excel file having one or multiple sheets in PHP or ASP classic! The data in cells can be formatted using predefined formats or user-defined formats.

http://www.easyxls.com/manual/FAQ/export-to-excel-in-php-asp.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.

Export DataGrid to Excel file in C# and VB.NET quick and effortless!
http://www.easyxls.com/manual/FAQ/export-datagrid-to-excel.html

EasyXLS is an Excel component that can be included in any C#, VB.NET or Java application.

Furthermore, it includes a .NET built DLL which is a COM+ library, that can be used from PHP, ASP classic, C++, VB6 or any other language that supports COM technology.

By including EasyXLS into your application, you can export Excel files that include macros or VBA code. The component supports XLSM file format, but, it also supports the older XLS format or the XLSB binary format.

EasyXLS preserves macros when the Excel file is loaded through the component. After working with loaded data or adding more data, the Excel file can be exported as XLSM file format or XLS, XLSB file.

For more technical details, read further how to export data to XLSM file.

EasyXLS can be used from any of the following environment and even more:

.NET version

• ASP.NET web pages
• Windows applications
• Windows Forms (WinForms)
• Console applications
• Windows service applications
• ASP.NET MVC web applications

COM+ version

• PHP web applications
• ASP classic web pages
• C++ applications
• MFC applications
• VB6 applications
• VBS scripts

Java version

• Java applications
• Java servlets
• ColdFusion web applications

EasyXLS Excel library lets you to export data to Excel in .NET from WinForms or ASP.NET applications.

The library works without Excel installed and without Interop. It is not dependent on other additional software.

Great tricks about exporting to Excel using EasyXLS can be found on the following links:

• Export to Excel in C#
• Export to Excel in VB.NET

EasyXLS supports the export of data in XLSX, XLSM, XLS and XLSB file formats for Microsoft Excel 97, 2003, 2007, 2010 and 2013. It is constantly updated to be in line with Microsoft Excel changes.

The Excel library allows you to export data from windows applications. Read more details about how to export to Excel from winform.

It also allows you to export data from ASP.NET web applications. Read more details about how to export to Excel in ASP.NET.

EasyXLS permits you to export data fast and it handles very well large Excel files.

Using this Excel library, string values, numeric values, dates or booleans can be successfully exported to Excel. It also supports formulas and even more, it includes a calculation engine for formulas. The data can be exported to Excel files having multiple sheets.

EasyXLS is a C# Excel library and VB.NET Excel library that can be integrated in any .NET application.