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,010 points
914 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,420 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,420 points
3,374 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,010 points
476 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,010 points
1,192 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,420 points
1,317 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
• 63,420 points
5,690 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,420 points
1,449 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,420 points
1,972 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,420 points
3,130 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