S.l.e!ep.￠%

像打了激速一樣，以四倍的速度運(yùn)轉(zhuǎn)，開心的工作
簡單、開放、平等的公司文化；尊重個(gè)性、自由與個(gè)人價(jià)值；

posts - 1098, comments - 335, trackbacks - 0, articles - 1

MFC 調(diào)用Automation（一）

Posted on 2009-10-03 23:55 S.l.e!ep.￠% 閱讀(803) 評(píng)論(0) 編輯收藏引用所屬分類: Office Automation

看到的是這篇文章
http://www.vckbase.com/document/viewdoc/?id=1186? 調(diào)用word
http://www.vckbase.com/document/viewdoc/?id=648??? office 插件開發(fā)
http://tech.163.com/05/0201/10/1BGGKDV90009159Q.html?ATL開發(fā) office插件

Create an automation project

With Microsoft Developer Studio, start a new "MFC AppWizard (exe)" project named "AutoProject."
In step 1 of the MFC AppWizard, choose "Dialog Based" for the application type and then click Finish.
Click ClassWizard on the View menu (or press CTRL+W).
Select the Automation tab. Click Add Class and choose "From a type library." Navigate to select the object library for the application you wish to automate (for this example, if you are automating Excel 97, choose the Microsoft Excel 8.0 Object Library; the default location is C:\Program Files\Microsoft Office\Office\Excel8.olb).
Excel 2003. XL5EN32.OLB
NOTE: The list box in the Confirm Classes dialog box contains all of the IDispatch interfaces (which are virtually identical to classes) in the Microsoft Excel type library. In the lower half of the dialog box you will see that an Implementation file named Excel8.cpp contains generated class wrappers derived from ColeDispatchDriver(), and the appropriate declaration header file is named Excel8.h. (For Excel 2002 and Excel 2003, the files are named Excel.cpp and Excel.h.)
Click OK to close the MFC ClassWizard dialog box.

Add the following code to the CAutoProjectApp::InitInstance() function, which loads and enables the COM services library:

      BOOL CAutoProjectApp::InitInstance()
      {
         if(!AfxOleInit())  // Your addition starts here
         {
            AfxMessageBox("Could not initialize COM dll");
            return FALSE;
         }                 // End of your addition

         AfxEnableControlContainer();
      .
      .
      .

      }

Add the following line to the #include statements at the top of the AutoProject.cpp program file:

      #include <afxdisp.h>

Add the include statement for excel8.h after the include statement for stdafx.h at the top of the AutoProjectDlg.cpp program file:

      #include "stdafx.h"
      #include "excel8.h" // excel.h in the case of Excel 2002 and Excel 2003.

Add automation code to the CAutoProjectDlg::OnRun() so that it appears as shown below:

      void CAutoProjectDlg::OnRun()
      {
          _Application app;  // app is the Excel _Application object

          // Start Excel and get Application object...
         if(!app.CreateDispatch("Excel.Application"))
         {
            AfxMessageBox("Couldn't start Excel.");
         }
         else
         {
            //Make Excel Visible and display a message
          app.SetVisible(TRUE);
          AfxMessageBox ("Excel is Running!");
         }
      }

?????????

只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。
【推薦】100%開源！大型工業(yè)跨平臺(tái)軟件C++源碼提供，建模，組態(tài)！

相關(guān)文章: The Class of Excel Operation VC control excel demo MFC 調(diào)用Automation（一） VC對(duì)EXCEL操作在VC中徹底玩轉(zhuǎn)Excel

網(wǎng)站導(dǎo)航: 博客園 IT新聞 BlogJava 博問 Chat2DB 管理

S.l.e!ep.￠%

MFC 調(diào)用Automation（一）

Create an automation project

日歷

公告

常用鏈接

留言簿(5)

隨筆分類(1107)

隨筆檔案(1098)

文章檔案(1)

相冊(cè)

收藏夾(3)

DataStruct

搜索

積分與排名

最新評(píng)論

閱讀排行榜

評(píng)論排行榜