Using MFC for excel connection
You may manually import Excel OLE to replace CApplication.h, CRange.h, CWorkBook.h, CWorkBooks.h and CWorkssheets.h from Excel.exe installed on your computer, but be aware of the compatible issues.
These files are exported from Excel 2016 and made some modifications, but apps uses this library are compatible with Microsoft Excel 2010, 2013, 2016, 2019 (Tested), and WPS suite (not fully tested, but available), that means, if target computer installed Microsoft Excel or Kingsoft WPS, that will do
We provided a piece of demo code (UNICODE version) at the bottom of the MFCExcel.cpp, and code in header file are documented.
Have fun!
