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.

348 questions
10
votes
4 answers

Get the current Workbook Object in C#

I've been writing an application in C# which creates Custom Document properties in an Excel spreadsheet, I have a function for this which takes in a Workbook Object... However, actually getting the current Workbook object is proving to be quite…
Adam H
  • 1,099
  • 3
  • 15
  • 26
8
votes
4 answers

Excel ExcelDNA C# / Try to copy Bloomberg BDH() behavior (writing Array after a web request)

I want to copy Bloomberg BDH behavior. BDH makes a web request and write an array (but doesn't return an array style). During this web request, the function returns "#N/A Requesting". When the web request finished, the BDH() function writes the…
Farandole
  • 479
  • 6
  • 19
8
votes
1 answer

Doing Documentation Using Excel Dna

I have used Excel Dna to create .NET xlls and use it in my addin and excel worksheet functions. I also use ExcelDnaPack.exe to package my xll. I was wondering if excel dna supports, any ways to generate documentation for my library API's.…
Everything Matters
  • 2,482
  • 4
  • 23
  • 41
8
votes
1 answer

Automatic update of (Excel-DNA) XLL with Excel opened

I am developing an Excel XLL Add-In using Excel-DNA and C#. The Add-In is called MyAddIn.xll. The Add-In has been saved to the users local machines, and it has been installed/added to Excel by the following procedure: Excel Options --> Add-Ins -->…
Samuel
  • 157
  • 2
  • 9
7
votes
1 answer

Excel-DNA: One-Dimensional Array limited to 65536 rows

When trying to call the following Excel-DNA-Method in VBA I only get an array of size 1 (after 65536 rows the array seems to be resized to real array size - 65537). When calling the method in the sheet as array function the whole thing…
Sebastian Müller
  • 5,071
  • 11
  • 49
  • 79
6
votes
6 answers

BackgroundWorker: InvalidOperationException in RunWorkerCompleted

I have a WinForm with a backgroundWorker: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using…
Niels Bosma
  • 11,312
  • 27
  • 86
  • 143
6
votes
1 answer

Can't change the label on an excel ribbon

I've got a problem trying to set a custom label on teh fly with a ribbon using Excel-DNA. If I don't included the annotation "getLabel='GetLabel'" then the plugin loads fine. ie the ribbon tab is shown with 2 buttons andthe button callbacks work…
chollida
  • 7,536
  • 11
  • 50
  • 85
6
votes
3 answers

How do you set the value of a cell using Excel Dna?

I've got the following code in my Excel DNA plugin In my AutoOpen method I put the following code: ExcelIntegration.RegisterUnhandledExceptionHandler(ex => ex.ToString()); I've got the following function that gets called from my excel…
chollida
  • 7,536
  • 11
  • 50
  • 85
5
votes
2 answers

Why can't Excel load the excel-dna addin?

The error is: The file you are trying to open, 'ExcelDna.xll', is in a different format than specified by the file extension. Verify that the file is not corrupt and is from a trusted source before opening the file.
Dean Radcliffe
  • 2,154
  • 20
  • 28
5
votes
1 answer

IronPython Excel-Dna Add-In - Exception regarding Microsoft.Dynamic reference

I am getting started with developing an Excel-DNA addin using IronPython with some C# as a wrapper for the calls to IronPython. With the generous help of the Excel-DNA developer, I have worked through some of the initial kinks of getting a sample…
oob
  • 1,890
  • 3
  • 26
  • 48
5
votes
1 answer

Excel-Dna C# How to get values from selected range in excel worksheet

I am trying to get familiar with Excel-DNA but cannot find documentation on how I could loop through a selected range of values in worksheet cells. So, I would have a user defined function which would take as parameters a range of cells where I…
Markus
  • 51
  • 2
5
votes
2 answers

How to stop Excel-DNA function from calculating while inputting values

I have implemented some elaborate and computationally expensive function in c#. To use it in Excel I have created an Excel-AddIn via Excel-DNA. Now when I call the function within Excel and start inputting values it starts calculating even before I…
Andrey Lujankin
  • 483
  • 1
  • 7
  • 15
5
votes
4 answers

Excel Dna - Refresh all Data Source and Formula Calculation

I have couple of formulas and data coming from database. I want to refresh all the formulas programmatically through ExcelDna. All these formulas are ExcelFunctions and I have put ExcelCommand name = "Refresh" on which i want to issue recalculate to…
Ocean
  • 273
  • 3
  • 14
4
votes
2 answers

Unpack contents from Excel .XLL file built with Excel-DNA

I don't know if you know excel-dna project, it's a project that help to integrate .net assembly and language in excel addins. My problem is that I want to unpack a dll from an xll file (excel-dna is able to pack resources inside xll). I donwloaded…
Dragouf
  • 4,500
  • 4
  • 41
  • 51
4
votes
3 answers

Looking for free way to develop Excel add-ins using IronPython?

I don't know much about VSTO or VSTA, but I think you need the full version of Visual Studio to use either one. I can't convince my boss to buy us this, but I would like to develop Excel addins in IronPython. I've looked at several tutorials that…
oob
  • 1,890
  • 3
  • 26
  • 48
1
2 3
…
23 24