Error while loading Excel - Source - Unknown Data Type: Microsoft.Office.Interop.Excel.Range

Add-in Express™ Support Service
That's what is more important than anything else

Error while loading Excel - Source - Unknown Data Type: Microsoft.Office.Interop.Excel.Range
 
mohan.ankur




Posts: 32
Joined: 2011-01-24
Dear Team,

My Excel addin works fine when I register the addin. I have both XLL and the addinmodule in my project. It does register and works fine.

However, when I create a setup file and install it on my machine. I get the following errors (even before the addin hits the startup event of the addinmodule).

The Exception seems to be coming from AddinExpress.MSO.2005

I was wondering if you could please help me with this issue?

Detailed technical information follows:
---
Date and Time: 1/23/2017 2:05:21 AM
Machine Name: USER-PC
IP Address: 192.168.1.4
Current User: User-PC\User

Application Domain: C:\Users\User\AppData\Local\technitya\GTFE\
Assembly Codebase: file:///C:/Windows/assembly/GAC_MSIL/AddinExpress.MSO.2005/7.7.4087.2005__4416dd98f0861965/AddinExpress.MSO.2005.dll
Assembly Full Name: AddinExpress.MSO.2005, Version=7.7.4087.2005, Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version: 7.7.4087.2005

Exception Source: AddinExpress.MSO.2005
Exception Type: System.ApplicationException
Exception Message: Unknown Data Type: Microsoft.Office.Interop.Excel.Range
Exception Target Site: SetTypeInfo

---- Stack Trace ----
AddinExpress.MSO.ADXExcelParameterInfo.SetTypeInfo(type As Type, isReturnType As Boolean)
AddinExpress.MSO.2005.dll: N 2054 (0x806) IL
AddinExpress.MSO.<>c__DisplayClass1.<.ctor>b__0(pi As ParameterInfo)
AddinExpress.MSO.2005.dll: N 0012 (0xC) IL
System.Array.ConvertAll(array As TInput[], converter As Converter`2)
AddinExpress.MSO.2005.dll: N 0041 (0x29) IL
AddinExpress.MSO.ADXExcelMethodInfo..ctor(targetMethod As MethodInfo, functions As List`1, modBuilder As ModuleBuilder)
AddinExpress.MSO.2005.dll: N 0578 (0x242) IL
AddinExpress.MSO.ADXExcelMethodInfo.ConvertToXlMethodInfos(methodInfos As List`1, functions As List`1)
AddinExpress.MSO.2005.dll: N 0085 (0x55) IL



Detailed technical information follows:
---
Date and Time: 1/23/2017 2:05:31 AM
Machine Name: USER-PC
IP Address: 192.168.1.4
Current User: User-PC\User

Application Domain: C:\Users\User\AppData\Local\technitya\GTFE\
Assembly Codebase: file:///C:/Windows/assembly/GAC_MSIL/AddinExpress.MSO.2005/7.7.4087.2005__4416dd98f0861965/AddinExpress.MSO.2005.dll
Assembly Full Name: AddinExpress.MSO.2005, Version=7.7.4087.2005, Culture=neutral, PublicKeyToken=4416dd98f0861965
Assembly Version: 7.7.4087.2005

Exception Source: AddinExpress.MSO.2005
Exception Type: System.ApplicationException
Exception Message: Unknown Data Type: Microsoft.Office.Interop.Excel.Range
Exception Target Site: SetTypeInfo

---- Stack Trace ----
AddinExpress.MSO.ADXExcelParameterInfo.SetTypeInfo(type As Type, isReturnType As Boolean)
AddinExpress.MSO.2005.dll: N 2054 (0x806) IL
AddinExpress.MSO.<>c__DisplayClass1.<.ctor>b__0(pi As ParameterInfo)
AddinExpress.MSO.2005.dll: N 0012 (0xC) IL
System.Array.ConvertAll(array As TInput[], converter As Converter`2)
AddinExpress.MSO.2005.dll: N 0041 (0x29) IL
AddinExpress.MSO.ADXExcelMethodInfo..ctor(targetMethod As MethodInfo, functions As List`1, modBuilder As ModuleBuilder)
AddinExpress.MSO.2005.dll: N 0578 (0x242) IL
AddinExpress.MSO.ADXExcelMethodInfo.ConvertToXlMethodInfos(methodInfos As List`1, functions As List`1)
AddinExpress.MSO.2005.dll: N 0085 (0x55) IL




Many Thanks
Ankur
Posted 22 Jan, 2017 15:52:48 Top
mohan.ankur




Posts: 32
Joined: 2011-01-24
Team,

Never mind. I solved it. The problem was I was using a datatype called "Excel.Range".

I will try and do some other way. Thanks again.

Kind regards
Ankur
Posted 22 Jan, 2017 17:20:08 Top
Andrei Smolin


Add-in Express team


Posts: 14137
Joined: 2006-05-11
You are welcome!

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 23 Jan, 2017 04:20:31 Top