Using Excel From C++
-
Ok here is what I want to do: 1) load data into excel from C++ App 2) format cells and merge cells from C++ App 3) Print using excel directly from my C++ App I have found some articles that deal with C++ and Excel, but nothing that really deals with printing. Is it possible? If it isn't is there a way to call a macro and have the macro print the sheet? Now the kicker. My app will be distributed to many users that have different versions of excel. What is the best way to handle this? Is it as simple as making sure to not use functions that aren't present in earlier versions, or is it much more complicated than that. Any suggestions or advice? Thanks in advance. :-D *********************** Tony Fontenot Recreational Solutions tony@recsolutions.com ***********************
-
Ok here is what I want to do: 1) load data into excel from C++ App 2) format cells and merge cells from C++ App 3) Print using excel directly from my C++ App I have found some articles that deal with C++ and Excel, but nothing that really deals with printing. Is it possible? If it isn't is there a way to call a macro and have the macro print the sheet? Now the kicker. My app will be distributed to many users that have different versions of excel. What is the best way to handle this? Is it as simple as making sure to not use functions that aren't present in earlier versions, or is it much more complicated than that. Any suggestions or advice? Thanks in advance. :-D *********************** Tony Fontenot Recreational Solutions tony@recsolutions.com ***********************
Tony, You Have luck. I just sent to code project an article that explain all you want to know. I dont know when it will be shown . check your email - i sent the article directly to you. By. ;) Aizik Yair Software Engineer
-
Tony, You Have luck. I just sent to code project an article that explain all you want to know. I dont know when it will be shown . check your email - i sent the article directly to you. By. ;) Aizik Yair Software Engineer
Is this really possible to call printing of Excel Application?:confused:
-
Is this really possible to call printing of Excel Application?:confused:
Yes it is. and not just print but all the things you know with excel.. I suppose my article will be publish soon. :) Aizik Yair Software Engineer
-
Is this really possible to call printing of Excel Application?:confused:
AFAIK you can control Excel with automation. In the MSDN the automation of excel is written in VB but it also works in a similar way in VC. If you want to do it in VC you have to "#import" an dll with this interface. It creates the com-Interface with the names of the methods. And than code trough the dschungle. :~