excel-d lets you write plain D code that can be run from Excel unmodified via the magic of compile-time reflection.

Other than bug fixes, the main new feature since 0.2.15 is @Async. Slap it on a function like so:

@Async
double myfunc(double d) {
    // ...
    return ret;
}

And it will be executed in a separate thread. Useful for long running calculations / tasks so that they don't block the UI or other calculations in the worksheet.

Since the last time it was posted to announce, it also has these new features:

* `Any` variant type. When a D function needs to be passed more than one type of Excel value (e.g. string or double). This also works when a function takes arrays of `Any` such as `Any[]` or `Any[][]`.

* `std.datetime.DateTime` support. Declare one of the parameters as `DateTime`, type in a date in Excel and things just work.

* D functions/delegates can be registered to be run when the XLL is closed.

* D functions to be called from Excel no longer need to be `nothrow`.

Atila


Atila

On Friday, 22 December 2017 at 00:41:31 UTC, Atila Neves wrote:
> excel-d lets you write plain D code that can be run from Excel unmodified via the magic of compile-time reflection.
>
> [...]

can we use excel-d with office for mac?

On Friday, 22 December 2017 at 22:08:23 UTC, Mengu wrote:
> On Friday, 22 December 2017 at 00:41:31 UTC, Atila Neves wrote:
>> excel-d lets you write plain D code that can be run from Excel unmodified via the magic of compile-time reflection.
>>
>> [...]
>
> can we use excel-d with office for mac?

I don't think so but I am not familiar with the Excel API on Mac so it's possible not too many changes required.  Pull requests welcomed :)

On Saturday, 23 December 2017 at 22:19:50 UTC, Laeeth Isharc wrote:
> On Friday, 22 December 2017 at 22:08:23 UTC, Mengu wrote:
>> On Friday, 22 December 2017 at 00:41:31 UTC, Atila Neves wrote:
>>> excel-d lets you write plain D code that can be run from Excel unmodified via the magic of compile-time reflection.
>>>
>>> [...]
>>
>> can we use excel-d with office for mac?
>
> I don't think so but I am not familiar with the Excel API on Mac so it's possible not too many changes required.  Pull requests welcomed :)

surely i'll give it a try.

On Friday, 22 December 2017 at 00:41:31 UTC, Atila Neves wrote:
> excel-d lets you write plain D code that can be run from Excel unmodified via the magic of compile-time reflection.
>
> Other than bug fixes, the main new feature since 0.2.15 is @Async. Slap it on a function like so:
>
> @Async
> double myfunc(double d) {
>     // ...
>     return ret;
> }
>
> And it will be executed in a separate thread. Useful for long running calculations / tasks so that they don't block the UI or other calculations in the worksheet.

Can't this UDA style be used to mimic async/await?
>
> Atila