this post was submitted on 23 Aug 2023
60 points (100.0% liked)

Programming

13473 readers
2 users here now

All things programming and coding related. Subcommunity of Technology.


This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 2 years ago
MODERATORS
 

My wife didn't understand why I got so excited reading this article.

all 19 comments
sorted by: hot top controversial new old
[–] IHeartBadCode@kbin.social 39 points 2 years ago (2 children)

Correction. Excel DOES NOT HAVE PYTHON. Your python is sent to Microsoft's cloud instance of Python and the result there is sent back to your Excel sheet. No actual python is being executed on your machine.

[–] JackbyDev@programming.dev 4 points 2 years ago

So it's sending it up to the big snake in the sky?

[–] Sigmatics@lemmy.ca 1 points 1 year ago

Nobody said that Excel has Python

[–] throws_lemy@lemmy.nz 18 points 2 years ago

Yeah, on their cloud. LoL

[–] AnomalousBit@programming.dev 16 points 2 years ago (1 children)

Or you know, use a non-proprietary format like CSV and analyze your data in any language you damn well please.

[–] abhibeckert@beehaw.org 3 points 2 years ago (1 children)

Excel can't import a CSV file reliably though - and neither can any other spreadsheet software I've ever tested. They have problems with dates, numeric values, etc.

The only reliable way to work with CSV is in a programming language of your choice or a plain text editor.

[–] AnomalousBit@programming.dev 1 points 2 years ago

I've never had any issue and have used CSV for years from hundreds of sources. I prefer the "what you see is what you get" and not Excel's "helpful" guessing at dates.

Excel can't even get it's own shit right when it's in XLSX:

https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates

[–] Kekzkrieger@feddit.de 15 points 2 years ago (1 children)

An important detail is that Microsoft executes your code in their cloud, which for privacy reasons alone is extremely questionable.

So it wont work if you are ever offline or have internet problems etc.

Terrible Design

[–] sunbeam60@lemmy.one 2 points 2 years ago

There’s no way I’ll ever use this, mostly because good luck trying to open that spreadsheet later.

[–] TheHobbyist@lemmy.zip 11 points 2 years ago

I read somewhere that this required connecting to Microsoft's cloud? Is that true?

[–] DavyJones@lemmy.dbzer0.com 6 points 2 years ago

LibreOffice already had JS

[–] theangriestbird@beehaw.org 4 points 2 years ago (1 children)

goddamn now i gotta learn python to stay ahead in my office job? shit...

[–] TehPers@beehaw.org 5 points 2 years ago (2 children)

Do you need to? I feel like learning Python wouldn't give much benefit here, unless you're already using Excel to create applications. In that case, learning Python might let you start making applications that better suit your needs.

[–] theangriestbird@beehaw.org 1 points 2 years ago (1 children)

Nah I was kind of joking. I do feel like understanding Excel really well has helped me stay ahead of my coworkers, but obviously people who can't figure out Excel won't be figuring out python anytime soon.

[–] MooMix@beehaw.org 2 points 2 years ago* (last edited 2 years ago)

Learning python could be handy if you ever wanted a career change into a software developer :)

[–] thingsiplay@kbin.social 3 points 2 years ago

@MariaRomanov Finally Excel becomes useful.

[–] irasponsible@beehaw.org 1 points 2 years ago

That would make some things so much easier, imagine using python string formatting instead of excel CONCAT and '&'... but it's running on the cloud, so going to be slow and fundamentally useless.

[–] Lysergid@lemmy.ml 1 points 2 years ago

Good I’m staying away from both