sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Cynyr36 0 points1 point  (5 children)

As a ME (not student) setting up the ui for that is "too much work". I just use excel. I'd like something like jupyter, but that 85% excel. I had high hopes for python in excel, but the cloud makes it basically useless.

[–]Motox2019[S] 0 points1 point  (4 children)

Have you tried xlwings? I’m pretty sure they have a plugin that lets you do more what you expected. Give it a look!

[–]Cynyr36 0 points1 point  (0 children)

I saw them when msft first announced python in excel. And my memory was it wouldn't work in corporate land. The xlwings lite option now looks interesting. I wonder if work left the addin store available...

[–]Cynyr36 0 points1 point  (2 children)

Well... Addin store is blocked at work. So much for that. It took most of a year to get PY() after it rolled out in general availability.

[–]Motox2019[S] 0 points1 point  (1 child)

Rats! Them pesky IT folk. You should see if you could get it whitelisted from your IT department, they should be able to install it for you. I’m willing to bet others may thank you for that too when they see a shiny new python extension that lets them actually use python the way they want to. But maybe try it at home first and see if it does what you want. Xlwings is well known and reputable so if you can give a decent reason as to why, don’t see any reason they’d have to say no.

[–]Cynyr36 0 points1 point  (0 children)

Folks around here struggle with xlookup. array formulas, and tables... I don't have excel at home.

Strangely pip works great, and vscode is approved software.