This project has moved and is read-only. For the latest updates, please go here.

Excel Addin sample does not show task pane



I tried a sample solution "NetOffice Excel Addin Examples", the project "NetOffice Tools - Extended". I use Excel 2013 on Windows7 64 bit. After compiled I can see the the addin "NetOfficeTools Extended Example CS4" in Excel. The button "About" works, but the button "Sample Pane CS4 Visible" does nothing.

I wrote a simple project which creates a new Excel Application and open a workbook from the path. In this case I can see the task pane and I am able to switch it on and off.

Could you help me please?



SebastianDotNet wrote Mar 7, 2017 at 10:39 AM

I do not understand the problem.
Your own addin works fine to enable/disable the pane but the NO example doesnt works?
I just want to understand the problem... (Enable/disable taskpane cause problems if you have multiple example addins installed in few netoffice versions because the taskpane id is given by name)


jirkaml wrote Mar 8, 2017 at 11:19 AM

Hi Sebastian,

thank you for your answer. I try to describe the problem in more detail.
I use NetOffice 1.7.3 and the sample project "d:\Projects\Libraries\NetOffice 1.7.3\NET 4.5\Examples\Excel\C#\IExtensibility COMAddin Examples\IExtensibility Excel Addin Examples.sln" . I have built the project "IDTExtensibility2 - Taskpane".

When I start Excel 2013 for a new workbook I cannot see the pane and the addin is not in the ribbon. But if I go to "Developer - COM Addins" an uncheck this COM Addin, press OK, check COM Addin, press OK - now I can see the pane. But after saving and new opening the workbook I cannot see the pane again.

Thanks, Jiri

SebastianDotNet wrote Mar 9, 2017 at 3:28 PM

hey men,

Thanks for you explanation. (and please keep in your mind - it doesnt work is not an error description)

It looks like the addin example code cause problems while starting - my bad.
Excel disable the addin now and keep hold the addin for a start on demand - you do it here.
For unknown reasons, everything works fine when you start the addin later on but fails on start the application. To be honest - i do not maintain the IDTExtensibility2 addins for 2 years now.
(Advise: Try the NetOffice Tools examples) Can you help me with some debugger error informations here?
Run the addin per remote debugger, an enable the option "Break on all Exceptions" in Visual Studio)


alexperkins wrote Sep 24, 2017 at 2:20 PM

I am facing same issues I have gone through all the steps but still it does't work.Even I am trying to Export some of the report form my QuickBooks to Excel and it's keep on crashing on me.

SebastianDotNet wrote Sep 25, 2017 at 12:05 PM

May an other .NET addin cause problems here.
(NetOffice does not support shimming by default.)
Have you tried to remove other addins temporaily?
(Or just use the COM Shim Wizard to isolate your addin)