r/Python • • Apr 19 '20

News MS considers adding Python as official scripting language for Excel 😍 The change proposal currently has 6400 votes.

http://mc.milliononpcgames.com/?p=5886
2.0k Upvotes

124 comments sorted by

View all comments

86

u/BoaVersusPython Apr 19 '20

The first sheets app to get to python wins. Not quite sure why they would consider NOT doing this.

85

u/moxyte Apr 19 '20

Here comes the winner then. Why stop at just sheets? Take the entire suite, don't be shy.

https://help.libreoffice.org/6.3/en-US/text/sbasic/python/main0000.html

19

u/PeterMoresco Apr 19 '20

One time I look at the documentation to do so. I found it to be quite a lot of work. I mean, a lot compared to the way one should do to interact with excel using python or even using VBA. If I got the way of doing this wrong please let me know, I'm eery interested in doing so.

9

u/moxyte Apr 19 '20

I don't know a thing about that. Never had a reason to script spreadsheets. I only knew LibreOffice supports Python.

33

u/what_comes_after_q Apr 19 '20

Sheets is not a substitute for Excel. It's like saying a bicycle with a flat tire is the same as a motorcycle.

17

u/[deleted] Apr 20 '20

How did a link about LibreOffice turn into a discussion of Sheets vs. Excel?

→ More replies (8)

0

u/[deleted] Apr 20 '20

[deleted]

60

u/Deezl-Vegas Apr 20 '20

In fairness, 99.9% of excel users are unsophisticated and use excel as essentially a grocery list.

0

u/[deleted] Apr 20 '20

[deleted]

26

u/bargle0 Apr 20 '20

People have been saying literally the same thing since computers were invented. We even have a name for it.

5

u/gazhole Apr 20 '20

"Documentation is also considered frivolous, as a "real programmer" should just read other programmers' source code or manually inspect the contents of memory if he or she wants to understand how something works."

Dear lord.

3

u/Grizknot Apr 20 '20

I think the point he's trying to make is that if you're super skilled you can use paint and make something amazing (there's an entire website dedicated to painting art using only paint), but a novice will have a lot of trouble using it to make anything professional looking. Photoshop can be used by novice and pro alike and while the pro will make something that looks super duper even a novice can put out half decent work.

In this scenario I would consider myself the novice, I can't use paint to do anything interesting and while I have no idea how to properly use photoshop I can google my way through a half decent 'shop.

Same analogy applies to excel and sheets, excel is just a lot more protective of the user than sheets is.

6

u/kyerussell Apr 20 '20

Anyone using modern computers and looking down at "appification" needs to look backwards before they cast stones.

People said the same thing about the stuff you're using.

You say you are not making a value judgement, however "dumbed down" certainly is one.

→ More replies (1)
→ More replies (1)

13

u/[deleted] Apr 20 '20

Sheets actually has a lot of power in ways Excel is not as strong. The QUERY function alone is super handy. That said, both have their place -- for most organizations, sheets will suffice 95% of the time.

3

u/overcook Apr 20 '20

The query function is insanely useful. I've started using a lot of power queries in excel for basically exactly what query does but its worse in most ways if you're just trying to do something scrappy (me, every day).

The connectivity and schedulability is pretty decent in sheets too, I've got it hooked up to various APIs to pull data into reports on a scheduled basis. I can do all this in excel (or python) but keeping it running in a very low effort environment (small consultancy, internal reporting, where we spend almost no time off fee) seems like a pain.

3

u/Nu11u5 Apr 20 '20

On the other hand, Google is shit about communicating when they add new features to their apps if you are outside of their enterprise audience.

There’s been quite a few additions:

https://gsuiteupdates.googleblog.com/search/label/Google%20Sheets

2

u/6GoesInto8 Apr 20 '20

The flat tires in your analogy makes the bike a non vehicle and hurts your argument. A better one would be a hoverboard. They are light and nimble and have a low entry cost, but you probably shouldn't rely one one for any real distance.

→ More replies (1)

10

u/Yojihito Apr 19 '20

Because it has to run in the browser (Office 365) so JS is considered as the VB replacement I've read.

3

u/[deleted] Apr 20 '20

Does it really "run" in the browser, or is some of the computing actually performed server-side?

→ More replies (4)

23

u/sentient_penguin Apr 19 '20

As someone who has been in large enterprises for a long time, please no. There are critical business "systems" that are nothing more than 400gb Excel sheets. Allowing accountants and other business units more abilities in Excel/Sheets makes things worse in the long run. Most of the time the sheets are being used in place of an application with a database. Shit gets old...

16

u/hughk Apr 20 '20

They can do it with VBA now. It gets horrible very quickly.

8

u/[deleted] Apr 20 '20

I think it would be smoother than the vba they already use for all of these things. I know from my experience at Amazon that there was no upper boundary for excel if you were in a less technical department.

9

u/dparks71 Apr 20 '20

220 empty rows and 13 sheets, and you get "why's my computer so slow when I try to open this?"

5

u/Nu11u5 Apr 20 '20

“Spreadsheet applications”

*shudders*

I had hope for Google AppMaker. It was a GSuite tool that let you easily create web-based event-driven graphical front ends for data sources using a set of wizards built over AppScript. It even had a WYSIWYG form editor with a lot of widgets and well documented APIs. You could make a basic application using only drag and drop, and typing a few variable names into property dialogs (but it had an AppScript IDE for anything more advanced).

Google killed it a few months ago, while it was still in beta. “Low adoption rate”.

→ More replies (13)

6

u/spinwizard69 Apr 19 '20

Honestly I wouldn't MS Excel has become a bit of a mess lately and adding Python would do nothing to help clean up Excel. If they wanted to integrate Python into professional tools starting over would make a lot of sense.

Fro a long term point of view I'd rather see something like Swift built into Excel with Excel effectively becoming an IDE. Of course the IDE would be focused on automating Excel table handling and such. An extremely powerful scripting environment in other words.

→ More replies (2)
→ More replies (1)