ExcelDna | repository contains the core Excel | Data Visualization library

I am trying to auto pack Excel-DNA project.

I have followed Getting Started with Excel-DNA to create Excel-DNA project.

I followed Excel-DNA Packing Tool to pack my project which works.

I am trying to use VS 2019 post-build event to achieve auto pack my project.

I copied the ExcelDna.Integration.dll,ExcelDnaPack.exe and ExcelDnaPack.exe.config to my folder, and then use command below

I am trying to implement Excel-DNA addin which can be called from VBA.

I am following Integrating with VBA

But the ExcelDna.Integration.CustomUI.ExcelComAddIn throw ExcelComAddIn is not available under ExcelDna.Integration.CustomUI

Without putting entire ribbon xml, here is my button:

We're trying to write a .xlsx file using a formula that would return a double[] using ClosedXml. The new versions of Excel are adding the Implicit Intersection Operator ('@') to the formula, and not allowing it to spill to the adjacent cells.

Is there a way to get it not to happen. Microsoft talks about setting Range.Formula2 (https://docs.microsoft.com/en-us/office/vba/api/excel.range.formula2), but I'm not sure if that's available through ClosedXml.

I'd rather not try to implement writing the file with OpenXml, as that seems very hairy.

Is there a way to do this?

Sample:

So, I am trying to create a COM Add-In for 64-bit MS Office (no application in particular, just trying to get something working). I am not trying to make an add-in for the VBE, just something for the Office application itself. I have implemented IDTExtensibility2 like this (top of the file):

In this code, I expected that the vCallLevel variable inside the uTest1 function will be equal to 1, and upon exiting it will be reset to 0. However, when returning from the function, it retains its value, and when the uTest1 function is called again, the vCallLevel value is increased by 1 again (MsgBox in the destructor is also not executed). This means that the Protected Overrides Sub Finalize () destructor is not called on exit. However, when I close Excel, I get MsgBox messages multiple times. What am I doing wrong?

I am using ExcelDNA and Microsoft.Office.Interop.Excel to set some of the y values of a given Excel chart series to #N/A. (*)

This is what I am trying to achieve in VBA. This works as expected:

I have written several helper functions in F# that enable me to deal with the dynamic nature of Excel over the COM/PIA interface. However when I go to use these functions in an Excel-DNA UDF they do not work as expected as Excel-DNA is pre-processing the values in the array from excel. e.g. null is turned into ExcelDna.Integration.ExcelEmpty

This interferes with my own validation code that was anticipating a null. I am able to work around this by adding an additional case to my pattern matching:

I would like to write the ExcelCommand UDF in the C# program that uses the ExcelDNA Registration package.

However, in order to use the Registration package, if I set explicitRegistraiton="true" in the dna file, the following simple Excel command cannot be loaded. In fact, it is possible to compile, but the UDF command doesn't appear in the Excel add-in tab.

How can I use excel command in a program that uses ExcelDna registration?