Exporting data from sql database to excel spreadsheet

Question

Hi All i need code that will help me export data from my sql server database into an excel spreadsheet . Thanx

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/UploadFile/83fe73/solutions-to-export-data-from-database-to-excel-in-C-Sharp/ http://www.c-sharpcorner.com/uploadfile/eb5fab/export-large-data-from-gridview-to-excel-file-using-C-Sharp/default.aspx

Pero · Answer

Hello, you can easily, with just one method call, export DataTable to Excel with this Excel .NET library. Here is a sample Excel C# code how to export DataSet to Excel : // 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");

Zimbini Walaza · Answer

thanxa lot

Gaurav Tomar · Answer

Take a look on the given below link http://www.dotnetheaven.com/UploadFile/rahul4_saxena/DataInExcelSheet05302007080823AM/DataInExcelSheet.aspx If there is any problem than, let me know!!

Exporting data from sql database to excel spreadsheet

Answers (4)