Server-Side Access To Worksheet Data in Word 2003 Document

[jbauer]

I have a console .NET application that runs under Task Scheduler. The
application reads data from Worksheets embedded in Word 2003 documents and
saves the data to a database. The console application was initially designed
using Word and Excel Interop. However, we need to move the application to a
server and cannot have Word or Excel on the server.

Is VSTO a possible solution? Does VSTO require Word/Excel installed on
server?

Thanks in advance for suggestions.

 

[Cindy M.]

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

I have a console .NET application that runs under Task Scheduler. The
application reads data from Worksheets embedded in Word 2003 documents and
saves the data to a database. The console application was initially designed
using Word and Excel Interop. However, we need to move the application to a
server and cannot have Word or Excel on the server.

Is VSTO a possible solution? Does VSTO require Word/Excel installed on
server?

Mmmm. VSTO won't be able to read the content from embedded Excel sheets while
the document is closed. Your VSTO solution would have to extract the information
from the embedded sheets (much like your current app is doing, as far as the
code goes) then write that into the VSTO data cache. You could use the
DocumentBeforeClose event for that, for example. Once the data is in the data
cache, then your Server-side app can extract it, using the ServerDocument
feature.

You might want to follow up on this in the VSTO forum, if you want to discuss it
in more detail.
http://social.msdn.microsoft.com/Forums/en-US/vsto/threads/?page=1

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