Working with Excel in MFC

• Download source code - 68.3 KB

Using the Code

A few coders asked me to share my developed COlezAutomation class which is taken from here, because I developed a bit these classes. So, I was thinking of put up here a small example of how you can use these Excel classes to achieve a chart via OleAutomation, with more than one series. Of course, you can do any other operation with this automation, such as exporting, importing, working with formulas, working with worksheets, and so on. Now I show here a charting operation.

The code is pretty simple and self explanatory, CChartFilterDlg has a CXLEzAutomation pointer which is a wrapper over CXLAutomation object. So, after testing whether Excel is properly installed, CXLEzAutomation pointer is doing remotely needed CXLAutomation operation for charting.

Also, I put a small example of how to convert office files (doc/xls/ppt) into pdf. You can do it from File->Conver File To Pdf item. If the conversion is done successfully, you'll get a statusbar message about that.

Enjoy it!

History

• 9^th April, 2013: Initial version
• 2^nd December, 2015: Source code updated
• 7th September 2021: Added 'Convert to PDF' feature