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 in Others by Kithuzzz
• 20,660 points
77 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 by narikkadan
• 37,660 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 in Others by narikkadan
• 37,660 points
251 views
0 votes
0 answers
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 in Others by Edureka
• 13,640 points
6,146 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 in Others by narikkadan
• 37,660 points
198 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 in Others by narikkadan
• 37,660 points
211 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 in Others by narikkadan
• 37,660 points
59 views
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 in Others by narikkadan
• 37,660 points
143 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 in Others by narikkadan
• 37,660 points
203 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