Exporting Grid/dataset to excel

Question

hi. Pls give me the code to export data from datagrid or dataset into Excel in a simply way regards fazy

Pero · Answer

Hi with GemBox.Spreadsheet C# Excel library you can easily export DataSet to Excel . See code snippet below: // Create new ExcelFile. var ef = new ExcelFile(); // Imports all the tables from DataSet to new file. foreach (DataTable dataTable in dataSet.Tables) { // Add new worksheet to the file. var ws = ef.Worksheets.Add(dataTable.TableName); // Insert the data from DataTable to the worksheet starting at cell A1. ws.InsertDataTable(dataTable A1 true); } // Save the file to XLS format. ef.SaveXls(DataSet.xls);

Mahesh Chand · Answer

Export data to multiple sheets of Excel doc

Mahesh Chand · Answer

Export ASP.NET DataGrid to Excel by Dipal Choksi on Jan 03 2006 Export to Excel is one of the most common functionality required in ASP.NET pages. Users can download the data from the DataGrid into an Excel spreadsheet for offline verification and/or computation. ASP.Net 2.0: Export GridView to Excel by Dipal Choksi on Apr 03 2007 This article describes how to Export an ASP.Net 2.0 GridView to Excel. ASP.Net 2.0: Export GridView to Excel - Part II by Dipal Choksi on Apr 04 2007 In this version of the article we will include the handling the Hyperlink columns in the GridView export to Excel and also re-factor our original logic to use more general features of Reflection. Editable GridView Control in C# and .NET - Part IV Exporting the GridView to Excel by Mike Gold on Aug 29 2006 In this article we will take the contents of our GridView control and spill it into an Excel spreadsheet using this wrapper mechanism.