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
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,948
  • 3
  • 26
  • 48
4
votes
1 answer

What are the advantages/disadvantages of marking function IsMacroType in Excel-DNA?

A number of calls into Excel's XLL API are only permitted by Excel-DNA if the function's ExcelFunction attribute specifies IsMacroType=true. What I'm unclear of is why simply adding this to all of my functions and being done with it is not a good…
James Webster
  • 4,046
  • 29
  • 41
4
votes
1 answer

Return #N/A error from ExcelDNA

I'm pretty new to excelDNA, so I may be missing something obvious. I'm trying to return a #N/A from an excelDNA UDF. The function I'm using (via Visual Studio 2010) is below: public static object returnError() { return…
chrisSpaceman
  • 249
  • 3
  • 14
4
votes
2 answers

Excel-DNA save custom data into worksheet (not cells)

I'm hoping there is a method to save custom data from an Excel-DNA plugin into the workbook.. Something the user would enter into from a custom Excel-DNA form. I realize this can be saved into cells, but I don't want the user to see or change the…
James
  • 93
  • 5
4
votes
1 answer

Performance differences between using F# Data CSV Type Provider vs CSV Parser and Reader

I am writing an F# addin UDF for Excel using ExcelDNA where ideally I would like to dynamically load in a CSV based on the content of another CSV. I have been using at the type provider and csv parser in the F# Data library…
ct1
  • 45
  • 5
3
votes
6 answers

my first c# statement...what is the correct way to do this?

As the title suggest, this is my first C# try, so please go easy. (As a newb I promise to ask a bunch of easy questions for the C# pros out there to get you some easy points!) I'm using ExcelDNA to create a UDF in Excel, which will query our mysql…
usr951
  • 73
  • 1
  • 6
3
votes
1 answer

Excel DNA - Can I avoid doing a regasm all together?

I am trying to evaluate Excel DNA to use it in one of my excel add-in. I use C# functions (.NET 4.0) and want to invoke these functions from Excel. The reason I am interested is, the users of my addin are non-admins and hence would be a…
Everything Matters
  • 2,672
  • 4
  • 25
  • 42
3
votes
0 answers

Is it possible to obtain an untranslated (English) formula from an Excel cell using Excel's C API?

I'm writing an Excel COM add-in, using Excel-DNA to register add-in functions. Within the add-in functions I'm using the Excel-DNA wrapper for Excel's C API to get various information from worksheets, such as: var caller =…
Neil T
  • 1,794
  • 1
  • 12
  • 21
3
votes
1 answer

Can I use Microsoft.Office.Tools.Excel in Excel DNA project, or is there another way to accomplish databinding a Table?

I have code that worked in the VSTO version of an Excel Addin Microsoft.Office.Tools.Excel.ListObject lo = Globals.ThisAddIn.VSTOWorksheet.Controls.AddListObject(r, "lo1"); lo.AutoSetDataBoundColumnHeaders = true; lo.DataSource = dt; //some…
Dean Radcliffe
  • 2,194
  • 22
  • 29
3
votes
2 answers

Remove AddIn path from UDF in Excel formula

My addin was xla, now I use excelDNA, so it becomes xll, When I open spreadsheet built in previous version of My addin, for the UDF, it shows myUDF with path of xla. e.g "C:\Program Files\Installation folder\MyUDFs.xla!MyUDF", when I click Edit…
toosensitive
  • 2,335
  • 7
  • 46
  • 88
3
votes
1 answer

How to build XLL with Excel-DNA

I am trying to follow the simplest example at the Excel-DNA.net front page to create a simplest UDF for Excel. My code builds correctly, except it builds into dll instead of xll. How do I build it into an xll file? I literally follow the example…
vasaki
  • 205
  • 2
  • 8
3
votes
1 answer

F# function to sort Excel "variants" in Excel-Dna

When trying to sort a 1d array of variants (here by "variant" I mean all the Excel types, eg bool, double (and date), string, various errors...) with the following function : [] let…
Janthelme
  • 989
  • 10
  • 23
3
votes
1 answer

Create custom task pane in c# gets Unable to create specified ActiveX control runtime error

I created a simple custom task pane using excel-dna that contains a combobox and a button in a ".dna" file. But when I move my code to ".cs" file I get an "Unable to create specified ActiveX control" runtime error on this line of code: ctp =…
ali asghar Gorzin
  • 111
  • 9
3
votes
2 answers

Polymorphism in Excel Dna / F#

In F# / Excel-Dna, what is the idiomatic way to rewrite the following function for a vector of strings? (i.e. a function which sorts a "vector" (=1d Excel range) of strings). [
Janthelme
  • 989
  • 10
  • 23
3
votes
3 answers

How to convert Object from UDF parameter to Excel Range in Excel-DNA?

I am developing a simple Addin using Excel-DNA. I have written a below function, but I am finding difficulties in converting it to a Range object. Tried googling and not able to figure out. Can someone please help me [ExcelFunction(Description =…
Sam K
  • 332
  • 1
  • 6
  • 19
1
2
3
…
25 26