Solved

Excel Automation

Posted on 2000-02-29
4
151 Views
Last Modified: 2013-11-20
I have some problem interfacing Excel in VC application.   The
requirement in my project is to create and manipulate Excel files
without bringing Excel up.  Using OLE dispatch interface I have written
a DLL,  exposing a class, that supports my application for doing the
same.  But the problem is,  it sets a limitation of having Excel
installed on the PCs where I am running my application.   I don't want
to expect the end user who is using my application, to have Excel
installed in his PC.  My exposed interfaces to create, read or write to
the Excel file does not work if the target PC does not have Excel
installed.
0
Comment
Question by:SunilRH
  • 2
  • 2
4 Comments
 

Author Comment

by:SunilRH
Comment Utility
Thanx
0
 
LVL 7

Accepted Solution

by:
tchalkov earned 100 total points
Comment Utility
If you use Excel OLE objects  to work with Excel files then you MUST have installed excel on client machines.

If this is not an option you can try to manage excel files trhough ODBC, DAO or ADO. However you will not be able to use all capabilities which Excel objects offer
0
 

Author Comment

by:SunilRH
Comment Utility
Hello tchalkov,
 But what my thinking is if you find the dependencies of excel and then  include those DLLs may be it will work. but if so how do i find what is excel have dependencies.

thanx
Sunil
0
 
LVL 7

Expert Comment

by:tchalkov
Comment Utility
I'm not sure it will be easy to find these dependencies. But even if you can find them, it is not legal to redistribute them to your clients. It is very likely that you will need the excel.exe also.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

If you use Adobe Reader X it is possible you can't open OLE PDF documents in the standard. The reason is the 'save box mode' in adobe reader X. Many people think the protected Mode of adobe reader x is only to stop the write access. But this fe…
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now