Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel Automation

Posted on 2000-02-29
4
Medium Priority
?
203 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 

Author Comment

by:SunilRH
ID: 2568950
Thanx
0
 
LVL 7

Accepted Solution

by:
tchalkov earned 200 total points
ID: 2569125
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
ID: 2571485
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
ID: 2571882
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I'll describe -- and show pictures of -- some of the significant additions that have been made available to programmers in the MFC Feature Pack for Visual C++ 2008.  These same feature are in the MFC libraries that come with Visual …
Introduction: Database storage, where is the exe actually on the disc? Playing a game selected randomly (how to generate random numbers).  Error trapping with try..catch to help the code run even if something goes wrong. Continuing from the seve…
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.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

718 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