Following code helps you to import grid values to excel,
//Import System.IO in your application for StreamWriter Object //note: excel_file represents the complete physical address of excel file eg C:/myexcel.xls public void export_datagridview_to_excel(DataGridView dgv, string excel_file) { int cols; //open file StreamWriter wr = new StreamWriter(excel_file); //determine the number of columns and write columns to file cols = dgv.Columns.Count; for (int i = 0; i < cols; i++) { wr.Write(dgv.Columns[i].Name.ToString().ToUpper() + “\t”); } wr.WriteLine(); //write rows to excel file for (int i = 0; i < (dgv.Rows.Count - 1); i++) { for (int j = 0; j < cols; j++) { if (dgv.RowsIdea.Cells[j].Value != null) wr.Write(dgv.Rows[i].Cells[j].Value + “\t”); else { wr.Write(”\t”); } } wr.WriteLine(); } //close file wr.Close(); }