How to read Excel file, loop through rows, and perform certain AppRobotic Action steps for each row in Python? Let’s say that we have 2 URLs in an Excel sheet (Sheet1). Cell A1 has a URL such as google.com and cell A2 also has a URL such as google.com. Below, we open a web browser,…
Read more
AppRobotic can be used to create a simple macro to perform any action in a web browser. The code example below leverages Python to open a web browser window, and perform a simple search on Google. Python Code: import win32com.client x = win32com.client.Dispatch(“AppRobotic.API”) # specify URL url = “https://www.google.com” # open with Edge browser x.OpenURLEdge(url)…
Read more
To accept untrusted website security certificates while automating with Selenium, it’s possible to set a particular option on the driver that you’re using (Firefox, Chrome, IE). Most recently, this option is called ‘acceptInsecureCerts‘, however it doesn’t always work, particularly on newer versions of IE and Firefox. If you run into this issue with newer browser…
Read more