Exporting data from sql database to excel spreadsheet

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

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");

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!!