100分紧急求救!!!C#中操作EXCEL问题,在线等,有正确答案就结贴
Excel.ApplicationClass excel = new ApplicationClass();
Excel.Workbook book = null;
Excel.Worksheet sheet = null;
object ExcelValue = System.Reflection.Missing.Value;
book = excel.Workbooks.Open(FileName, ExcelValue, ExcelValue, ExcelValue, ExcelValue, ExcelValue,
ExcelValue, ExcelValue, ExcelValue, ExcelValue, ExcelValue, ExcelValue,ExcelValue,
ExcelValue, ExcelValue);
======================================================================================================
在打开的这个EXCEL中有个SHEET1是个模板
book.Sheets.Add(ExcelValue, ExcelValue, ExcelValue, ExcelValue);
在EXCEL中增加一个SHEET
请问:
1。我如何把原来那个SHEET的格式复制到新增的SHEET里?
2。新增的SHEET是插在前面的,我如何把新增的SHEET移动到最后?