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

  • IHeartBadCode@kbin.social
    link
    fedilink
    arrow-up
    45
    ·
    1 year ago

    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.

  • Kekzkrieger@feddit.de
    link
    fedilink
    English
    arrow-up
    18
    ·
    1 year ago

    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
      link
      fedilink
      arrow-up
      3
      ·
      1 year ago

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

    • OmnipotentEntity@beehaw.org
      link
      fedilink
      arrow-up
      24
      ·
      1 year ago

      It is. So not really that great, imo. Just another rent seeking behavior to force a current subscription.

      Don’t get me wrong, I’m certain it scratches an itch many people have, just the fact they put it in the cloud is a hell of a lot of needless complexity and antiuser.

    • i_love_FFT@lemmy.ml
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

      There’s also xlwings. The free tier does just that: run python code in Excel, and no cloud is required!

      • Irina@beehaw.org
        link
        fedilink
        arrow-up
        3
        ·
        1 year ago

        Forgive me if I’m wrong, but isn’t that something entirely different? This is python in a cell of a spreadsheet, which could be really good, but what you linked seems to be for macros, same as excel’s VBA

        • Hirom@beehaw.org
          link
          fedilink
          arrow-up
          1
          ·
          1 year ago

          Good point, that’s another difference between the two. Although you can probably achieve the same result with both.

          Not depending on the cloud processing your data is more important in my opinion.

          • Irina@beehaw.org
            link
            fedilink
            arrow-up
            1
            ·
            1 year ago

            Python in a spreadsheet would be so helpful, abstracting it out to macros less so. Better than making them in VBA I’m sure, but still not the same thing.

            I’m very basic, more thinking about stuff like using Python f-strings and string formatting vs excels formatting.

    • TehPers@beehaw.org
      link
      fedilink
      English
      arrow-up
      6
      ·
      1 year ago

      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.

      • coyotino [he/him]@beehaw.org
        link
        fedilink
        English
        arrow-up
        3
        ·
        1 year ago

        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
          link
          fedilink
          English
          arrow-up
          2
          ·
          edit-2
          1 year ago

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

  • Irina@beehaw.org
    link
    fedilink
    English
    arrow-up
    2
    ·
    1 year 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.