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:\rpt\快递单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();//设置单元格自适应高度和宽度
