aspose.cell 实现通过excel模板导出具有多个sheet的excel

            //打开excel模板
            Workbook workbook = new Workbook("D:/1.xlsx");
            //打开设计器
            WorkbookDesigner designer = new WorkbookDesigner(workbook);
            //选择excel中的第一个sheet作为模板
            Worksheet worksheet = workbook.Worksheets[0];
            //copy模板并添加一个新的sheet
            int index = workbook.Worksheets.AddCopy(0);
            Worksheet destSheet = workbook.Worksheets[index];
            //设置单元格区域
            Range sourceRange = worksheet.Cells.MaxDisplayRange;
            //创建行数和列数与源工作表相同的区域
            Range destRange = destSheet.Cells.CreateRange(sourceRange.FirstRow, sourceRange.FirstColumn, sourceRange.RowCount, sourceRange.ColumnCount);
            //粘贴
            PasteOptions options = new PasteOptions();
            options.PasteType = PasteType.All;
            //从源工作表复制到目标工作表。
            destRange.Copy(sourceRange, options);
            //指定要修改的sheet
            designer.Process(index, true);
            //保存
            workbook.Save("D:/2.xlsx");