Open Excel in VC++ and write data
I have a program which retrieves data from a SQL server. I want to write this data to an excel sheet and draw graphs using this data.
As of now I wrote the output of my program in csv format, so after I run the program it creates an excel file.
But how can I make my program open an excel sheet, write data to it, generate the graphs.
Basically my output should be an excel file with data and graphs in it.
Any kind of help is appreciated.
Thanks.
Re: Open Excel in VC++ and write data
Hello, i want to ask if anybody knows the way to use in C++ the DISPATCH_METHOD with AUTOWRAP for the function "ChartWizard" with it's possible to put the tittle in a excel's chart.
It would be something like that
AutoWrap(DISPATCH_METHOD, &result, pXlChart, L"ChartWizard",...)
but i don't know what's the variables and how to specify the tittle, x column tittle, y column tittle.
I will be very grateful with any kind of help
Re: Open Excel in VC++ and write data
I should be able to cook up an example about 12 hours from now.
Re: Open Excel in VC++ and write data