在 C# 中使用 Excel 中的模板
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1088539/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Using templates in excel with C#
提问by
As part of the c# program that I am producing I need to generate 1 workbook containing; 2 different worksheets and a 3rd that could be produced any number of times, what is the most effective way of doing this? I have looked into using templates although I am unsure how to repeat certain worksheets whilst only displaying others once. Any help or advice would be appreciated.
作为我正在生成的 c# 程序的一部分，我需要生成 1 个工作簿，其中包含；2 个不同的工作表和第 3 个可以生成任意次数的工作表，最有效的方法是什么？我已经研究过使用模板，尽管我不确定如何重复某些工作表，同时只显示其他工作表一次。任何帮助或建议将不胜感激。
回答by gjutras
A simple way is to make a hands off template example workbook with the three worksheets. Then make a copy of it. Open both and re-copy worksheet number 3 on to the working workbook as a new worksheet as needed.
一种简单的方法是使用三个工作表制作一个免提模板示例工作簿。然后复制一份。打开这两个工作表并根据需要将第 3 号工作表作为新工作表重新复制到工作工作簿。
In response to the comment:
回应评论：
There are a couple of excel engines in a .net component products our there like spreadsheet gear or aspose cells. But if your application is a windows form based and where the application is guaranteed to run has office you can use office automation. You can't legally use office automation on a web server, but it is just as possible on a web server as on a client desktop. I've used the aspose cells and it's very easy to work with and very capable and a little less expensive than spreadsheet gear, but spreadsheet gear does also have a good reputation. Both of those components have very good documentation on how to do anything with excel. But if you have excel and want to use office automation, be sure to look for example code on the web on how to properly close excel from c# or vb.net. There are some tricks to getting it to close properly.
.net 组件产品中有几个 excel 引擎，例如电子表格设备或 aspose 单元格。但是，如果您的应用程序是基于 Windows 窗体并且保证应用程序运行的地方有办公室，则您可以使用办公自动化。您不能在 Web 服务器上合法地使用办公自动化，但在 Web 服务器上和在客户端桌面上一样可能。我使用过 aspose 单元格，它非常易于使用且功能强大且比电子表格设备便宜一点，但电子表格设备也享有盛誉。这两个组件都有关于如何使用 excel 做任何事情的非常好的文档。但是，如果您有 excel 并且想要使用办公自动化，请务必在网上查找有关如何从 c# 或 vb.net 正确关闭 excel 的示例代码。
回答by Joe Erickson
SpreadsheetGear for .NEThas ISheet.CopyAfter / CopyBefore methods which enable you to copy an entire worksheet within a workbook or between workbooks.
SpreadsheetGear for .NET具有 ISheet.CopyAfter / CopyBefore 方法，使您能够在工作簿内或工作簿之间复制整个工作表。
You can see an example of duplicating a single worksheet multiple times in the Worksheet with Chart to Multiple Worksheets with Chartssample on the SpreadsheetGear / Excel Reporting Samples page here.
您可以在此处的 SpreadsheetGear/Excel 报告示例页面上的带有图表的工作表到带有图表的多个工作表示例中看到多次复制单个工作表的示例。
Disclaimer: I own SpreadsheetGear LLC
免责声明：我拥有 SpreadsheetGear LLC
回答by SwDevMan81
I have done this before with templates. I would create a template xls with the first two worksheets that you don't want changed, then add a 3rd worksheet that you could copy to the end of the workbook (as you need more worksheets).
我以前用模板做过这个。我将使用您不想更改的前两个工作表创建一个模板 xls，然后添加第三个工作表，您可以将其复制到工作簿的末尾（因为您需要更多工作表）。
If you know ahead of time how many of the 3rd worksheet you need, then you can copy them to the end and delete the template 3rd slot.
如果您提前知道需要多少个第三个工作表，那么您可以将它们复制到最后并删除模板第三个插槽。
ExcelTemplateManager t = new ExcelTemplateManager(template_path, log_path);
t.CopyWorksheetToEnd(3);
t.CopyWorksheetToEnd(3);
t.RemoveAtIndexWorksheet(3);
t.SetSomeValue(3);
t.SetSomeValue(4);
t.Close();
If you don't know, then keep the template around to copy it to the end as needed, then when you are done, just remove the 3rd worksheet template.
如果您不知道，请保留模板以根据需要将其复制到最后，然后当您完成时，只需删除第三个工作表模板。
ExcelTemplateManager t = new ExcelTemplateManager(template_path, log_path);
t.CopyWorksheetToEnd(3);
t.SetSomeValue(4);
t.CopyWorksheetToEnd(3);
t.SetSomeValue(5);
t.RemoveAtIndexWorksheet(3);
t.Close();
I used the Microsoft.Office.Interop.Excel dll to create my ExcelTemplateManger class. The basic idea is to create a copy of the template excel file, and work off the copy. Let me know if you need help setting that part up, but it should be too bad.
我使用 Microsoft.Office.Interop.Excel dll 创建我的 ExcelTemplateManger 类。基本思想是创建模板 excel 文件的副本，然后处理该副本。如果您需要帮助设置该部分，请告诉我，但这应该太糟糕了。
