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.

Improve this question
2
  • 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 Commented May 26, 2011 at 15:29
  • Here is an example, the top left portion of the excel file has ... Requested By : <<name will be filled here>>, Customer Name : <<name here>>, Pick up mode <<mode here>>, then below is a table of products that will need to be populated including fields like product code, name, desc, cost, margin, price. Commented May 26, 2011 at 15:36

1 Answer 1

Reset to default
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!

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.