Export to Excel

 private void btnexport_Click(object sender, EventArgs e)

        {

            try

            {

                SaveFileDialog saveFileDialog1 = new SaveFileDialog();

                saveFileDialog1.Filter = "Execl files (*.xls)|*.xls";

                saveFileDialog1.FilterIndex = 0;

                saveFileDialog1.DefaultExt = ".xls";

                saveFileDialog1.RestoreDirectory = true;

                saveFileDialog1.CreatePrompt = true;

                saveFileDialog1.Title = "Export Excel File To";

                Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application();

                object misValue = System.Reflection.Missing.Value;

                Excel.Application xlApp = new Excel.ApplicationClass();

                Excel.Workbook xlWorkBook = xlApp.Workbooks.Add(misValue);

                Excel.Worksheet xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

                for (int i = 1; i < dataGridView1.Columns.Count + 1; i++)

                {

                    xlWorkSheet.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText;

                }

                for (int i = 0; i < dataGridView1.Rows.Count; i++)

                {

                    for (int j = 0; j < dataGridView1.Columns.Count; j++)

                    {

                        xlWorkSheet.Cells[i + 2, j + 1] = Convert.ToString(dataGridView1.Rows[i].Cells[j].Value);

                    }

                }

                //Excel.ChartObjects xlCharts = (Excel.ChartObjects)xlWorkSheet.ChartObjects(Type.Missing);

                //Excel.ChartObject xlChart = (Excel.ChartObject)xlCharts.Add(300, 100, 300, 300);

                //Excel.Chart chartPage = xlChart.Chart;

                ////set the source data and the chart type.

                //Excel.Range chartRange = xlWorkSheet.get_Range("B2", "D13");

                //chartPage.SetSourceData(chartRange, misValue);

                //chartPage.ChartType = Excel.XlChartType.xlBarClustered;

                saveFileDialog1.ShowDialog();

                xlWorkBook.SaveAs(saveFileDialog1.FileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

                xlWorkBook.Close(true, misValue, misValue);

                if (MessageBox.Show("Are u Want to open the file", "Xls File Open", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)

                {

                    System.Diagnostics.Process.Start(saveFileDialog1.FileName);

                }

                releaseObject(xlWorkSheet);

                releaseObject(xlWorkBook);

                releaseObject(ExcelApp);

                // MessageBox.Show("The Save button was clicked or the Enter key was pressed" + "\nThe file would have been saved as " + this.saveFileDialog1.FileName);

            }

            catch

            { }

        }