1 Microsoft.Office.Interop.Excel.Application objApp = new Microsoft.Office.Interop.Excel.Application();//创建对象 2 Workbook objwork = objApp.Workbooks.Open("D:\rpt\快递单ces.xls",Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);//打开路劲为D: pt快递单ces.xls的excel模板 3 // Workbook objwork = objApp.Workbooks.Add(Type.Missing); //创建新的excel 4 Worksheet objSheet = (Worksheet)objwork.Worksheets[sheentName];//打开对应的工作表 5 Worksheet objsheet1 = (Worksheet)objwork.Worksheets["Sheet0"]; //把数据写入sheet0工作表 6 objSheet.Activate(); 7 objApp.Visible = true;//设置excel可见 8 objsheet1.Cells[1, 2] = tboNumber.Text;//给sheet1工作表的B1单元格赋值
1 Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();//实例化一个application对象 2 excelApp.Visible = true;//设置打开的excel为可见 3 Microsoft.Office.Interop.Excel.Workbook workbook = excelApp.Workbooks.Add(Missing.Value);//创建一个新的excel 4 Microsoft.Office.Interop.Excel.Worksheet sheent = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets[1];//获取excel第一个工作表 5 6 for (int i = 0; i < dataGridView1.Columns.Count; i++) 7 { 8 sheent.Cells[1, i + 1] = dataGridView1.Columns[i].HeaderText;//写入表头 9 } 10 for (int i = 0; i < dataGridView1.Rows.Count ; i++) 11 { 12 13 for (int j = 0; j < dataGridView1.Columns.Count; j++) 14 { 15 16 17 18 19 sheent.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString();//写入数据 20 21 22 23 } 24 } 25 Range range = sheent.Columns;//获取所有单元格 26 range.AutoFit();//设置单元格自适应高度和宽度