Have Geek Brain

Running XLL outside of Excel?

I know this question has been posted before ... but I haven't found an answer yet (besides general answers about how an XLL is actually a DLL, etc.). Have any of them successfully called the XLL from C # (using DllImport) without having to load Excel with the XLL loaded as an add-on?

Basically, you need to create a special XLCALL32.DLL that mimics the Excel host. This sounds like a lot of work ... has anyone done this? Or have you seen a product to do this?

thanks

+2


a source to share


2 answers


You are on the right track, you need to create your own XLCall32.dll and simulate Excel. This is not trivial given what you can do through the interface that XLLs use to communicate with Excel. It gets easier than the smaller Excel you need to use from your XLL, so I guess if you have a known selection of XLL you need to use and you know what bits of Excel they get through the XLL interface, then you can simply replace the bits you want ...



Why do you want to do this?

0


a source


Evaluating this XLL + library (which is not free, running on a trial atm) that hels to "mock" / "simulate" XLCALC32.dll (as it only requires 2 methods to do this, as I understand it). They will let you know if I go anywhere.



0


a source






More articles:


All Articles