Re: VSTO can replace COM automation?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris Kunicki (chris_at_officezealot.com)
Date: 12/16/04 

Date: Wed, 15 Dec 2004 23:56:52 -0600

VSTO 2003 can't do this.

VSTO 2005 can do this. Though it is at a Beta 1 point right now. While its
never suggested to install beta on a production server, maybe your
environment would allow for a pilot deployment.

Anyhow, VSTO 2005 allows you to open an Excel workbook on the server and
push and pull data out of it without requiring Excel on the server. All you
need is to install their server component on the server. (I'm not sure if
its available as a standalone install yet for beta 1, but it is a part of
the VS2005 beta 1 install).

There are also 3rd party products that address excel on the server. 

-- 
Chris Kunicki
MVP Office Developer
My Blog: http://blogs.officezealot.com/chris
Office Portal: http://www.OfficeZealot.com
On 12/15/04 10:07 AM, in article ulEOv9r4EHA.2568@TK2MSFTNGP10.phx.gbl,
"cpnet" <cpnet@nospam.nospam> wrote:
> I'd like to be able to do the same thing on a server, but since you can't
> install Excel on a server, my current use of Excel Automation won't work.
> It sort of sounds like VSTO may be able to help me here, but I'm not 100%
> sure.  I don't want any worksheets I produce via VSTO to be associated with
> any assemblies.  I just want to be able to produce plain .xls workbooks that
> contain pivot tables and charts, that users could open in whatever version
> of Excel ('97 and up) that they have.  Can I do this with VSTO?
Quantcast