系统是win2000server,先安装了vs.net2003,再安装了office2003,然后又安装了owc11.exe,在引用中添加了C:\Program Files\Common Files\Microsoft Shared\Web Components\11\OWC11.DLL,现在在程序中using Microsoft.Office.Interop;这个可以了,
可是还是没有using Microsoft.Office.Excel和using Microsoft.Office.word;
在网上和站内查找了很多,还是不清楚,请哪个高手彻底给讲解清楚一下,谢谢了!
可是还是没有using Microsoft.Office.Excel和using Microsoft.Office.word;
在网上和站内查找了很多,还是不清楚,请哪个高手彻底给讲解清楚一下,谢谢了!
与Microsoft.Office.Excel,Microsoft.Office.word是不同的dll,需要分别引用的
选择COM-->选择Microsoft Word Object Library和Microsoft Excel Object Library组件,没有这两个,怎么才能加上?
默认安装了之后都会有的,没有的话可以浏览,找Application Reference
---------------------------------------------------------------------------------------------------
Microsoft Excel 2000 objects Microsoft Excel 9.0 Object Library (Excel9.olb)
Microsoft Excel 2002 objects Microsoft Excel 10.0 Object Library (Excel.exe)
Microsoft Office Excel 2003 objects Microsoft Excel 11.0 Object Library (Excel.exe)Microsoft Word 2000 objects Microsoft Word 9.0 Object Library (Msword9.olb)
Microsoft Word 2002 objects Microsoft Word 10.0 Object Library (Msword.olb)
Microsoft Office Word 2003 objects Microsoft Word 11.0 Object Library (Msword.olb)Microsoft Graph 9.0 objects Microsoft Graph 9.0 Object Library (Graph9.olb)
Microsoft Graph 10 objects Microsoft Graph 10.0 Object Library (Graph.exe)
Microsoft Graph 11 objects Microsoft Graph 11.0 Object Library (Graph.exe)Microsoft Office Outlook 2003 objects Microsoft Outlook 11.0 Object Library (Msoutl.olb)Microsoft PowerPoint 2002 Microsoft PowerPoint 10.0 Object Library (Msppt.olb)
Microsoft Office PowerPoint 2003 objects Microsoft PowerPoint 11.0 Object Library (Msppt.olb)表 1. 具有相同版本号以及用相同密钥签署的 Office 2003 应用程序和组件类型库
Office 2003 应用程序或组件 主 Interop 程序集名 主 Interop 程序集命名空间
Microsoft Access 11.0 Object Library
Microsoft.Office.Interop.Access.dll
Microsoft.Office.Interop.Access
Microsoft Excel 11.0 Object Library
Microsoft.Office.Interop.Excel.dll
Microsoft.Office.Interop.Excel
Microsoft Forms 2.0 Object Library
Microsoft.Vbe.Interop.Forms.dll
Microsoft.Vbe.Interop.Forms
Microsoft FrontPage 6.0 Page Object Reference Library
Microsoft.Office.Interop.FrontPageEditor.dll
Microsoft.Office.Interop.FrontPageEditor
Microsoft FrontPage 6.0 Web Object Reference Library
Microsoft.Office.Interop.FrontPage.dll
Microsoft.Office.Interop.FrontPage
Microsoft Graph 11.0 Object Library
Microsoft.Office.Interop.Graph.dll
Microsoft.Office.Interop.Graph
Microsoft InfoPath 1.0 Type Library
Microsoft.Office.Interop.InfoPath.dll
Microsoft.Office.Interop.InfoPath
Microsoft Office 11.0 Object Library
Office.dll
Microsoft.Office.Core
Microsoft Office Outlook View Control
Microsoft.Office.Interop.OutlookViewCtl.dll
Microsoft.Office.Interop.OutlookViewCtl
Microsoft Office Web Components 11.0
Microsoft.Office.Interop.Owc11.dll
Microsoft.Office.Interop.Owc11
Microsoft Outlook 11.0 Object Library
Microsoft.Office.Interop.Outlook.dll
Microsoft.Office.Interop.Outlook
Microsoft PowerPoint 11.0 Object Library
Microsoft.Office.Interop.PowerPoint.dll
Microsoft.Office.Interop.PowerPoint
Microsoft Project 11.0 Object Library
Microsoft.Office.Interop.MSProject.dll
Microsoft.Office.Interop.MSProject
Microsoft Publisher 11.0 Object Library
Microsoft.Office.Interop.Publisher.dll
Microsoft.Office.Interop.Publisher
Microsoft SmartTag 2.0 Type Library
Microsoft.Office.Interop.SmartTag.dll
Microsoft.Office.Interop.SmartTag
Microsoft Visio 11.0 Type Library
Microsoft.Office.Interop.Visio.dll
Microsoft.Office.Interop.Visio
Microsoft Visual Basic 6.0 Extensibility
Microsoft.Vbe.Interop.dll
Microsoft.Vbe.Interop
Microsoft Word 11.0 Object Library
Microsoft.Office.Interop.Word.dll
Microsoft.Office.Interop.Word
表 2. 具有不同版本号以及用不同密钥签署的 Office 2003 应用程序和组件类型库
对象库 主 Interop 程序集名 版本号 公钥标记
Microsoft DAO 3.6 Object Library
Dao.dll
10.0.4504.0
31bf3856ad364e35
Microsoft Windows Common Controls 6.0
Mscomctl.dll
10.0.4504.0
31bf3856ad364e35
表 3. 由 Visual Studio .NET 2003 提供并包含在 Office 2003 中的 PIA
对象库 主 Interop 程序集名 版本号 公钥标记
Microsoft ActiveX Data Objects 2.5†2.8 Library
Adodb.dll
7.0.3300.0
b03f5f7f11d50a3a
Microsoft Data Source Interfaces
Msdatasrc.dll
7.0.3300.0
b03f5f7f11d50a3a
OLE Automation
Stdole.dll
7.0.3300.0
b03f5f7f11d50a3a
当然安装了。“默认安装了之后都会有的,没有的话可以浏览,找.....”
下面这一段实在没看明白,找哪个?要word和excel编程用就行。
也可以下载
http://www.microsoft.com/downloads/details.aspx?FamilyId=3C9A983A-AC14-4125-8BA0-D36D67E0F4AD&displaylang=en
C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL
Program Files\Microsoft Office\OFFICE?\MSWORD.OLB
和
Program Files\Microsoft Office\OFFICE?\Excel.exe
1、安装office2003要注意:如果先安装office2003,再安装.net,要重新安装一下office2003的.net组件,方法是不选择默认安装,选择“添加或删除”-“高级自定义”安装,可以看到excel、word、access等选项下有“.net可编程性支持”,用鼠标点击后选择“从本机运行”。
2、安装完成后,在.net的项目里添加引用,引用“C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL”。
3、以后就可以在项目里“添加/移除项”-“com组件”里选择“Microsoft Word 11.0 Object Library"和"Microsoft Excel 11.0 Object Library"了,这样在程序里就可以有
using Microsoft.Office.Excel和using Microsoft.Office.word;了。
4、以后新项目,只要在引用里选择“com组件”,选择“Microsoft Word 11.0 Object Library"和"Microsoft Excel 11.0 Object Library"就可以了。