데이터그리드뷰에 있는 데이터를 excel로 내보내기
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Application.Workbook workbook = app.Workbooks.Add(Type.Missing);
Microsoft.Office.Interop.Excel.Worksheet worksheet = null;
app.Visible = true;
worksheet = workbook.Sheets["Sheet1"];
worksheet = workbook.ActiveSheet;
for (int i = 1; i <dataGridView1.Columns.Count+1; i++)
{
worksheet.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++)
{
worksheet.Cells[i+2, j+1] = dataGridView1.Rows[i].Cells[j].Value.ToString();
}
}
workbook.SaveAs(@"C:\Users\우정인\Desktop\out.xls",Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive,Type.Missing, Type.Missing, Type.Missing, Type.Missing);
app.Quit();