Hi, see this thread:
Exporting DataGridview To Excel[
^]
and
I've also used below code: (It works for me)
using Excel;
private void CreateExcelFile(DataSet ds, string filename)
{
if (ds.Tables[0].Rows.Count > 0)
{
Excel.Application objApp = new Excel.Application();
Excel.Workbooks objBooks = objApp.Workbooks;
Excel.Workbook objBook = objBooks.Add(Missing.Value);
Excel.Worksheet objSheet = null;
try
{
objSheet = (Excel.Worksheet)objBook.Worksheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
((Excel.Worksheet)objBook.Sheets[1]).Select(Missing.Value);
int row = 0;
objSheet.Cells[row + 1, 1] = "Employee ID";
objSheet.Cells[row + 1, 2] = "Last Name";
objSheet.Cells[row + 1, 3] = "First Name";
foreach (DataRow dr in ds.Tables[0].Rows)
{
row++;
for (int col = 0; col < ds.Tables[0].Columns.Count; col++)
{
objSheet.Cells[row + 1, col + 1] = dr[col].ToString();
}
}
objBook.Close(true, filename, Missing.Value);
objBooks.Close();
}
catch (Exception e)
{
MessageBox.Show("Successfully Exported!", "Export to Excel", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
else
{
MessageBox.Show("No Records Found!", "Export to Excel", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
}
}
Hope it helps! :)