参考：

(另外一种实现方式，数据库方式)

http://www.cnblogs.com/fullsail/archive/2012/12/28/2837952.html

http://blog.csdn.net/gyssoft/article/details/1592104

---------------------------------------------------------------------------------------------

1.导入Excel接口类

Project->Class Wizard->Add Class->MFC Class From TypeLib

 

导入后文件结构：

 

此时，直接编译会报错。

 

2.修改编译错误

①将文件中CApplication.h

#import "C:\\Program Files\\Microsoft Office\\Office14\\EXCEL.EXE" no_namespace

替换为

#import "C:\\Program Files\\Common Files\\Microsoft Shared\\OFFICE14\\MSO.DLL" \

    rename("RGB", "MSORGB") \

    rename("DocumentProperties", "MSODocumentProperties")

using namespace Office;

#import "C:\\Program Files\\Common Files\\Microsoft Shared\\VBA\\VBA6\\VBE6EXT.OLB"

 

using namespace VBIDE;

#import "C:\\Program Files\\Microsoft Office\\Office14\\EXCEL.EXE" \

    rename("DialogBox", "ExcelDialogBox") \

    rename("RGB", "ExcelRGB") \

    rename("CopyFile", "ExcelCopyFile") \

    rename("ReplaceText", "ExcelReplaceText") \

    no_auto_exclude

using namespace Excel;

 

②删除CRange.h，CWorkbook.h，CWorkbooks.h，CWorksheet.h，CWorksheets.h中下面内容：

#import "C:\\Program Files\\Microsoft Office\\Office14\\EXCEL.EXE" no_namespace

 

3.Excel操作