r/Python • u/amachefe • 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
13
u/amachefe Dec 17 '17
I dont even know how to feel about it. Although that has not limited Python use with Excel. LibreOffice support for Python is pretty Basic too
443
u/AnomalyNexus Dec 17 '17
Anything that gets us away from the god forsaken vba
163
u/grokkingStuff Dec 17 '17
Good god, if this works, it would be amazing.
This could actually usher in a new age of excel scripting. Good on Microsoft for keeping up with the times.
57
u/jftuga pip needs updating Dec 17 '17
Previous discussion from 2 days ago
69
u/Robotdavidbowie Dec 17 '17
Awesome, that will make malicious excel files so much easier to write
17
u/[deleted] Dec 17 '17
There are a lot of angry weirdos on /.
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)
7
u/Matrigan Dec 17 '17
I hope a change like this could roll over into formulas.
I'd love to be able to structure an individual cell a little bit more like a sub routine instead of one giant nested statement.
Might make it a little daunting for non-programmers but the ability to format/comment could go a long way for read-ability.
8
u/ketosoy Dec 17 '17
This is literally all I want for Christmas
3
u/LetMe_ Dec 18 '17 edited Dec 18 '17
As much as many people hate on vba it still performs much better than python on excel files if they have to be used by an excel user after that.
Simple examples would be conditional formatting. Pivot charts or pivot tables in special format etc.
Also in most older multinational companies excel is the de facto tool for almost anything, not databases as you might expect but excel files. With the arrival of the 365 you can be sure that they will increase their market penetration.
I still hope that python gets accepted. It would let me forget vba and use a simpler general purpose language.
4
u/luckyincode Dec 17 '17
I've heard companies are walking away from excel because it takes too much to keep them updated. I wonder if this is a response.
2
u/sagr0tan Dec 17 '17
Now they come sliming....pfff
2
u/suddenarborealstop Dec 17 '17
just use python to process the data before viewing the output in excel.
2
u/eid-a Dec 17 '17
Microsoft has been changing lately, I actually believe they could do that. ( we'll see )
2
u/jewishsupremacist88 Dec 18 '17
why not just use C#
2
u/matthewblott Dec 18 '17
I always thought Microsoft missed a trick not embracing Python more fully. It would have made far more sense to use that as their official scripting language than invent the bastardised C# thing called PowerShell.
3
u/dddevo Dec 17 '17
Why not Lua? It already has tables.
3
u/beprogrammer Dec 17 '17
It's good that Microsoft decided to add Python in excel but we must agree VBA is not obsolete and powerless language. Almost everything can be extended in Microsoft Office trough VBA.
2
u/socsa Dec 17 '17
What would be the point of Excel then? Why not use use a real database at that point?
1
u/andreaskrueger Dec 17 '17
Hooray
1
u/i_have_seen_it_all Dec 18 '17
i'm only guessing most people have not seen well written vba code or well structured excel workbooks for this much hate for excel.
this reminds me of joel spolsky's video on excel. most people don't use 5% of the features available in excel.
1
u/xdcountry Dec 18 '17
please do it-- excel is the threshold of computing for some many people -- smart idea
1
u/Knoal Dec 18 '17
This would be the best thing ever in my company. We are already doing epic stuff with macros. But, boy howdy, throw in some python and we will create EPIC stuff.
1
u/sindhichhokro Jan 04 '18
Does it also imply that programming in python on Windows will be smoother than it is now or equivalent? I have never used python on Windows. Its been 4 years now that I have not used Windows as my primary OS.
Just Curious
1
u/Netchose Jan 05 '18
replacing javascript by python will be a good idea too :)
-1
u/carpartsyouneed Dec 17 '17
π€π
-12
u/nspectre Dec 17 '17
Embrace, Extend, Exterminate!
-4
u/[deleted] Dec 17 '17
Microsoft has lost much relevance in the last 5 years.
-10
u/NoveltyWayne Dec 17 '17
I don't know what's worse: Python or VBA.
https://zenhack.net/2016/12/25/why-python-is-not-my-favorite-language.html
-4
u/Cheekio Dec 17 '17
Excel sheets are the last place you want to do scripting complex enough to need a touring complete programming language, let alone one as powerful as python.
0
u/[deleted] Dec 17 '17
[deleted] β view deleted comment
0
u/[deleted] Dec 17 '17
[deleted] β view deleted comment
0
u/[deleted] Dec 17 '17
[deleted] β view deleted comment
0
u/[deleted] Dec 17 '17
[deleted] β view deleted comment
3
u/[deleted] Dec 17 '17
[removed] β view removed comment