generating an excel graph with C++

[Guest]

I need some help to generate with a C++ programm a file in Excel format
(or at least in a way that all the information in it can be read by
Excel) containing a graph with the data I choose. As an example I
include a simple script that generates an output file with two columns
of integers and I` d like to add in it a graph in the same file so that
when you open the output file aaa.xls with Excel both the numrical data
and graph are present.

Thanks,
George

#include <fstream>

using namespace std;

int main()

{

double a[10]= {1,2,3,4,5,6,7,8,9,10};

double b[10]= {11,12,13,14,15,16,17,18,19,20};

ofstream fout;

fout.open("aaa.xls");

int n= 0;

for(n= 0; n< 10; n++)

{

fout<< a[n]<<"\t"<<b[n]<<endl;

}

fout.close();

return 0;

 

[Fredrik Wahlgren]

I need some help to generate with a C++ programm a file in Excel format
(or at least in a way that all the information in it can be read by
Excel) containing a graph with the data I choose. As an example I
include a simple script that generates an output file with two columns
of integers and I` d like to add in it a graph in the same file so that
when you open the output file aaa.xls with Excel both the numrical data
and graph are present.

Thanks,
George

You need to use COM or some 3rd party library that can create Excel files.
Your best bet is probably to search for VB code that does this. Here are a
few links I found elsewhere:

Articles on Office 2003 & code behind (VSTO)
http://msdn.microsoft.com/library/d...en-us/odc_vsto2003_tr/html/odc_VSTMGBLab6.asp
http://msdn.microsoft.com/vstudio/o...sto2003_ta/html/vstointro.asp#vstointro_link2
http://www.developer.com/net/cplus/article.php/3289051
http://www.officezealot.com/Office2003Zone/vsto.aspx
http://www.c-sharpcorner.com/OfficeNet.asp
http://msdn.microsoft.com/vstudio/office/default.aspx (Good ones)
http://msdn.microsoft.com/library/d...en-us/odc_vsto2003_tr/html/odc_VSTMGBLab6.asp
http://msdn.microsoft.com/vstudio/o...brary/en-us/odc_vsto2003_ta/html/excelobj.asp
http://msdn.microsoft.com/vstudio/o...en-us/odc_vsto2003_ta/html/odc_vstsqlexcl.asp
http://support.microsoft.com/?kbid=306572

/ Fredrik