Sweety

Sweety

  • NA
  • 98
  • 110.9k

Export datagridview data to excel

Jun 22 2011 8:12 AM
In my application i'm exporting datagridview data to excel sheet now i want to pass the combox and textbox  selected values to excel sheet and i have to give title to my excel sheet as Report for my windows application how can i do that.

can any1 help me on this

i got code for exporting datagridview data to excel:

private void btnexcel_Click(object sender, EventArgs e)
  {
  Excel.Application xlApp ;
  Excel.Workbook xlWorkBook ;
  Excel.Worksheet xlWorkSheet ;
  object misValue = System.Reflection.Missing.Value;

  xlApp = new Excel.ApplicationClass();
  xlWorkBook = xlApp.Workbooks.Add(misValue);
  xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
  int i = 0;
  int j = 0;

  for (i = 0; i <= dataGridView1.RowCount  - 1; i++)
  {
  for (j = 0; j <= dataGridView1.ColumnCount  - 1; j++)
  {
  DataGridViewCell cell = dataGridView1[j, i];
  xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
  }
  }

  xlWorkBook.SaveAs("csharp.net-informations.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
  xlWorkBook.Close(true, misValue, misValue);
  xlApp.Quit();

  releaseObject(xlWorkSheet);
  releaseObject(xlWorkBook);
  releaseObject(xlApp);

  MessageBox.Show("Excel file created , you can find the file c:\\csharp.net-informations.xls");
  }

  private void releaseObject(object obj)
  {
  try
  {
  System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
  obj = null;
  }
  catch (Exception ex)
  {
  obj = null;
  MessageBox.Show("Exception Occured while releasing object " + ex.ToString());
  }
  finally
  {
  GC.Collect();
  }
  }

  }
  }

Answers (6)