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
• 28,900 points
223 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
• 53,520 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
• 53,520 points
622 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
• 28,900 points
116 views
0 votes
1 answer
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
7,609 views
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
• 53,520 points
458 views
0 votes
1 answer

How search data in excel with openpyxl?

The method iter_rows in the library has changed, refer ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 53,520 points
1,099 views
0 votes
1 answer

Python Excel Writer (xlswriter) Insert Image from URL

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

answered Nov 17, 2022 in Others by narikkadan
• 53,520 points
294 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
• 53,520 points
457 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
• 53,520 points
656 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