Monday 8 January 2018

Will Python replace VBA as the inbuilt scripting language of Excel?

Microsoft has an Excel Suggestion Box subsite at the customer engagement website uservoice. So users can make any suggestions and from time to time a Microsoft project lead will join the discussion about certain suggestions. This has happened when someone suggested Python as an Excel scripting language. This has higher votes than any other suggestion (currently past 4000).

The Microsoft Project lead is Ashvini Sharma, Lead Program Manager, Microsoft Excel and he is requesting that users fill out a survey on this topic.

The comments thread throws up some recommendations about Python technologies already available, here is a list (in arrival sequence)

Important technical points worth echoing

  • Handle OLEVariants with high performance - compiled C# code can be slower than interpreted VBA code because of VBA's affinity to OLEVariant and C#'s boxing and unboxing issues.

R is also spoken of. Increasing I see job adverts with VBA, Python and R together. Here is a (shorter) list of R resources

And the Javascript advocates pitched in, some links

Miscellany

MASTER: But this is fantastic, isn't it? The Time Lords restored.
DOCTOR: You weren't there in the final days of the War. You never saw what was born. But if the Timelock's broken, then everything's coming through. Not just the Daleks, but the Skaro Degradations, the Horde of Travesties, the Nightmare Child, the Could-have-been King with his army of Meanwhiles and Never-weres. The War turned into hell. And that's what you've opened, right above the Earth. Hell is descending.

No comments:

Post a Comment