4 ms·
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 formula
by _8j50 4y ago
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".
- ehsankia 4y agoThat 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.
- thfuran 4y agoDoesn't the libre office equivalent do python?
- ehsankia 4y agoAh, 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.
- _8j50 4y agoFYI, I wasn't wishing, this is planned by MS.
- __marvin_the__ 4y agoIn 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_microsoft_excel_product_team_we_build/ https://www.reddit.com/r/IAmA/comments/m22uc6/we_are_the_mic...
- dasil003 4y agoIf you want to lean into the novice feeling you could watch this: https://www.youtube.com/watch?v=x1RVNGDSdw4 https://www.youtube.com/watch?v=x1RVNGDSdw4
- DarkCrusader2 4y agoA 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 https://www.youtube.com/watch?v=ICp2-EUKQAI [1] https://www.youtube.com/watch?v=xubbVvKbUfY https://www.youtube.com/watch?v=xubbVvKbUfY
- russellbeattie 4y agoIf 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 https://youtu.be/0nbkaYsR94c
- xlslimdev 4y agoI created an addin that gives you Python in Excel. Take a look at https://xlslim.com https://xlslim.com it is easy to use, yet very powerful.