VC++60中C++打开ExcelMFC教学文案

1、Good is good, but better carries it.精益求精，善益求善。VC+60中C+打开ExcelMFC-VS2008中C+打开Excel（MFC）第一步：建立project选择C+下的MFCAppWizard选择基本对话框，中文。之后点击finish第二步：导入EXCEL头文件Ctrl+W-Automation-AddClass-EXCEL.exe后，点击打开，进入ConfirmClasses对话框下，(我用的是MicrosoftOffice2003)将下列Class添加进来。点击OK确定类已添加：并在TestExcelDlg.cpp开始添加：#includeexce

2、l.h第三步：打开COM口添加AfxOleInit();第四步：建一个Button按钮选择Toolbox中的Button在TExcel.rc的IDD_TESTEXCEL_DIALOG中点击，建立如上图的Button按钮将属性中的标题修改为“创建报表”第五步：为Button按钮编写程序双击“打开Excel”在/TODO:Addyourcontrolnotificationhandlercodehere后添加如下程序：_ApplicationobjApp;/判断是否存在EXCEL应用程序WorkbooksobjBooks;_WorkbookobjBook;WorksheetsobjSheets;_

3、WorksheetobjSheet;RangeobjRange,usedRange;/单元格获取VARIANTret;/Fontfont;objApp.CreateDispatch(Excel.Application);/判断是否存在EXCEL应用程序COleVariantVOptional(long)DISP_E_PARAMNOTFOUND,VT_ERROR);objApp.SetVisible(TRUE);objApp.SetUserControl(TRUE);LPDISPATCHpwkbooks=objApp.GetWorkbooks();objBooks.AttachDispatch(

4、pwkbooks,TRUE);charcurrentprogrampathMAX_PATH;objBooks=objApp.GetWorkbooks();/objBook=objBooks.Add(VOptional);objSheets=objBook.GetSheets();CStringstr;str=test.xls;objBooks.Open(ExcelName,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VO

5、ptional,VOptional,VOptional);/objRange.SetValue();str=A1;objSheet=objSheets.GetItem(COleVariant(short)1);objRange=objSheet.GetRange(COleVariant(str),COleVariant(str);objRange.SetValue2(COleVariant(helloexcel);font=objRange.GetFont();font.SetBold(COleVariant(short)TRUE);objRange=objSheet.GetRange(COleVariant(C4),COleVariant(B4);objRange.SetFormula(COleVariant(=RAND()*100000);objRange.SetNumberForm