Thread overview  


January 04, 2005 creating a 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; } george 
January 11, 2005 Re: creating a excel graph with C++  

 
Posted in reply to george_y  If you just save a tab delimited file file.xls you can then execute
start file.xls
and it will be opened in excel
chris
george_y@libero.it wrote:
> 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;
>
> }
>
> george

April 04, 2019 Re: creating a excel graph with C++  

 
Posted in reply to george_y  On Tuesday, 4 January 2005 at 00:39:23 UTC, george_y wrote:
> 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;
>
> }
>
> george
The easiest way to export/import data from excel in your .net project is by using Excel library like ZETEXCEL.

Copyright © 19992021 by the D Language Foundation