还剩3页未读,继续阅读
文本内容:
VS2008中C++打开Ex__l(MFC)第一步建立project选择C++下的MFCApplication选择dialogbased,中文之后__finish第二步导入EX__L头文件选择Project-AddClass-MFCClassFromTypelib后,__Add,进入MFCClassFromTypelibWizard对话框下,选择MicrosoftEx__l
11.0O__ectLibrary
1.5我用的是MicrosoftOffi__2003将上图中Class添加进来__finish并在TEx__l.cpp开始添加#includeCRange.h#includeCSheets.h#include__orkbook.h#include__orkbooks.h#includeCApplication.h#include__orksheet.h#include__orksheets.h在每一个添加进来的头文件中去掉#importC:\\ProgramFiles\\MicrosoftOffi__\\OFFI__11\\EX__L.EXEno_namespa__第三步打开COM口添加AfxOleInit;第四步建一个Button按钮选择Toolbox中的Button在TEx__l.rc的IDD_TEX__L_DIALOG中__,建立如上图的Button按钮将属性中的Caption修改为“打开Ex__l”第五步为Button按钮编写程序双击“打开Ex__l”在//TODO:Addyourcontrolnotificationhandlercodehere后添加如下程序CApplicationo__App;//判断是否存在EX__L应用程序__orkbookso__Books;__orkbooko__Book;__orksheetso__Sheets;__orksheeto__Sheet;CRangeo__RangeusedRange;//单元格获取VARIANTret;o__App.CreateDispatch_TEx__l.Application;//判断是否存在EX__L应用程序COleVariantVOptionallongDISP_E_PARAMNOTFOUNDVT_ERROR;o__App.put_VisibleTRUE;o__App.put_UserControlTRUE;LPDISPATCHpwkbooks=o__App.get_Workbooks;o__Books.AttachDispatchpwkbooksTRUE;charcurrentprogrampath[__X_PATH];o__Books=o__App.get_Workbooks;o__Book=o__Books.AddVOptional;o__Sheets=o__Book.get_Sheets;CStringstr;str=A1;o__Sheet=o__Sheets.get_ItemCOleVariantshort1;o__Range=o__Sheet.get_RangeCOleVariantstrCOleVariantstr;o__Range=o__Sheet.get_RangeCOleVariant_TC4COleVariant_TB4;o__Range.put_FormulaCOleVariant_T=RAND*_____0;o__Range.put_NumberFor__tCOleVariant_T$
0.00;usedRange=o__Range.get_EntireColumn;usedRange.AutoFit;第六步避免Error2errorC2059:syntaxerror:将CRange.h下VARIANTDialogBox改为VARIANT_DialogBox最后运行。