On Tuesday, 21 March 2017 at 00:25:46 UTC, Steven Schveighoffer
wrote:
On 3/20/17 4:09 PM, Atila Neves wrote:
http://code.dlang.org/packages/excel-d
This dub package allows D code to be called from Excel. It uses
compile-time reflection to register the user's code in an XLL
(a DLL
loaded by Excel) so no boilerplate is necessary. Not even
`DllMain`! It
works like this:
If I wanted to replace our horrifying web queries from Excel
with this, I'm assuming I could? That would be awesome.
-Steve
Yes - you could, provided the function is nogc. Have done some
work on using std.experimental.allocator (well I had a working
version, but was trimmed a bit), and will publish a revised
version when we get time, but it wouldn't be hard to add directly
yourself. PRs welcome. If you allocate memory just make sure
that you hook into the xlautofree callback (or whatever it's
called - long time since I touched this) to free it.
I try to keep the excel functions as simple as possible, because
I don't want to crash a trader's spreadsheet. So we end up with
a little local server running as a windows service that does the
work. (We use nanomsg tcp/ip on localhost as struggled with IPC
on windows, but you could talk to it however is convenient).
Look forward to catching up at dconf in Berlin. Atila will be
there too (and Stefan of course). I'm staying at the Beethoven
too.
Laeeth.
