c# 中EXCEL 带格式复制

 

找到 模板

wk = app.Workbooks.Open(clsConnect.get_dir() + @"\加工路线单\26B.xlsx");

sh = wk.Worksheets["模板"];

===========================================

  rng1 = sh.get_Range("A1:S26", Type.Missing);

newsh.Name = "路线单-"+mycount.ToString();
rng2 = newsh.get_Range("A1:S26", Type.Missing);

rng2.PasteSpecial(Microsoft.Office.Interop.Excel.XlPasteType.xlPasteAll, Microsoft.Office.Interop.Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone, System.Type.Missing, System.Type.Missing);

 

以上就是带格式拷贝