Announcing Python in Excel: Combining the power of Python and the flexibility of Excel.
techcommunity.microsoft.com
Since its inception, Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a basis for decision-making for the..

Since its inception, Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a basis for decision-making for the flying billionaires heads up in the clouds who don’t give a fuck for life offtheline

  • @algorithmae@lemmy.one
    38•2 years ago

    Why send it to the cloud when Excel is running on a perfectly capable hunk of silicon? That’s doesn’t make a lick of sense to me

    • GreyBeard
      39•2 years ago

      To charge a subscription. I massively use Microsoft 365 for work, and they are really good at making sure they get a cut for everything you do. They also want to make sure every new Office feature is supported by their web version of office. I imagine they could run the python in a web browser, but it is easier to make it a cloud service you have to pay a subscription to. Did I say easier, I meant more profitable.

    • NXTR
      3•2 years ago

      I’m guessing it’s to train AI models for Microsoft 365 Copilot.

  • @ramble81@lemm.ee
    38•2 years ago

    And just wait till some random accountant with basic knowledge of python builds out the next “great” critical system that uses this as its underlying technology. IT departments everywhere rejoice!

      • ChaoticNeutralCzech
        12•2 years ago

        At least that didn’t run remotely… But being able to access every file the user can made it a fun playground for hackers who could withstand typing things like Dim i As Integer.

        • The DoctorEnglish
          4•2 years ago

          Or using the SQL Server API to access the screen reader and manipulate the server’s DVD-ROM drive.

    • @nottheengineer@feddit.de
      15•2 years ago

      At this point microsoft is actively hurting technological progress all around the world by doing stupid shit like this. I don’t see how anyone could actually support stuff like this.

      • ChaoticNeutralCzech
        2•2 years ago

        If it fails, they can just say “nObOdY wAnTs tHiS oPeN sOuRcE sTuFf AnYwAy”. It is also way more limited than VBA (at least it cannot change your boot sector) as it seems to be confined to spreadsheet cells. A full console with the ability to load .py files would probably be friendlier to power users. Excel formulas get convoluted in that tiny space they show up in, and Python code will need its own separate window for a usable editor.

  • AatubeOP
    13•2 years ago

    On lemmy.world somebody pointed out that xlwings, a FOSS python-in-excel thingamajig, already exists

  • Kichae
    11•2 years ago

    Siiiiiiiiiiiiiiiiiiiiiiiiiiiiiiigh

    * Reads headline again

    Siiiiiiiiiiiiiiiiiiiiiiiiiiiiiiigh

  • @nitneroc@lemmy.one
    4•2 years ago

    I love how “PY” appears as “Ad” when put upside down on the right part of the image. Probably unintentional but it makes it look like a subliminal message

  • @Luci@lemmy.ca
    2•2 years ago

    I would use embedded Lua. Cloud python sounds like a headache and won’t pass an internal security review.