automating excel without installing excel

Z

zhang minjie

Hi!

I want to embed an excel object in my MFC application, and I don't have
excel installed. Is there a workaround?

I heard about using COM, but I haven't found any example yet.

Thanks in advance!
 
C

Cindy M -WordMVP-

Hi Zhang,
I want to embed an excel object in my MFC application, and I don't have
excel installed. Is there a workaround?
No. When you embed a COM application in another interface (I assume we're
talking OLE here, anyway), you still need the "server application", and
that means Excel, installed and correct registered.

If you just want to pick up the data, you'd need to have the JET ODBC
driver installed, then you could use ODBC. Or that plus the Jet OLE DB
provider (that provider works over the ODBC driver). In this case, Excel
is not required.

Or, if we're talking Excel 2003, an Excel file can be saved as XML and you
can use the usual XML tools to pick up data from, and write data to the
file.

In either case, with the two approaches above, you'd need to design the
interface (or use a third-party tool) to display the data, since you can't
use Excel's if it's not installed.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top