1. 建立MFC工程
2. 操作Excel文件初始化:
- project->add class->MFC class from typelib (项目->添加类->Typelib中的MFC类)导入Excel.exe,一般都在C:/Program Files/Microsoft Office/Office15路径下(即选择你的office安装路径下的excel.exe加入)
- 选中以下几项_Application,_WorkSheet,_WorkBook,WorkSheets,WorkBooks,Range,然后导入;
- 导入后自动在工程中添加CApplication,CWorkSheet,CWorkBook,CWorkSheets,CWorkBooks,CRange这些类;
引入之后如果编译遇到错误,Not enough actual parameters for macro ''DialogBoxW''. 让人头疼!
解决方法是在CRange类中,
1 VARIANT DialogBox() 2 { 3 VARIANT result; 4 InvokeHelper(0xf5, DISPATCH_METHOD, VT_VARIANT,(void*)&result, NULL); 5 return result; 6 }
DialogBox()前面添加下划线变成_DialogBox(),解决了!