excel-dna Questions
1
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 wo...
3
Solved
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 follo...
4
Solved
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...
4
Solved
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 th...
4
Solved
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...
1
Solved
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 ...
Musician asked 3/12, 2015 at 4:51
2
Solved
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\Install...
Immorality asked 20/6, 2011 at 16:54
1
Solved
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 ...
Auberta asked 21/5, 2015 at 10:21
6
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...
Complaisant asked 7/12, 2014 at 15:12
2
Solved
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 ...
Motivate asked 23/1, 2014 at 9:44
1
Solved
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 ...
Skim asked 19/2, 2013 at 20:59
1
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 s...
Fortuna asked 10/1, 2013 at 12:58
1
Solved
I want to initialize a couple of variables on Excel Dna .dll gets loaded in the
Excel?
2
Solved
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 befor...
Prepossess asked 29/6, 2011 at 22:45
1
Solved
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 ge...
1
© 2022 - 2024 — McMap. All rights reserved.