0

I need a script that reads the information from the active cell and searches on google. But I have no idea how to use selenium with python or something like that in libreoffice calc or Excel

Selenium allows me to do google searches, access websites, insert information in forms. So I need the script to read the active cell and do a google search. Something like:

import time
from selenium import webdriver
from selenium.webdriver.common.keys import Keys


driver = webdriver.Chrome(executable_path=r"exec_path")

driver.get('https://www.google.com/')

driver.find_element_by_name("q").send_keys("active cell", Keys.RETURN)

time.sleep(15) 
browser.quit()

But I want this code to interact with the active cell of excel or libreoffice calc and i don't know how.

2

2 Answers 2

0

What Selenium can do? It can help you with web related steps of your business problem. Are you thinking about LibreOffice online? If not - Selenium cannot help you with desktop apps.

How to start with selenium: https://www.selenium.dev/documentation/en/getting_started/quick/

How to interact with LibreOffice Calc files using python: Using Python to access LibreOffice Calc using Uno

Sign up to request clarification or add additional context in comments.

Comments

0

Yes it's now possible in LibreOffice Calc to drive Python Requests and Selenium. You must install the OAuth2OOo extension. Enjoy....

More informations:

Disclaimer: I am the developer of the CalcAddIns.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.