Excel Automation

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
Who is Participating?
tchalkovConnect With a Mentor Commented:
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
SunilRHAuthor Commented:
SunilRHAuthor Commented:
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.

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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.