[claudeganon]

Office suite automation with Python would be great across the board. The external python libraries that do this are pretty clunky and VB scripting is a hot mess.

[phonon]

https://www.xlwings.org/ and https://www.pyxll.com/

[tomjen3]

Office now allows you to script it using Typescript, so you don't have to use VB any more.

[jannes]

I'm really curious what you are talking about?

I could only find "Office Scripts", which doesn't work in the normal desktop apps (only the web version).

Edit: I just found out about "Script Lab". Is that what you are talking about? https://appsource.microsoft.com/en-us/product/office/WA10438...

[claudeganon]

Oh that’s cool! Haven’t had to do anything with it in a few years, but excited to check out how this works.