1、VS2008中C+打開Excel（MFC）第一步：建立project選擇C+下的MFC AppWizard選擇基本對話框，中文。之后點擊finish第二步：導入EXCEL頭文件Ctrl+W-Automation-Add Class-EXCEL.exe后，點擊打開，進入Confirm Classes對話框下， (我用的是Microsoft Office2003)將下列Class添加進來。點擊OK確定類已添加：并在TestExcelDlg.cpp開始添加：#include excel.h第三步：打開COM口添加AfxOleInit();第四步：建一個Button按鈕選擇Toolbox中的Butto

2、n在TExcel.rc的IDD_TESTEXCEL_DIALOG中點擊，建立如上圖的Button按鈕將屬性中的標題修改為“創建報表”第五步：為Button按鈕編寫程序雙擊“打開Excel”在/ TODO: Add your control notification handler code here后添加如下程序：_Application objApp;/判斷是否存在EXCEL應用程序Workbooks objBooks;_Workbook objBook;Worksheets objSheets;_Worksheet objSheet;Range objRange,usedRange;/單元

3、格獲取VARIANT ret;/Font font;objApp.CreateDispatch(Excel.Application);/判斷是否存在EXCEL應用程序COleVariant VOptional(long)DISP_E_PARAMNOTFOUND,VT_ERROR);objApp.SetVisible(TRUE);objApp.SetUserControl(TRUE); LPDISPATCH pwkbooks=objApp.GetWorkbooks();objBooks.AttachDispatch(pwkbooks,TRUE);char currentprogrampathMA

4、X_PATH;objBooks=objApp.GetWorkbooks();/objBook=objBooks.Add(VOptional);objSheets=objBook.GetSheets();CString str;str=test.xls;objBooks.Open(ExcelName,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional,VOptional);/objRange

5、.SetValue();str=A1;objSheet=objSheets.GetItem(COleVariant(short)1);objRange=objSheet.GetRange(COleVariant(str),COleVariant(str);objRange.SetValue2(COleVariant(hello excel);font=objRange.GetFont();font.SetBold(COleVariant(short)TRUE);objRange=objSheet.GetRange(COleVariant(C4),COleVariant(B4);objRange.SetFormula(COleVariant(=RAND()*100000);objRange.SetNumberFormat