Hacker News Reader

Comment by _8j50 | Hacker News Reader

Excel makes me feel like such a novice. I often just write a python script instead out of frustration. I don't think little of people that write complex formulas and macros with it. I am still waiting for "python in excel".

View on HN

That would be awesome. With Sheets, I often jump into AppScript to write a quick javascript function to do what I want instead of having to deal with weird syntax. I wish I could do the same in Python.

Doesn't the libre office equivalent do python?

Ah, very interesting. Though it seems they only have the document control API. What I like about the Sheets integration is that you can write normal formulas you can use inside cells. like

    function REVERSE_STRING(input) {
      return input.split("").reverse().join("");
    }

and then call that inside a cell formula.

FYI, I wasn't wishing, this is planned by MS.

In the latest (that I can find) Excel team's Reddit AMA [0], Python was not addressed at all.

[0] https://www.reddit.com/r/IAmA/comments/m22uc6/we_are_the_mic...

If you're really a novice, watch Joel Spolsky's talk. I go back to it whenever I end up in Excel for something.

https://youtu.be/0nbkaYsR94c

I created an addin that gives you Python in Excel. Take a look at https://xlslim.com it is easy to use, yet very powerful.

If you want to lean into the novice feeling you could watch this: https://www.youtube.com/watch?v=x1RVNGDSdw4

A while ago I watched a couple of videos by Krazam [0][1] on competitive Excel. Thought it was just a sketch, didn't realize it was actually a thing.

[0] https://www.youtube.com/watch?v=ICp2-EUKQAI [1] https://www.youtube.com/watch?v=xubbVvKbUfY

Reply on news.ycombinator.com