CODEWITHSUNDEEP
asp.netvb.netexcelfillexcel-template
Michael Armstrong
Michael Armstrong

Reputation: 381

How to fill an excel template using ASP.NET, VB or C#?

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?

Thanks.

Upvotes: 1

Views: 2550

Answers (1)

Jon P
Jon P

Reputation: 19797

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!

Upvotes: 1

Related Questions