整体思路:
http://wenku.baidu.com/view/d7383548767f5acfa1c7cd30
一些细节:
对字体、边框、线条等操作引用Excel的枚举类型数据报错:提示没定义
的解决方案
打开头文件,把
#import "D:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE" no_namespace 一行改成:
#import "C:\\Program Files\\Common Files\\Microsoft Shared\\OFFICE11\\MSO.DLL" \
rename("RGB", "MSORGB") \
rename("DocumentProperties", "MSODocumentProperties") \
rename("SearchPath","MsoSearchPath") \
rename_namespace("Office")
using namespace Office;
#import "C:\\Program Files\\Common Files\\Microsoft Shared\\VBA\\VBA6\\VBE6EXT.OLB"
using namespace VBIDE;
#import "C:\\Program Files\\Microsoft Office\\Office11\\EXCEL.EXE" \
rename("DialogBox", "ExcelDialogBox") \
rename("RGB","ExcelRGB") \
rename("CopyFile", "ExcelCopyFile") \
rename("ReplaceText", "ExcelReplaceText") \
no_auto_exclude
using namespace Excel;
#undef ExitWindows
#undef DialogBox
#undef RGB
注意“\”字符后面不能放空格
参考:
使用MFC操作EXCEL文件:
http://blog.csdn.net/shuilan0066/article/details/7936336
C++操作Excel学习笔记(三):
http://blog.sina.com.cn/s/blog_945492f401012njr.html
转载请注明作者和出处:http://blog.csdn.net/holamirai,未经允许请勿用于商业用途