public static void Export_To_Excel(DataGridView dtGridView, string filename, string sheetName) { int i, j; object missing = Type.Missing; Excel.ApplicationClass excellApp; excellApp = new Excel.ApplicationClass(); excellApp.Application.Workbooks.Add(true); try { // Add columns name to excel file for (i = 0; i < dtGridView.Columns.Count; i++) { excellApp.Cells[1, i + 1] = dtGridView.Columns[i].Name; } for (i = 0; i < dtGridView.Rows.Count; i++) { for (j = 0; j < dtGridView.Columns.Count; j++) { excellApp.Cells[i + 2, j + 1] = dtGridView.Rows[i].Cells[j].Value; } } //excellApp.Save(("Loinhuan.xls"); Excel._Worksheet worksheet = (Excel._Worksheet)excellApp.ActiveSheet; worksheet.Activate(); worksheet.Name = sheetName; worksheet.SaveAs(filename, missing, missing, missing, missing, missing, missing, missing, missing, missing); //excellApp.Workbooks[1].SaveCopyAs(@"D:\Project\SVN\Source\Quanlyloinhuan\Loinhuan.xls"); excellApp.Quit(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } }