I have performed web browser automation and other excel data analysis tasks in Python, but this time I have a requirement where I am supposed to automate Excel add inn, where I get a prompt (which comes after installing the add inn), in which I have to enter a certain number and refresh few pivots after that. Refreshing the pivot using python is possible I believe but can someone help me with the first issue. Can win32com help me with this?
Asked
Active
Viewed 32 times
0
-
What's the add-in in question? – BigBen Dec 16 '19 at 14:45
-
You can try TestStack.White. It basically relies on the UIAutomation library. https://teststackwhite.readthedocs.io/en/latest/ – Sourabh Mishra Dec 26 '19 at 07:06