가. 언어유형/C#
Excel Export
LemonDory
2009. 1. 23. 14:41
Microsoft.Office.Interop.Excel.Application App; Microsoft.Office.Interop.Excel.Worksheet Worksheet; Microsoft.Office.Interop.Excel.Workbook Wbook; App = new Microsoft.Office.Interop.Excel.Application(); App.Visible = true; Wbook = (Microsoft.Office.Interop.Excel.Workbook)(App.Workbooks.Add(System.Reflection.Missing.Value)); Worksheet = Wbook.ActiveSheet; for (int i = 0; i < dataGridView.RowCount -1 ; i++) { Worksheet.Cells[1, i + 1] = dataGridView.Columns[i].HeaderText; }참고사항
Code Snippet public static void RunExcel() { Excel._Application xl = new Excel.ApplicationClass(); xl.Visible = true; Excel.Workbook wk = (Excel.Workbook)(xl.Workbooks.Add(System.Reflection.Missing.Value)); }