Automating Office Apps (Excel) out of C/C++

[drdad5727]

I need to automate Excel from C/C++ code. All the documentation I can find is for writing Excel AddIns. That's not really what I'm trying to do.

What I want to do is start Excel (the equivalent of

CREATEOBJECT("Excel.Application")

in VB) and then do stuff to it: create a workbook, populate it with data, etc.

Now I'd think that VB CREATEOBJECT would translate into a COM CoCreateInstance, but I can't find any CLSID, etc. to use.

Has anybody done something like this?

 

[timmay3141]

Well...

If all you want to do is create a spreadsheet and populate it with data, it isn't very difficult. You can create a file using \n and tabs to separate rows and columns, and save it as a .xls, then use ShellExecute to launch it in Excel. If you need to do more than that, hopefully someone else knows more than me.

 

[ArkM]

See, for example:

http://www.kbalertz.com/kb_141759.aspx

then download xlclient.exe from MS, unpack it (xlclient -d) and see how control Excel from C++...