How to run Excel from C++ code ?

[sheila11]

Hi all,

My C++ program saves its output data to a text file. I have an Excel file that can read the data and display it in the form of a chart.

My problem is: how can I call the excel sheet to run from my C++ code?

Please help.

Thanks,
Sheila

 

[vgg]

Hi sheila,

You need to write a batch file say excel.bat
Assume you have excel.exe in C:\Program Files\Microsoft Office\Office and your excel program is myspreadheet.xls

Add this path to the PATH in the environment variable
C:\Program Files\Microsoft Office\Office

In that include the following commands(an example)

//excel.bat
excel C:\spreadheets\myspreadsheet.xls


//excel.cpp

in main()
{
int i = system("C:/excel.bat"
return 0;
}

This should answer your question.

Regards,
vgg