Export data to XLSX file in C#‪Export data to XLSX 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-xlsx-file.html

(0) Comments    Read More   

Export data to Excel file with formatting in C#‪Export data to Excel file in C#.NET with formatting styles using EasyXLS Excel library! http://www.easyxls.com/manual/tutorials/csharp/format-excel-cells.html

(0) Comments    Read More   

Export data to XLS file in C#‪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

(0) Comments    Read More   

Export DataSet to Excel file with formatting in C#‪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

(0) Comments    Read More   

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   

Create Excel chart types in C#, VB.NET, Java, PHP, C++ and other programming languages‪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

(0) Comments    Read More   

Create Excel chart sheet in C#, VB.NET, Java, PHP, C++ and other programming languages‪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

(0) Comments    Read More   

Export data to an Excel file in PHP or ASP classic

‪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

(0) Comments    Read More   

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   

Export DataGrid to Excel in C# or VB.NET

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

(0) Comments    Read More