« Introducing ExcelDna - DotNet for Applications | Main | Some new examples »

Comments

Gregory Chase

When I pass strings in from Excel there appears to be a 255 character limitation. Is there a way around this?

Thank you

govert

The limitation of strings to 255 characters (and no Unicode) is a
limitation of the .xll interface I use. There may be some workarounds -
e.g. asynchronously getting the cell contents using the automation
interface - but these don't seem very nice. For Excel 2007 the problem
is fixed in the updated .xll interface, and I should upgrade ExcelDna
for this soon after the SDK is available - hopefully later in this year.

James White

It appears as though ExcelDNA will not find functions that are inside static classes. When I moved my function into a normal class it was able to locate it without any problems.

This tool seems to work great, although I have not beat on it yet. Thanks for your contribution!

govert

Hi James,
You might like to post this on the google group at http://groups.google.com/group/exceldna .
Anyway - I expect the static modifier on classes not to change the generated code - presumably I'm wrong. I'll have a look at it.
Regards,
Govert

Claus Madsen

Hi

The reason for stumbling onto this page is that we in our application has a .NET version 2.0, which indirectly are being called from VBA. However, on a single machine so far, we encountered that Excel loaded .NET version 1.0 even though .NET version 2.0 was installed. Putting you excel.exe.config the same place as the Excel.exe sorted the problem in this case. My question will putting excel.exe.config in the same place as excel.exe allways ensure that Excel loads .NET version 2.0 and not .NET version 1.0.

Thanks for the great solution and I am looking forward to hear from you.

govert

Hi Claus,
I have not heard of problems after putting excel.exe.config next to excel.exe. This seems to override the undocumented behaviour where the AppPatch registry key is consulted. But I suspect a library that loads before yours could load another version of the runtime explicitly.
Regards,Govert

Diego Andrés

I would like to learn tips for me to excel / c # is the faster the possible.

luis

I need implementing "linQ" code in excelDNA, How I do it?.
And How build .xll file? Then I working with de file.dna without problems.

The comments to this entry are closed.