언어/C#

데이터그리드뷰에 있는 데이터를 excel로 내보내기

앨리스.W 2021. 2. 4. 18:46

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();

반응형