r/Python • • Dec 17 '17

Microsoft Considers Adding Python As an Official Scripting Language in Excel

https://developers.slashdot.org/story/17/12/15/1133217/microsoft-considers-adding-python-as-an-official-scripting-language-in-excel
2.7k Upvotes

163 comments sorted by

View all comments

57

u/psilnommoc Dec 17 '17

But as you know, the python is not a popular language for Microsoft users, so python is only a choice for Excel, maybe Microsoft will develop a new language, Python# (PythonSharp)

39

u/Rivus Dec 17 '17

Well, IronPython is a thing. Although there haven't been any updates for a year now.

It allows you to use both .NET and Python libs at the same time. Maybe Microsoft will pick it up.

11

u/[deleted] Dec 17 '17

Does it work with C-libs too? Because it woild be kinda pointless for excel if pandas, numpy and rest of the cool gang won't work.

6

u/toyg Dec 17 '17

Not really. But if you can make the C libs accessible from C# somehow, then IronPython could too.

0

u/[deleted] Dec 17 '17

[deleted]

3

u/WikiTextBot Dec 17 '17

C++/CLI

C++/CLI (C++ modified for Common Language Infrastructure) is a language specification created by Microsoft and intended to supersede Managed Extensions for C++. It is a complete revision that aims to simplify the older Managed C++ syntax, which is now deprecated. C++/CLI was standardized by Ecma as ECMA-372. It is currently available in Visual Studio 2005, 2008, 2010, 2012, 2013, 2015 and 2017, including the Express editions.


[ ^PM | Exclude ^me | Exclude from ^subreddit | FAQ / ^Information | ^Source | ^Donate ] Downvote to remove | v0.28

→ More replies (2)

1

u/psilnommoc Dec 18 '17

maybe Microsoft will develop a new python-like language Python#(PythonSharp), as like as C#, F#...

1

u/Rivus Dec 19 '17

Well, while I am always open to new ideas and a new language sounds great, the problem is that there is already Powershell, C# and F# for the MS developer.

If MS is to develop a new programming language that mimics Python to attract Python developers as they did with J# to attract Java developers, while I would personally use it, I doubt it would have a lot of traction. The question is who will use it?

1

u/psilnommoc Dec 20 '17

I think that Microsoft focused on Python and only because of its popular, I don't look for many python codes of Microsoft from its GitHub. And maybe Microsoft only follow the fashion. If another language became popular, Microsoft will still give a support. :-p

1

u/khvn26 Dec 18 '17

Microsoft has been actively grooming Python users recently, for example, making the Python vscode extension official and even running a survey on its usage. Due to its modular structure it wouldn't be hard to integrate Python in Office and even Windows itself. No need to develop anything from scratch, a good client library for popular .net classes would be more than enough.

1

u/psilnommoc Dec 18 '17 edited Dec 18 '17

I suppose that Microsoft don't regard it as a official language, and only is a option, let user decide to use VBA or Python, as like as Microsoft supported Ubuntu. Because Python become more and more popular. And in fact, Microsoft had given a Python support in Visual Studio and also developed a Pyjion, but it is only added a language for Excel at the most.

-10

u/chief167 Dec 17 '17

It's because most Microsoft "experts" actively discourage using python to senior level management. So basicaly they block it's adoption and make it seem evil as to not lose market share/profits. Happens in my company.

35

u/[deleted] Dec 17 '17 edited Dec 17 '17

[removed] — view removed comment

29

u/licquia Dec 17 '17

That moment when you diss Python scalability on Reddit...

6

u/[deleted] Dec 17 '17

[removed] — view removed comment

5

u/zeth__ Dec 17 '17

What do you consider big?

2

u/licquia Dec 17 '17

4

u/[deleted] Dec 17 '17

[removed] — view removed comment

3

u/licquia Dec 17 '17

OpenStack "has had 931,080 commits made by 10,618 contributors representing 9,092,446 lines of code."

75% of that is in Python. And Microsoft counts among the contributors.

Source

Is that scalable enough for you?

→ More replies (3)

11

u/socsa Dec 17 '17

Python is great for small* services, but on larger monolithic applications with medium to large teams, it’s usefulness wanes compared to C# and Java.

But we are talking about Excel integrattion here. If your "large service" has Excel components in it, then I'd seriously question your competency in the first place.

2

u/crowseldon Dec 17 '17

It's not being in the python sub that's the problem. It's contradicting yourself by starting with "roght tool for the right job" and later generalizing about python without context.

Maybe your own experience doesn't translate but you exercise caution when there's so many successful counter examples to your point.

→ More replies (2)

1

u/psilnommoc Dec 18 '17

In fact, Python is not a irreplaceable language and it supported for Microsoft not very well, as Ruby, most developers use it in unix-like. And Microsoft users prefer use the microsoft-ownself products, also Microsoft had develop a lot of languages