The DevExpress ASP.NET Grid View (ASPxGridView) allows you to export data with ease. Data can be exported to a file or stream in the following formats:
Note that in this demo, export to table formats (XLS, XLSX, and CSV) is performed in the WYSIWYG (What You See Is What You Get) mode. Therefore, the table formatting, e.g., grouping, is lost and grid summaries are converted to strings. However, you can maintain such information by exporting grid data in the DataAware mode. You can see this functionality in the Excel Data Aware Export demo.