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

Excel-DNA makes Excel startup take a long time

I have a few excel addins that I built with excel-DNA and they work well but the users are complaining that it takes a long time to open Excel every time. If they uninstall the addins, excel opens much faster. so really is my addins that causes the…
Lindsey1986
  • 381
  • 1
  • 3
  • 15
0
votes
1 answer

mahapps.metro with ExcelDNA not working

Posting here to see if any mahapps.metro experts might have an idea. Let me know if 'cross posting' is bad form. (Or if you want me to replicate my post here) https://groups.google.com/forum/#!topic/exceldna/POi8EYfXsOE Update: I created a repo as…
Terry
  • 2,148
  • 2
  • 32
  • 53
0
votes
0 answers

get shape of argument arrays in excelDNA

Is there a way i can work out the shapes of the arguments in excelDNA? I know i can get the shape of the calling area using this: ExcelReference caller = (ExcelReference)XlCall.Excel(XlCall.xlfCaller); int rows = caller.RowLast -…
will
  • 10,260
  • 6
  • 46
  • 69
0
votes
1 answer

Caliburn Micro - Excel add-in - threaded window - NotifyofPropertychanged

I'm new to Caliburn micro and am trying to use it in an Excel add-in. I'm actually using ExcelDna to realize the add-in. I have my bootstrapper setup and am able to run a test application correctly in a dialog. Everything works like expected. I…
Frank Halbach
  • 1
  • 2
0
votes
1 answer

Excel-DNA, The displayed array is an array full of #VALUE!, how to resolve this

I am trying to use Excel-DNA and ArrayResizer to display an 54x4 array in excel. I have set up a breakpoint at the return value in my C# code. and can see the return value is good. {object[54, 4]} [0, 0]: "000001" [0, 1]: "One " [0, 2]: 12 [0, 3]:…
tesla1060
  • 2,621
  • 6
  • 31
  • 43
0
votes
1 answer

Excel-dna getting percentage values

I ran into a problem when trying to get percentage values from excel using ExcelReference.getValues(). For 300% it comes back as 3.0 and so on. Is there any way to distinguish if the value was percentage and formatted to number? The problem is…
skawian
  • 3
  • 2
0
votes
1 answer

RTD server isn't starting in ExcelDNA add-in

I'm trying to run an RTD server from inside an ExcelDNA .xll. All the development files are on a shared drive on my network. On the computer I developed on, the server runs fine and produces the real-time data as intended. However, when I try to…
Nate
  • 225
  • 2
  • 12
0
votes
1 answer

Importing User-Defined Functions Written in F# Using Excel DNA Into VBA Subroutines

I am currently using Excel DNA to write functions in F# and import them into Excel as formulas. Whenever selecting a cell, I am able to call any of the functions imported through Excel DNA. However, when attempting to create a new macro, I am only…
Avery B
  • 237
  • 1
  • 11
0
votes
1 answer

Excel DNA how to get events for each minor change in spreadsheet?

Developing excel spreadsheet real-time sharing application I got stuck on how to get events for border change, colour change,multi cell editing etc...(used VSTO but problem still sustain...) I tried Excel DNA for to make RTD server to get real time…
positivecrux
  • 1,307
  • 2
  • 16
  • 35
0
votes
1 answer

Embedding WebBrowser in Custom pane using Excel-DNA

I am trying to embed a browser in Custom task pane of excel using excel DNA but I am getting exception every time. I have modified the Excel dna sample shown here to use WebBrowser control from Windows Forms instead of Label TheLabel = new…
saurabh vats
  • 349
  • 3
  • 13
0
votes
1 answer

Write to current cell from toolbar activation in Excel-DNA

I have a function which gets run from a button on a toolbar. The button loads a windows form which allows the user to perform a product lookup and returns the product code: Ribbon:
0
votes
2 answers

How do I regularly post excel data to a web service?

I have a user requirement that I have been battling with for a while with no success. I need to write an add-in that can read around 100 formula-driven cells (of a specific spreadsheet) once every couple of minutes, and send to a web service. I'm…
James Savin
  • 41
  • 5
0
votes
1 answer

Using ExcelDNA and System.Data.SQLite

I have no issues using ExcelDNA and I also have no issues using System.Data.SQLite in a standalone exe. Howover I have not been able to make both work together for creating an Excel Addin dll (using Visual Studio 2012 and NuGet to install the SQLite…
Anand
  • 1,387
  • 2
  • 26
  • 48
0
votes
1 answer

Excel-DNA automation on server side

I have a question regarding how does Excel-DNA tools behave when used under server side scenarios. I am fully aware of Office limitation when used in server-side scenarios, but I do not know whether Excel-DNA tools could overcome this problem. A new…
Javi bl
  • 83
  • 2
  • 7
0
votes
2 answers

Excel DNA Function stops working after parameter change

We have a working application that runs using C# and Excel DNA to create functions that access a Java Webservice at a remote location (using RTD Server). This application worked fine until we added optional parameters to one of our functions (I do…
Raphael do Vale
  • 931
  • 2
  • 11
  • 28
1 2 3
…
25 26