VS2010 EXCEL2010 表格操作的编程实现

参考：

http://blog.csdn.net/wxfy1977/article/details/3847450(另外一种实现方式，数据库方式)

http://blog.csdn.net/evkj2013/article/details/10186199

http://www.cnblogs.com/xianyunhe/archive/2011/09/25/2190485.html

http://blog.csdn.net/chumoyangguang/article/details/8872944

http://retype.wenku.baidu.com/view/e9b4e3edb8f67c1cfad6b860.html

http://blog.csdn.net/fullsail/article/details/4067416

http://wenku.baidu.com/view/f233445dbe23482fb4da4cf7.html

http://www.cnblogs.com/tgyf/p/3735001.html

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操作