word & XML

[motupal]

Dear All,

I am working in ASP.Net, and using VB.Net.

I have the XML file and I need to write the XML data to a
word document, the report may run into 100s of pages,
hence I recoken, that a template has to be create on the
fly and the Mailmerge fields needs to be updated.

But I dont know how to go about, any sample code, advise
will be greatly appreciated.

Thanks in advance.

Regards
motupal

 

[Peter Jamieson]

First, you should see

INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/default.aspx?kbid=257757:

I have the XML file and I need to write the XML data to a
word document, the report may run into 100s of pages,
hence I recoken, that a template has to be create on the
fly and the Mailmerge fields needs to be updated.

We don't really have much to go on here. I would have lots of questions,
e.g.
a. How complex is the XML?
b. Does the output have to be in Word format? Instead, could you for
example import the XML data into Access or SQL Server and use standard
reporting tools to generate useful output?
c. If the output has to be in Word format,
- Do you have Word 2003? If so, could you use its new XML features to do
what you need withut a merge?
- Does it have to be in Word .doc format? Could you just use XSLT to
transform your XML into HTML that could be opened in Word (and perhaps have
a few headers attached or some such)
- Why are you thinking in terms of generating a template first? Is it
because you need to determine the content and layout on the basis of what
you find in the XML file?

And so on...

 

[Peter Jamieson]

I meant to mention that the other thing you need to consider is that Word
(even Word 2003) does not have a native method for using XML format data as
the data source for a merge.

 

[Guest]

Hi
Thanks for your time, the XML is very simple, nothing
complex, I think I just need to Apply XSLT and open it in
the word format.

I really appreciate for taking time to reply in detail.

Yes I am using the word 2003 and I recoken that the merge
would be automatic.

Thanks againg for your help.

Kind Regards
pmotupal