1

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.

Michael Armstrong
  • 371
  • 1
  • 5
  • 16
  • Are there particular cells that need to be populated or is the text free from with data needing to be inserted inside of cell data – rerun May 26 '11 at 15:29
  • Here is an example, the top left portion of the excel file has ... Requested By : <>, Customer Name : <>, Pick up mode <>, then below is a table of products that will need to be populated including fields like product code, name, desc, cost, margin, price. – Michael Armstrong May 26 '11 at 15:36

1 Answers1

1

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!

Jon P
  • 19,442
  • 8
  • 49
  • 72