Stack Overflow
Stack Overflow

Questions tagged [excel-dna]

Excel-DNA is an independent open-source project to integrate .NET into Excel. It allows creation of Excel add-ins, including high-performance user-defined functions, using managed code.

Excel DNA is an independent open-source project to integrate .NET into Excel. It allows creation of Excel add-ins, including high-performance user-defined functions, using managed code.

It has at least partial supported for all versions of Excel from 97-2013.

Advanced Excel features are supported, including multi-threaded recalculation (Excel 2007 and later), registration-free RTD servers (Excel 2002 and later) and customized Ribbon interfaces (Excel 2007 and 2010). There is support for integrated Custom Task Panes (Excel 2007 and later), offloading UDF computations to a Windows HPC cluster (Excel 2010 and later), and for the 64-bit versions of Excel 2010 and 2013.

386 questions
3
votes
1 answer

Deploying Excel DNA Application

I am a newbie to using Excel DNA so please pardon if the question is off. I have an ExcelDNA project that I am trying to find the steps on how to publish and deploy on the user's machine. The Application is written in c# using vs2017 and is a class…
JoeyDiaz
  • 137
  • 1
  • 2
  • 12
3
votes
2 answers

Excel DNA and Excel Add In COM

I have had previous experience working with an Excel Add-In vsto COM object. Specifically using the Excel.Interop dll to create a worksheet and populate it with data. As well as, interact with the worksheet by using the worksheet change events to…
JoeyDiaz
  • 137
  • 1
  • 2
  • 12
3
votes
0 answers

Open predefined xlsx file in C# with ExcelDNA

I am trying to use ExcelDNA for some routine calculations, but integrated in C#. I am using ExcelDNA andI am unable to make my solution open a specific excel file. It either opens a new worksheet or returns an error when I write…
Marius
  • 139
  • 4
3
votes
2 answers

ExcelDna & standalone F# installation

I have downloaded the F# zipped distribution (i.e., without the installer) on Windows and I have a difficulty using ExcelDna with it. When I copy the FSharp.Core.dll and the powerpack ones into the directory of the ExcelDna files (xxx.dna and…
123
  • 31
  • 1
3
votes
1 answer

Tracking workbook and worksheet renames

Is there any way to get an event when a workbook or a worksheet is renamed in an Excel-DNA based addin? Apparently, the Application object doesn't expose these events directly.
user626528
  • 13,999
  • 30
  • 78
  • 146
3
votes
1 answer

DnaMarshalException when running Excel DNA FSharp Registration Sample

I'm trying to follow the sample project for using Excel-DNA Registration Helpers for F Sharp. In particular, I'm interested in the sample for using optional arguments. I've built the sample project (using Visual Studio 2015), but when I load the…
MattBecker82
  • 327
  • 2
  • 9
3
votes
1 answer

Get reference to cell containing function

Is there is way to access cell that contains my UDF? I need to reset some cache when function with same parameters is run from different cell. Didn't find anything suitable in exceldna utils. Thanks, Alex
Alex Michel
  • 416
  • 3
  • 13
3
votes
1 answer

How to re-trigger GetCustomUI() from ExcelDNA

I have, in ExcelDNA, created a custom ribbon (extending ExcelRibbon) and overridden the GetCustomUI() method to create a menu control from a list of strings. Basically: public override string GetCustomUI(string RibbonID) { string customUIXml = …
pcbulldozer
  • 217
  • 1
  • 10
3
votes
1 answer

Excel ribbon doesn't show up with excel-dna

Tried to create a ribbon with excel-dna and C#. The ribbon is not displayed in excel when the add-in is loaded. dna file: