引用Microsoft.Office.Interop.Excel.dll操作Excel常用方法

  Workbooks workbooks = Excel.Application.Workbooks;_Workbook workbook = workbooks.Add(tempFile); //加载模板文件Sheets sheets = workbook.Worksheets;_Worksheet worksheet = (_Worksheet)sheets.get_Item(1); //添加sheetsheets.Add(Type.Missing)//复制worksheetworksheet.Copy(Type.Missing,worksheet)//复制RangRang r = worksheet.get_Rang(cell1,cell2);r.Copy(Type.Missing)//粘贴RangRang r2 = worksheet.get_Rang(cell1,cell2);r2.PasteSpecial();