saveFileDialog1.InitialDirectory = "C:"; saveFileDialog1.Title = "Save as Excel File"; saveFileDialog1.FileName = ""; saveFileDialog1.Filter = "Excel Files(2003) |*.xls|Excel Files(2007)|*.xlsx"; if (saveFileDialog1.ShowDialog() != DialogResult.Cancel) { Microsoft.Office.Interop.Excel.ApplicationClass Excelapp = new Microsoft.Office.Interop.Excel.ApplicationClass(); Excelapp.Application.Workbooks.Add(Type.Missing); Excelapp.Columns.ColumnWidth = 20; for (int i = 1; i < dgv.Columns.Count + 1; i++) { Excelapp.Cells[1, i] = dgv.Columns[i - 1].HeaderText; } for (int i = 0; i < dgv.Rows.Count-1; i++) { for (int j = 0; j < dgv.Columns.Count-1; j++) { Excelapp.Cells[i + 2, j + 1] = dgv.Rows[i].Cells[j].Value.ToString(); } } Excelapp.ActiveWorkbook.SaveCopyAs(saveFileDialog1.FileName.ToString()); Excelapp.ActiveWorkbook.Saved = true; Excelapp.Quit(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)