Replacing content in Word/Excel document

[pxb]

There is a requirement to mass replace content data in word/excel documents,
we plan to attach XML Schema to the documents so we update the XML fields
instead of specific cell or bookmarks.

But since this is going to be a server side solution, using VSTO seems to be
having performance concerns because it actually works through instances of
the office application.

But since they are running Office 2003, I don't think they have the newer
Package .NET namespaces for Office 2007 to manipulate at XML level, any
advice on how to achieve the required function?

 

[Cindy M.]

Hi =?Utf-8?B?cHhi?=,

There is a requirement to mass replace content data in word/excel documents,
we plan to attach XML Schema to the documents so we update the XML fields
instead of specific cell or bookmarks.

But since this is going to be a server side solution, using VSTO seems to be
having performance concerns because it actually works through instances of
the office application.

But since they are running Office 2003, I don't think they have the newer
Package .NET namespaces for Office 2007 to manipulate at XML level, any
advice on how to achieve the required function?

If the documents are saved in the WordProcessingML file format (the Word 2003
XML file format) then you can access them using any XML parsing tool without
needing to open them in Word.

If you want the documents in the *.doc file format, then VSTO would be a viable
approach. The XML Nodes can be linked to the VSTO data cache, then the content
accessed via VSTO's ServerDocument feature. No need to have Office installed on
the server, no major performance issues. This is your starting point in the
MSDN documentation: http://msdn.microsoft.com/en-us/library/7ds6bx53.aspx

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail