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

  • Aatube@kbin.socialOP
    1·
    10 months ago

    Web requests are \very\ 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@sh.itjust.works
      0·
      10 months ago

      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@kbin.socialOP
        1·
        10 months ago

        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@sh.itjust.works
          0·
          10 months ago

          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.