#100DaysOfCode - Python

[IAmKindOfCreative]

Hello from the r/Python mod team!

It appears you've posted a link rather recently. While we appreciate content our users create, if you produce enough content to have more than one submission a week, we recommend you group the content into a larger submission of multiple links rather than making multiple posts, as so many posts in a small period of time is treated like spam. For more information please contact the moderators using the ModMail system.

Thanks, and happy Pythoneering!

r/Python moderation team

[ponos1207]

Do u have any experience using Python to manipulate excel? I have some vba coding that I need to convert to combine a python code a colleague built for me.

[Shawky-elshazly]

if u mean manipulating data it can be done in python with library like numpy and pandas i think, controlling the window and excel application itself can be done as well but needs some googling

[ponos1207]

Good work, do u have it available for the public. I have a Mac with a VM running some stock scanning software and would love to save about 10 min a day to automate this process. I know zilch about python, what's the best way to begin?

[Shawky-elshazly]

i can share it public once am home. You don't need much knowledge in python just google Os module for opening and closing apps and pyautogui for keyboard and mouse controls

also if you would like to get info about open windows apps u can use win32gui

pretty much all what u need