Microsoft office web Components not working with Visual Studio 2012

▲
1
▼

I am using Visual studio 2012 & creating a VB.Net Windows Forms Application whereas i am trying use microsoft office web components to embed an excel sheet into the form.

I have installed, Office web components 11. while selecting the Microsoft office spread sheet 11.0 Item it says following error

Failed to import the ActiveX control. Please ensure it is properly registered.

When i build it, it shows following error.

------ Rebuild All started: Project: WindowsApplication11, Configuration: Debug Any CPU ------
  COM Reference 'OWC11' is the interop assembly for ActiveX control 'AxOWC11' but was marked to be linked by the compiler with the /link flag. This COM reference will be treated as a reference and will not be linked.
C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets(2015,5): warning MSB3284: Cannot get the file path for type library "7c0ffab0-cd84-11d0-949a-00a0c91110ed" version 1.0. Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))
C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets(2015,5): error MSB3303: Could not resolve COM reference "0002e558-0000-0000-c000-000000000046" version 1.0. Object reference not set to an instance of an object.
C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets(2015,5): warning MSB3284: Cannot get the file path for type library "7c0ffab0-cd84-11d0-949a-00a0c91110ed" version 1.0. Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))
C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets(2015,5): error MSB3303: Could not resolve COM reference "0002e558-0000-0000-c000-000000000046" version 1.0. Object reference not set to an instance of an object.
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========

PFB snapshot while dragging and dropping the Microsoft Spread sheet 11.0 item into the form enter image description here

Even i have tried registering manually, PFB .. But getting same error!

enter image description here Please tell me whats the problem and how to resolve it ?

.net
excel
vb.net
visual-studio-2012
asked on Stack Overflow Dec 27, 2013 by logan • edited Jul 8, 2020 by Martijn Pieters

6 Answers

▲
3
▼

OPen CMD and write :

REGSVR32 YouDllName.dll

if you get error message :

Filename.dll is not an executable file and no registration helper is registered for this file type.

Use this command :

cd \windows\syswow64
regsvr32 c:\YouDllName.dll path for the dll file.

UPDATE: The file is named owc11.dll, and its default location is

C:\Program Files\Common Files\Microsoft Shared\Web Components\11

or, if you have 64-bit Windows:

C:\Program Files (x86)\Common Files\Microsoft Shared\Web Components\11

answered on Stack Overflow Dec 30, 2013 by Al-3sli • edited Dec 30, 2013 by Al-3sli
▲
1
▼

I got an answer from Microsoft Team! Here is it...

Office Web Components is a deprecated technology and is no longer under active development. Hence we advise you to move to Excel services from OWC. This is documented in below articles

http://blogs.office.com/b/microsoft-excel/archive/2006/07/17/office-web-components-roadmap.aspx

answered on Stack Overflow Jan 6, 2014 by logan
▲
1
▼

please visit this address. I am not able to understand their tech words, but the buttom line is that the OWC will no longer run with the office.

http://blogs.office.com/2006/07/17/office-web-components-roadmap/

answered on Stack Overflow Apr 3, 2014 by Yavuz
▲
0
▼

In some exoteric case, the key {91A74EB0-EFA0-482B-B43C-35CFC74B275F} can not be deleted. In these cases do the following:

1) Use the utility tool RunAsSystem

https://www.raymond.cc/blog/full-control-permission-to-delete-or-edit-restricted-windows-registry/

2) Delete the key {91A74EB0-EFA0-482B-B43C-35CFC74B275F}

3) Be Happy :-)

answered on Stack Overflow Jul 23, 2014 by Hever Costa Rocha
▲
0
▼

I got the same problem. This is my coding environment by following: VB2008/ Win7 SP1/ IE10/ OWC11

I got this problem when I upgrade IE from 8 to 10.

My solution is that starts VB with administrator. Then, add the OWC11 component again. Right click on your mouse on the toolbox to click "selecting items". Next, go into COM page, then go to the place where OWC11.DLL originally is placed, re-add it. Finally, the problem will be solved. Try it.

In my case, OWC11.dll is located at C:\Program Files (x86)\Common Files\Microsoft Shared\Web Components\11\owc11.dll

answered on Stack Overflow Jun 10, 2018 by C.K
▲
-1
▼

Ok here is my Solution:

After you add it to ToolBox, Drag and Drop it in your Windows Form... The error will raise.. click Ok..

Rebuil Your Project (The DLL will be copied)

Re-Drag and Drop the component and now, it'll work

Check this out

answered on Stack Overflow Dec 30, 2013 by Pouya Samie

User contributions licensed under CC BY-SA 3.0