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
0
votes
0 answers

VB.net form radiobutton autopopulate

Basically I have a form that I want to auto populate based on the results of some boolean statements. Such as "IF true then celcius radiobutton is checked" What I have so far is the following Public Class Unitsofmeasureform Dim oForm As…
user2978403
  • 21
  • 2
0
votes
2 answers

Create Excel Range From String of Noncontiguous Addresses using C#

I am developing an Excel Addin! I want to create an union of cells (range) without using Xlapp.Union(recursive way), by just giving couples (x,y) of cells in one string! I tried using XLapp.Union but it's realy slow, then I am looking for a new…
user2907436
  • 1
  • 1
0
votes
1 answer

ExcelDna not working on one machine

As far as I can detect all machines are the same that excelDna is being used on. On one specific machine I tried to use the code I have created, and ran into an issue. Logically I thought this was odd and instead tried to add a sample file that…
jason m
  • 6,519
  • 20
  • 69
  • 122
0
votes
1 answer

Using Excel-DNA with VS2005

I'm trying to use Excel-DNA to integrate my VB.NET DLL into VBA. But I'm running into the following problem. If I try to add this line before one of my static (Shared) class functions:
Ian
  • 4,169
  • 3
  • 37
  • 62
0
votes
0 answers

Refresh a worksheet during a long run RTD request in Excel

I am working in C# on an Excel AddIn with ExcelDNA. I have an Excel worksheet with a UDF placed in a lot of cells as a "formula array" making an RTD request. Since the request is huge, it is divided in several threads. Therefore the responses…
Mr.Pe
  • 719
  • 1
  • 7
  • 19
0
votes
1 answer

Excel DNA registering COM libraries in HKLM

I have a question about Excel DNA. I have a .DNA file which, using ExcelDNAPack, creates a .XLL Excel Add-In. I have chosen for the DLLs to be packed into the XLL. When we load the XLL (as an Add-In, not by running regsvr32), the DLLs are registered…
Phil Whittington
  • 2,144
  • 2
  • 16
  • 20
0
votes
1 answer

Display array Data Excel Dna

I am having trouble displaying data using Excel-Dna with C#. I have a function which takes in data and processes it to make a table, so I wrote a test function just to display the data, and I am unable to get a value out. The error is #VALUE. public…
Blaze Phoenix
  • 859
  • 2
  • 14
  • 33
0
votes
1 answer

How to remove an Excel UDF programmatically

I have an old Excel addin (written in VBA), now I re-write the old addin using .NET, ExcelDNA, NetOffice. In the old addin, there is a UDF, say, OldUDF, in the new addin, there is a NewUDF, the two UDFs do the same thing and accept the same…
toosensitive
  • 2,335
  • 7
  • 46
  • 88
0
votes
1 answer

How to add handlers to Excel Calculate Events with ExcelDNA

I would like to be able to listen to the BeginCalculate and EndCalculate events for all sheets in Excel from my ExcelDNA addin, and execute some intialization code. Is there a way to do this?
Franchesca
  • 1,453
  • 17
  • 32
0
votes
1 answer

How to get the assembly version from .XLL(When a DLL is converted to XLL)

I converted dll (of a VB.NET project) to xll using ExcelDna.Does the xll carry the assembly version in it? If not..How can I version a .xll file? Once I do this, I have to get the assembly version programatically in VBA code..Would appreciate help!
user1984867
  • 41
  • 1
  • 1
  • 5
0
votes
1 answer

Custom Excel function in C# is always disabled

I am trying to create a custom Excel function in C# (I hope to pull report data from a web API into Excel). However when I go into Excel, I can add the new Automation Addin, but it is listed under "Inactive Application Add-ins", what's going wrong…
Johnathan Sewell
  • 739
  • 10
  • 26
0
votes
0 answers

Can .NET Reflection "reflect" on a running system?

Context: Windows 7, Office 2007, ExcelDNA 0.30 Given that ExcelDNA doesn't support ParamArray, I had an outlandish idea: can Reflection help? After a bit of fiddling with .NET and Reflection I can see that it's good at getting static info about an…
bugmagnet
  • 7,631
  • 8
  • 69
  • 131
0
votes
1 answer

URL HelpTopic in ExcelDNA

I have the following method written in VB .Net: Public Shared Function HelloWorld2( ByVal…
Dreamer78692
  • 215
  • 5
  • 20
0
votes
2 answers

ExcelDna CustomTaskPane Example Exception

I tried to use CustomTaksPane example from ExcelDNA package and got the following error: "An exception occurred while calling function "OnShowTCP". The exception message is Exception has been thrown by the target of invocation" I use Excel 2010…
Anton Prokofiev
  • 937
  • 10
  • 28
0
votes
2 answers

ExcelDNA passing TODAY() as parameter

IS it possible to write a function that accepts =getContent("keyword",TODAY()-30,TODAY()) what should be the type of parameter then? tried public static object test(object date) { return DateTime.FromOADate(Convert.ToDouble(date)); …
user1618820
  • 109
  • 1
  • 2
  • 11
1 2 3
…
25
26