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

1、Good is good, but better carries it.精益求精，善益求善。VS2008中C+打開ExcelMFC-VS2008中C+打開Excel（MFC）第一步：建立project選擇C+下的MFCApplication選擇dialogbased，中文。之后點擊finish第二步：導(dǎo)入EXCEL頭文件選擇Project-AddClass-MFCClassFromTypelib后，點擊Add，進(jìn)入MFCClassFromTypelibWizard對話框下，選擇MicrosoftExcel11.0ObjectLibrary(我用的是MicrosoftOffice2003)將上圖

2、中Class添加進(jìn)來。點擊finish并在TExcel.cpp開始添加：#includeCRange.h#includeCSheets.h#includeCWorkbook.h#includeCWorkbooks.h#includeCApplication.h#includeCWorksheet.h#includeCWorksheets.h在每一個添加進(jìn)來的頭文件中去掉#importC:ProgramFilesMicrosoftOfficeOFFICE11EXCEL.EXEno_namespace第三步：打開COM口添加AfxOleInit();第四步：建一個Button按鈕選擇Toolbox

3、中的Button在TExcel.rc的IDD_TEXCEL_DIALOG中點擊，建立如上圖的Button按鈕將屬性中的Caption修改為“打開Excel”第五步：為Button按鈕編寫程序雙擊“打開Excel”在/TODO:Addyourcontrolnotificationhandlercodehere后添加如下程序：CApplicationobjApp;/判斷是否存在EXCEL應(yīng)用程序CWorkbooksobjBooks;CWorkbookobjBook;CWorksheetsobjSheets;CWorksheetobjSheet;CRangeobjRange,usedRange;/單

4、元格獲取VARIANTret;objApp.CreateDispatch(_T(Excel.Application);/判斷是否存在EXCEL應(yīng)用程序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();第六步：