FYI: Excel connector and Office 2016

Hi Guys (and @leewei)

FYI:
I tried to install the Connector with Office 2016 and received following error:

System Info:
===========

AdditionalVersionIdentifier: 
Start Time: 29-02-16 10:32:27
Standard: AddinExpress.XL.2005, Version=7.2.4055.2005, Culture=neutral, PublicKeyToken=e69a7e0f3592d2b8
Excel version: Excel.Application.16
Exceptions:
===========

SetExcelVersion 1: Excel version is not defined. SetExcelVersion.
Exception time: 29-02-16 10:32:28
   at AddinExpress.XL.ADXExcelTaskPanesManager.SetExcelVersion()

ADXExcelTaskPanesManager.DoAddinInitialize: Excel version is not defined. SetExcelVersionFromRegistry.
Exception time: 29-02-16 10:32:28
   at AddinExpress.XL.ADXExcelTaskPanesManager.SetExcelVersionFromRegistry()
   at AddinExpress.XL.ADXExcelTaskPanesManager.SetExcelVersion()
   at AddinExpress.XL.ADXExcelTaskPanesManager.DoAddinInitialize(Object sender, EventArgs ea)

AddinExpress.XL.ADXExcelTaskPanesManager error: Excel version is not defined. SetExcelVersionFromRegistry.
Exception time: 29-02-16 10:32:28

AddinExpress.XL.ADXExcelTaskPanesManager error: Excel version is not defined. SetExcelVersionFromRegistry.
Error occured in ADXExcelTaskPanesManager.DoAddinInitialize . See 'Details' section to get more detailed information about the error.
Detailed technical information follows: 
---
Date and Time:         29-02-16 10:32:28
Machine Name:          x
IP Address:           x
Current User:          x

Application Domain:    C:\Users\x\AppData\Roaming\IBM\IBM Endpoint Manager Excel Connector 3.3.3\
Assembly Codebase:     file:///C:/Users/x/AppData/Roaming/IBM/IBM Endpoint Manager Excel Connector 3.3.3/AddinExpress.XL.2005.DLL
Assembly Full Name:    AddinExpress.XL.2005, Version=7.2.4055.2005, Culture=neutral, PublicKeyToken=e69a7e0f3592d2b8
Assembly Version:      7.2.4055.2005
Assembly Build Date:   07-02-11 01:06:50

Exception Source:      AddinExpress.XL.2005
Exception Type:        System.Exception
Exception Message:     Excel version is not defined. SetExcelVersionFromRegistry.
Exception Target Site: SetExcelVersionFromRegistry

---- Stack Trace ----
   AddinExpress.XL.ADXExcelTaskPanesManager.SetExcelVersionFromRegistry()
       AddinExpress.XL.2005.DLL: N 0414 (0x19E) IL 
   AddinExpress.XL.ADXExcelTaskPanesManager.SetExcelVersion()
       AddinExpress.XL.2005.DLL: N 0359 (0x167) IL 
   AddinExpress.XL.ADXExcelTaskPanesManager.DoAddinInitialize(sender As Object, ea As EventArgs)
       AddinExpress.XL.2005.DLL: N 0116 (0x74) IL 




Log:
===========

29-02-16 10:32:28    1    -- | 
29-02-16 10:32:28    1    -- | AddinExpress.XL.ADXExcelTaskPanesManager error: Excel version is not defined. SetExcelVersionFromRegistry.
29-02-16 10:32:28    1    -- | Exception time: 29-02-16 10:32:28
29-02-16 10:32:28    1    -- | 
29-02-16 10:32:28    1    --ADXExceptionManager.DoError
29-02-16 10:32:28    1    --*!* ProcessError ADXExcelTaskPanesManager.DoAddinInitialize
29-02-16 10:32:28    1    -- | 
29-02-16 10:32:28    1    -- | ADXExcelTaskPanesManager.DoAddinInitialize: Excel version is not defined. SetExcelVersionFromRegistry.
29-02-16 10:32:28    1    -- | Exception time: 29-02-16 10:32:28
29-02-16 10:32:28    1    -- | 
29-02-16 10:32:28    1    ADXXXlExceptionManager.InternalProcessError
29-02-16 10:32:28    1    SetExcelVersionFromRegistry
29-02-16 10:32:28    1     | 
29-02-16 10:32:28    1     | SetExcelVersion 1: Excel version is not defined. SetExcelVersion.
29-02-16 10:32:28    1     | Exception time: 29-02-16 10:32:28
29-02-16 10:32:28    1     | 
29-02-16 10:32:28    1    ExcelApplication
29-02-16 10:32:28    1    ExcelApplication
29-02-16 10:32:28    1    ExcelApplication
29-02-16 10:32:28    1    SetExcelVersion
29-02-16 10:32:28    1    ExcelApplication
29-02-16 10:32:28    1    DoAddinInitialize
29-02-16 10:32:27    1    ADXExcelTaskPanesCollectionItem.SetFormClassName
29-02-16 10:32:27    1    ADXExcelTaskPanesCollectionItem.SetEnabled
29-02-16 10:32:27    1    SetCallingAssembly
29-02-16 10:32:27    1    SetOwner
29-02-16 10:32:27    1    --ADXXOlExceptionManager
29-02-16 10:32:27    1    InitializeClass 

When I continue I can connect with the WebReports and I can create a queryResult on a custom analysis…

So it does work, you just get an error by the installation.
edit: and everytime you start Excel :wink:

Greetings

@steini44, thanks for letting me know.

It will take me a while to get this fixed because I have to go find Excel 2016, as well as the component I use to support Office plug-in.

Lee Wei

2 Likes

I am embarrassed that it took me a while to get this going with Excel 2016.

Here is a new version that is fully compatible with Excel 2016.

Excel Connector v3.3.4 for Office 2016

Lee Wei

2 Likes

Thanks @leewei, works perfectly!