ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   generating an excel graph with C++ (https://www.excelbanter.com/excel-programming/320074-generating-excel-graph-c.html)

George

generating an excel graph with C++
 
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

generating an excel graph with C++
 

"george" wrote in message
...
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 elsewhe

Articles on Office 2003 & code behind (VSTO)
http://msdn.microsoft.com/library/de...VSTMGBLab6.asp
http://msdn.microsoft.com/vstudio/of...stointro_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/de...VSTMGBLab6.asp
http://msdn.microsoft.com/vstudio/of...l/excelobj.asp
http://msdn.microsoft.com/vstudio/of...vstsqlexcl.asp
http://support.microsoft.com/?kbid=306572

/ Fredrik




All times are GMT +1. The time now is 01:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com