Printable View
Hi Guys,
I am fairly new to prgramming MFC and i was just wandering if anyone knew/if its possible to send results from my app to excel.
I am running an app that gives different numbers as a result and i want to send this to excel so i can sort through the results but don't know how?
justy search this site for "excel automation". you'll get plenty of resultsQuote:
Originally posted by Ankoump
Hi Guys,
I am fairly new to prgramming MFC and i was just wandering if anyone knew/if its possible to send results from my app to excel.
I am running an app that gives different numbers as a result and i want to send this to excel so i can sort through the results but don't know how?
Do I really need to go in the automation process. I mean when I did console programming, all you need was to write to a .csv file and use the fout<< statement to send it there….
Is there no simlar way in MFC, I have searched but there is no relating answer..
ODBC can write to Excel too.
A CSV file is a type of Excel file. You can use it if you only write.
CSV is still available for MFC.
If you need to write to an XLS or do read/write, you will need
to use automation or ODBC.
Automation is simple (but tedious)
Did you think that because you were using MFC you couldn't use
the CSV file???
Use CStdioFile::WriteLine to generate a csv file, then launch the file in Excel with this:
where strFileName is the name of the csv file. This will use the association of the csv extension with Excel to open the file in Excel.Code:::ShellExecute(m_hWnd, _T("open"), strFileName, NULL, NULL, SW_SHOW);
This is a one way flow of data from your app to Excel. If you need anything more sophisticated, then Automation is your best bet.