×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Python in Excel for Microsoft 365 Insiders

Python in Excel for Microsoft 365 Insiders

Python in Excel for Microsoft 365 Insiders

(OP)
I see that Microsoft have just released a beta version of support for Python code directly from Excel, available to Beta level "Insiders" only.

Does anyone here have access?

Any comments?

I'm particularly interested in advantages/disadvantages compared with add-ins such as pyxll or Xlwings.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Python in Excel for Microsoft 365 Insiders

I have no knowledge but thanks for sharing the news. Could be very useful in the future. You might have more luck on a forum with a community that is more focused on excel or python.

From looking at a few pages on the topic, it sounds like it's only for cloud based "microsoft 365" and the python code also runs on the cloud, so might not have the option for a local version, which reduces the appeal.

edit: if you want access yourself and have a office 365 license, it looks easy to join the beta group

https://support.microsoft.com/en-us/office/introdu...

RE: Python in Excel for Microsoft 365 Insiders

(OP)

Quote:

it sounds like it's only for cloud based "microsoft 365" and the python code also runs on the cloud, so might not have the option for a local version, which reduces the appeal.

Yes, I'm not keen on the cloud based approach either.

Another thing that doesn't sound so great:

"No need to install any add-ins and no clunky separate windows for writing the code."
From: https://www.myonlinetraininghub.com/python-in-exce...

I'm sure we all remember how much more efficient it was coding in Excel when you wrote the code on a worksheet, rather than the clunky separate VBA window!

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Python in Excel for Microsoft 365 Insiders

Yeah the lack of dedicated interface is definitely disappointing, I've watched one or two videos on youtube that show it in practice and I'm not sure I'll have much interest in it's current form.

If I had to guess I would say this is excel's way of staying relevant for data analysis and machine learning , which python seems to have a good handle on. I've worked with large datasets in the past but it isn't something I'm currently looking at but if that changes I might have another look at this.

RE: Python in Excel for Microsoft 365 Insiders

Quote:

I'm sure we all remember how much more efficient it was coding in Excel when you wrote the code on a worksheet, rather than the clunky separate VBA window!

Yeah I don't really get this design choice, but I guess time will tell. All I can say is I've waited with baited breath for python to be added, but the form of it on paper (not having tried it yet) has left me a little underwhelmed.

I was hoping for more, like external integration with code editor of choice and ability to store python files or directories somehow within the xlsm file system. The whole cloud thing seems a bit of a weird one, but is similar to how excel works on mobile I guess.

Have not tried it but plan to, so might be surprise me...

https://engineervsheep.com

RE: Python in Excel for Microsoft 365 Insiders

I know this is about Python and Excel, but "baited" should be "bated", as in "abated." winky smile

Until I eventually saw in text, I had wondered what "baited" had to do with waiting, other than rhyming...

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: Python in Excel for Microsoft 365 Insiders

(OP)
Agent666 - have you looked at using pyxll or xlwings? I think they already do pretty much what you want to do.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Python in Excel for Microsoft 365 Insiders

I'm trying to catch the perfect python excel fish ... English is my first language unfortunately, pretty much failed it at school many moons ago.

Yeah I've used xlwings, I guess I was thinking for excel more like a python virtual environment within a file sort of thing. Then easy to share with non python people as everything is included...

I was hoping for something builtin that basically as seemless as VBA. The whole writing it out in cells is very counterintuitive especially if there are no linting/formarting features (unsure if there is or not) is going to be very unfriendly to use. Despite using python for a few years having something like vs ode and black formatter is still a no Brainerd for me to avoid issues.

https://engineervsheep.com

RE: Python in Excel for Microsoft 365 Insiders

Introducing Python in Excel

Seems like something that could do certain things easier than with VBA, since you don't have to go into a separate environment, and it's always live. The ability to use Matplotlib seems like a plus; Excel's graphing capabilities are generally pretty good, but its 3D graphing used to be way better. I could see using Matplotlib for live 3D graphing and the 2x2 array of graphs with synchronized axes seems plausibly useful; I've had issues with getting separate graphs to line up and look the same, so that's maybe a plus

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: Python in Excel for Microsoft 365 Insiders

If Pyton can produce dll's You can always VBA to run it

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close