Exporting GridView to Excel file is a common task for almost all ASP.NET applications that involves displaying reports of data to users. Usually the report from the screen must be exported to different file formats. The Excel file formats, like XLS, XLSX, XLSM and XLSB, are some of them.

EasyXLS Excel library lets you export the GridView in a very simple and fast way and it allows you to format the report according to requirements.

The library can be integrated in ASP.NET web applications and can be used from C#, VB.NET or C++.NET.

The exported Excel file can have multiple sheets and each of them can contain another GridView, if necessary, or additional data.

EasyXLS allows you to export the GridView and the Excel file will have a similar look like your screen report. The library offers all the formatting features for the Excel cells including background, foreground, borders and alignment options. The data from the Excel cells can be locked from unintentional editing events. Even more, the exported Excel file can be password secured when the file is opened or edited.

EasyXLS handles very well big volume of data and it works without Excel installed and without OLE Automation.

Check here some source code samples:
Export GridView to Excel in C#
Export GridView to Excel in VB.NET

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!