如何填写使用ASP.NET，VB或C＃中的Excel模板？ [英] How to fill an excel template using ASP.NET, VB or C#?

问题描述

我已经手动填充一个Excel文件，现在需要使用ASP.NET，VB或C＃进行自动填充。我一直在四处寻找，并发现了如何导出gridview的例子和数据到excel表，但无论如何不能保持原有模板的格式。我最近使用填充合并域...没有Excel中也有类似的任何一个Word文档？我可以打破文件下来到XML和使用，作为一个模板？任何想法？

I have a an excel file that has been manually populated, and now needs to be automatically populated using ASP.NET, vb or c#. I've been looking around, and have found examples on how to export a gridview, and data to excel sheet, but not anyway to maintain the format of the original template. I've recently populated a word document using merge fields... does excel have anything similar? Could I break the file down into XML and use that as a template? Any ideas?

感谢。

推荐答案

办公室作家从软 aritsans会做正是这一点。再加上很多是非常强大的，我已经用它在过去有很大的影响。

Office Writer from soft aritsans will do exactly this. Plus a lot more it is extremely powerful and I have used it to great effect in the past.

不利​​的一面是，它是相当昂贵的！

The down side is that it is rather expensive!

这篇关于如何填写使用ASP.NET，VB或C＃中的Excel模板？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！