How to Export the data From Database into Excel sheet ?????

Hi Abhimanyu,

use these codes
--------------------------------------------------
using Microsoft.Office.Interop.Excel;
using System;
using System.Data;
using System.Reflection;
using System.Text;

namespace DtToExcel
{
public class DtToExcel
{
public static void GetInExcel(System.Data.DataTable dtin, string StrFileName)
{
StringBuilder stringBuilder = new StringBuilder();
try
{
foreach (DataColumn dataColumn in (InternalDataCollectionBase) dtin.Columns)
stringBuilder.Append(dataColumn.ColumnName + ",");
}
catch (Exception ex)
{
throw new ArgumentException("Error :" + ex.Message);
}
DtToExcel.GenerateExcellSheet(((object) stringBuilder).ToString(), dtin, StrFileName);
}

private static void GenerateExcellSheet(string cols, System.Data.DataTable dt, string fname)
{
StringBuilder stringBuilder = new StringBuilder();
Application application = (Application) new ApplicationClass()
{
Visible = false
};
_Workbook workbook = (_Workbook) application.Workbooks.Add((object) Missing.Value);
_Worksheet worksheet = (_Worksheet) workbook.ActiveSheet;
string[] strArray = cols.Split(new char[1]
{
','
});
for (int index = 0; index <= strArray.Length - 2; ++index)
{
int num = index + 1;
worksheet.Cells[(object) 1, (object) num] = (object) ((object) strArray[index]).ToString();
}
for (int index1 = 0; index1 <= dt.Rows.Count - 1; ++index1)
{
for (int index2 = 0; index2 <= dt.Columns.Count - 1; ++index2)
worksheet.Cells[(object) (index1 + 2), (object) (index2 + 1)] = (object) dt.Rows[index1][index2].ToString();
}
worksheet.SaveAs(fname + ".xls", (object) Missing.Value, (object) Missing.Value, (object) Missing.Value, (object) Missing.Value, (object) Missing.Value, (object) Missing.Value, (object) Missing.Value, (object) Missing.Value, (object) Missing.Value);
workbook.Close((object) Missing.Value, (object) Missing.Value, (object) Missing.Value);
application.Quit();
}
}
}
--------------------------------------------------
Wrap them inside a file and use it like this:

DtToExcel.GetInExcel(myDatatable, ExcelFileNameToSave);

Alternatively I've attached my DLL to this post. You can refer and use it also, it will save your time.


Accept this as answer if it helps!

Happy Coding :)
Thanks.

try it,




http://www.c-sharpcorner.com/Blogs/11301/export-data-into-excelcsv-from-datatable.aspx