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
1 answer

ExcelDNA pass excel cell value displalys unexpected output

I use a function public static object getContent(String keyword, object StartTime, object EndTime) { alert(StartTime); } set cell A1 to 18-07-2012.And when calling =getContent("africa",A1,"04-09-2012") dispalys…
user1618820
  • 109
  • 1
  • 2
  • 11
0
votes
1 answer

how to convert user input to string in Excel-DNA

Is it possible to call function without including " in parameter for a string param in Excel-DNA
user1618820
  • 109
  • 1
  • 2
  • 11
0
votes
2 answers

C# ExcelDNA read from dynamic array

My first time posting here. Ordinarily I find everything one could possibly need already answered. In this case, for the life of me I cannot figure this out, so here goes. I have a range of values in excel that I am attempting to read using…
Richard Todd
  • 2,406
  • 5
  • 32
  • 40
-1
votes
1 answer

use C# Excel DNA with C# Window Form

ContextSwitchDeadlock occurred Message: Managed Debugging Assistant 'ContextSwitchDeadlock' has detected a problem in 'C:\Program Files\Microsoft Office\Office15\EXCEL.EXE'. Additional information: The CLR has been unable to transition from COM…
Mohsin Ali
  • 1
  • 1
-1
votes
2 answers

Pass range as parameters from excel to c# excel-dna

i have chosen some rows and cols in excel . How can i pass them as parameter to a C# excel-dna function jusk like 'Sum(A1:C5)'?
Leonard Zhou
  • 447
  • 1
  • 4
  • 9
-1
votes
1 answer

How to display an array of POCO in Excel-Dna from .NET assembly

I got a simple POCO "Employee" class as below. public class Employee { public string Name { get; set; } public int Age { get; set; } public double Salary { get; set; } public string Address { get; set; } } I create an array of that…
Hunter
  • 2,370
  • 2
  • 20
  • 24
-1
votes
1 answer

Require Excel DNA to target both CLR 2.0 and 4.0 when deploying to target machine

I have a windows application that uses Excel-Addin using Excel DNA and targets CLR 2.0 and works fine with Office Excel up to Office 2013 64 bit, but we have found that when deploying to a machine with Office 2016 64 bit, Excel DNA complains that it…
SteveO
  • 1
-1
votes
2 answers

Exporting SqlDataReader results to array in C#

I've written a function that that runs a SQL query, and have exposed it to Excel with ExcelDNA. The query itself uses a SqlDataAdapter and its corresponding .Fill() method to populate a DataTable. I then iterate over the rows and columns of the…
insomniac
  • 192
  • 1
  • 3
  • 16
-1
votes
1 answer

How can I deploy the .dna file from ExcelDna?

I am trying to create an Excel (2007) Add-in that will respond to PivotTable changes, using this code: private void ThisAddIn_Startup(object sender, System.EventArgs e) { Excel.Worksheet sh = this.Application.ActiveSheet; …
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
-1
votes
1 answer

Using Excel-DNA ArrayResizer sample for formula longer than 255 characters

I am developing an excel add-in with the help of Excel-DNA and facing a problem with the formula having more than 255 characters. I am pulling data from API of different tickers, all is good until Array Resizer is called. In the DoResize() function…
Nadeem Akhtar
  • 11
  • 3
-1
votes
1 answer

VBA to C# with statement

I am trying to convert simple vba "with statemnt" to C#. ProductRangeA and B are named ranges. Could someone to give a hint? With ProductRangeA myRow= .Rows.Count: myValue= .Value End With With ProductRangeB myRow= .Columns.Count: …
Jim
  • 2,760
  • 8
  • 42
  • 66
1 2 3
…
25
26