VS2008中C++打开ExcelMFC教程文件

1、Good is good, but better carries it.精益求精，善益求善。VS2008中C+打开ExcelMFC-VS2008中C+打开Excel（MFC）第一步：建立project选择C+下的MFCApplication选择dialogbased，中文。之后点击finish第二步：导入EXCEL头文件选择Project-AddClass-MFCClassFromTypelib后，点击Add，进入MFCClassFromTypelibWizard对话框下，选择MicrosoftExcel11.0ObjectLibrary(我用的是MicrosoftOffice2003)将上图

2、中Class添加进来。点击finish并在TExcel.cpp开始添加：#includeCRange.h#includeCSheets.h#includeCWorkbook.h#includeCWorkbooks.h#includeCApplication.h#includeCWorksheet.h#includeCWorksheets.h在每一个添加进来的头文件中去掉#importC:ProgramFilesMicrosoftOfficeOFFICE11EXCEL.EXEno_namespace第三步：打开COM口添加AfxOleInit();第四步：建一个Button按钮选择Toolbox

3、中的Button在TExcel.rc的IDD_TEXCEL_DIALOG中点击，建立如上图的Button按钮将属性中的Caption修改为“打开Excel”第五步：为Button按钮编写程序双击“打开Excel”在/TODO:Addyourcontrolnotificationhandlercodehere后添加如下程序：CApplicationobjApp;/判断是否存在EXCEL应用程序CWorkbooksobjBooks;CWorkbookobjBook;CWorksheetsobjSheets;CWorksheetobjSheet;CRangeobjRange,usedRange;/单

4、元格获取VARIANTret;objApp.CreateDispatch(_T(Excel.Application);/判断是否存在EXCEL应用程序COleVariantVOptional(long)DISP_E_PARAMNOTFOUND,VT_ERROR);objApp.put_Visible(TRUE);objApp.put_UserControl(TRUE);LPDISPATCHpwkbooks=objApp.get_Workbooks();objBooks.AttachDispatch(pwkbooks,TRUE);charcurrentprogrampathMAX_PATH;ob

5、jBooks=objApp.get_Workbooks();objBook=objBooks.Add(VOptional);objSheets=objBook.get_Sheets();CStringstr;str=A1;objSheet=objSheets.get_Item(COleVariant(short)1);objRange=objSheet.get_Range(COleVariant(str),COleVariant(str);objRange=objSheet.get_Range(COleVariant(_T(C4),COleVariant(_T(B4);objRange.put_Formula(COleVariant(_T(=RAND()*100000);objRange.put_NumberFormat(COleVariant(_T($0.00);usedRange=objRange.get_EntireColumn();usedRange.AutoFit();第六步：