bedrooms,

I can understand the cloud part. they wanted it work on the web and phones. They do know many businesses don't want cloud, so I see a good chance they'll ship it with embedded Python eventually.

Aatube,
Aatube avatar

Phones can also run Python and web is already a pretty separate version, I don't see why they can't only make the web version cloud.

HidingCat,

Money, what else? Office 365 is a priority and this is an attempt to hasten adoption.

bedrooms,

At least iPhone apps usually redirect Python tasks to their servers. That's one reason there are projects like Tensorflow Light.

Aatube,
Aatube avatar

For instance? All the python apps I've downloaded so far seem to function offline.

conciselyverbose,

You can even get third party libraries, though it's limited compared to less restrictive environments.

bedrooms,

You can look up Tensorflow Light.

Aatube,
Aatube avatar

That's just machine learning which is very resource consuming. It has no relation to your purported case of phones redirecting all python tasks to servers.

bedrooms,

Okay, I dug more to find out I'm wrong.

But isn't ML technology a thing Excel offers with its new Python interface?

Aatube,
Aatube avatar

Not really. I don't expect them to have a cloud instance running that long.

Aatube,
Aatube avatar

Someone on lemmy.world pointed out the FOSS xlwings also exists.

Limitless_screaming,
Limitless_screaming avatar

Are they not gonna give a bullshit reason for this? Just straight up give us your data and it's secure on our Azure instances?

NightAuthor,

The video I watched on the subject said the cloud part was to simplify and standardize the code environment. I’m sure they could have done something like a PyEnv and/or embedded copy of Python, but that’d be extra computer and storage overhead.

It’d be nice to have the option though.

I hear LibreOffice has had this functionality for a while though.

kamills,

Seems a bit odd to not have the option to run python locally on my own machine

style99,
style99 avatar

It would be very strange if you couldn't just export your data to csv and then run a python script in a shell on it.

GrayBackgroundMusic,

I would agree with you, if I’d never met a corporate executive. Anecdotal, but all the CEO’s I’ve ever met have got to grasp at any power that anyone will give them and then exploit it for profit as much as possible. If it ran locally, then they couldn’t charge a subscription fee. They even do the drug dealer trick of letting you have the first one free (there’s a preview period) and then taking it away unless you pay (the sub fee).

igorlogius,

related earlier post: lemmy.world/comment/2686919

flamingo_pinyata,

Because it was so much easier to send data to the cloud than embed a Python interpreter. 🤦

I wouldn’t be surprised if there already is one in the monstrosity that is Excel

lemonflavoured,
lemonflavoured avatar

My guess is that they are seeing this as less likely to become a security hole.

earthling,
earthling avatar

Yep. Everyone in the thread asking this question seems clueless to me. Macros are already a threat. I can’t imagine what a shitshow full on python would be.

Aatube,
Aatube avatar

The Python API they gave doesn't have disk access. Maybe somebody'll discover an exploit but that's for everything.

nottheengineer,

Python is slow enough as is, who the fuck thought adding a web request to that was a good idea‽

sugar_in_your_tea,

Python is fast enough, and generally quite a bit faster than complex spreadsheet formulas. I’ve seen formulas that can take minutes that Python could do in seconds. A web request isn’t going to matter that much.

Aatube,
Aatube avatar

Web requests are <em>very</em> slow compared to CPU computations, not to mention that time has to be doubled since it's a two-way route.

sugar_in_your_tea,

Sure, but it happens once. So as long as Python saves you more than the half second or so round trip, it’ll be preferable.

I’d prefer it to be embedded, but I can absolutely see it being useful even if it’s cloud-only.

Aatube,
Aatube avatar

Wouldn't it need to send to the cloud and back every time you change one of the cells the script is depending on?

sugar_in_your_tea,

Yup, most likely. I’m saying the total calculation w/ Excel formulas is often greater than that round trip + computation time w/ Python. Excel formulas are pretty slow.

Aatube,
Aatube avatar

I haven't seen how they were slower than just python.

sugar_in_your_tea,

Think huge formulas. I’ve seen formulas take minutes in Excel, but seconds when implemented better in a script. If you haven’t worked with massive formulas, you’re not the target market here.

Another application is accessing external APIs that don’t have internal support. If you’re accessing an external API, you’re already paying a network overhead cost, so adding another isn’t going to matter much.

dojan,
@dojan@lemmy.world avatar

I’d love to interface with Excel through python, but having to do it through the cloud smells like bullshit to me.

wagesj45, (edited )
wagesj45 avatar

On the one hand, yes. On the other, imagine handing excel files with embeded python viruses to every out of touch exec with admin powers on their laptop. LOL

dojan,
@dojan@lemmy.world avatar

That’s a very good point! This might actually be a good argument for the computing to happen in the cloud.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • tech
  • DreamBathrooms
  • InstantRegret
  • ethstaker
  • magazineikmin
  • GTA5RPClips
  • rosin
  • modclub
  • Youngstown
  • ngwrru68w68
  • slotface
  • osvaldo12
  • kavyap
  • mdbf
  • thenastyranch
  • JUstTest
  • everett
  • cubers
  • cisconetworking
  • normalnudes
  • Durango
  • anitta
  • khanakhh
  • tacticalgear
  • tester
  • provamag3
  • megavids
  • Leos
  • lostlight
  • All magazines