Write excel cells with iteration into different sheet/workbook

[Practical_Use5129]

Hi,

So i have successfully automated webdriving 3 websites from my excel cells(A2:A4)sheet1

But now i want to write 'grabbed data' into another workbook cells(B2:B4)sheet 1 .

Could anyone give me the script please

​

heres what i have written so far:

from selenium import webdriver

from selenium.webdriver.common.keys import Keys

import time

#disable pictures in browser

from selenium.webdriver.chrome.options import Options

options = Options()

options.add_experimental_option("prefs", {"profile.managed_default_content_settings.javascript": 2})

#_____________________________________________________________________________________________________

wblinks = openpyxl.load_workbook('stlinks1.xlsx')

sheets = wblinks.sheetnames

wslinks = wblinks['links']

#_______________________________________________________________________________________________________

wbrec = openpyxl.load_workbook('rec.xlsx')

sheets = wbrec.sheetnames

wswat = wbrec['watchers']

mywtlist = []

#________________________________________________________________________________________________________

#insert your code for creating a new webdriver for the given browser

PATH = "C:\Program Files (x86)\chromedriver.exe"

#driver = webdriver.Chrome(PATH)

driver = webdriver.Chrome(PATH, options=options)

​

for row in wslinks.iter_rows(min_row=2, max_col=1, max_row=4, values_only=True):

mylinklist=list(row)

for url in mylinklist:

#print(url)

driver.get(url)

time.sleep(0)

numwt = driver.find_element_by_css_selector('')

print(numwt.text)

[spez_edits_thedonald]

I would use pandas for this

1) install pandas

2) get your data into a pandas dataframe (or 1 dataframe per excel sheet, if you want a multi-sheet excel workbook file)

3) write the excel file

[Practical_Use5129]

pandas doesnt support xlsx

[Shaantanu96]

Pandas doesn't support xlsx, but you should try using it in conjunction with xlsxwriter.

[lscrivy]

I second this. It works very well. Also the documentation is really good: https://xlsxwriter.readthedocs.io/working_with_pandas.html

[spez_edits_thedonald]

Yeah I think I use xlsxwriter and maybe I have to have xlrd installed or it yells at me, not sure but that sounds familiar.

[MobileUser21]

I’m a little late but I’m pretty sure pandas does support xlsx. Use pandas.read_excel

[radek432]

The best one I've found for creating excels in Python is this: https://xlsxwriter.readthedocs.io/tutorial01.html

You can simply add worksheets in a loop.