How to insert info into online excel spreadsheet with python selenium

0 votes

Is it possible to use Selenium to input data into an Excel spreadsheet? For instance, I want to be able to insert certain information into a particular category and have a number of rows and categories. My spreadsheet looks like this.

enter image description here

Also are there any alternatives?

Oct 24, 2022 in Others by Kithuzzz
• 38,000 points
1,306 views

1 answer to this question.

0 votes

I recently discovered one of my options, and perhaps it would be helpful to others as well. I can make advantage of Selenium ActionChains to insert data.

driver.get(https://docs.google.com/spreadsheets/.........)
actions = ActionChains(driver)
actions.send_keys(Keys.DOWN + 't')
actions.perform()

For instance, in this scenario, when the webpage is opened by the driver and you click the down arrow button, the tab travels to the first column and second row before inserting the letter "t". It is possible to create a function that asks for coordinates, such as which row and column to select in order to input the data and how many times to click left, right, up, and down. My issue is resolved by this, however, I'd want to learn about other approaches.

answered Oct 24, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

How to paste an Excel chart into PowerPoint placeholder using Python?

Very near indeed! Copy and Paste are ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,600 points
4,274 views
0 votes
0 answers

Data Driven Framework -- how to read and write in excel sheet using Selenium WebDriver with java

I'm using this code to read something, ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
660 views
0 votes
1 answer

How to split columns into two sub columns under their parent column using python in excel

Use str.split: df[['pre', 'post']] = df['Column A'].str.split(r'\s*-->\s*', expand=True) print(df) # Output ...READ MORE

answered Apr 7, 2023 in Others by Kithuzzz
• 38,000 points
1,946 views
0 votes
1 answer
0 votes
1 answer

Converting all tabs of excel sheet to PDF

Using VBA, try it like this, for ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,600 points
1,746 views
0 votes
1 answer

How search data in excel with openpyxl?

The method iter_rows in the library has ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 63,600 points
7,142 views
0 votes
1 answer

Python Excel Writer (xlswriter) Insert Image from URL

Use this: url = "..../picture.jpg" data = urllib.request.urlopen(url).read() file = ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 63,600 points
1,914 views
0 votes
1 answer
0 votes
1 answer

How to insert a picture into Excel at a specified cell position with VBA

Try this: With xlApp.ActiveSheet.Pictures.Insert(PicPath) With ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 63,600 points
2,504 views
0 votes
1 answer

How to get the JasperReports into Excel format with proper alignment

Remove at least one parameter: exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,Boolean.TRUE) Note that JRXlsExportParameter is deprecated the correct ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,600 points
3,863 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP