I wrote code which opens an excel file and iterates through each row and passes the value to another function.
import openpyxl wb = load_workbook(filename='C:\Users\xxxxx') for ws in wb.worksheets: for row in ws.rows: print row x1=ucr(row[0].value) row[1].value=x1 # i am having error at this point
I am getting the following error when I tried to run the file.
TypeError: IndexError: tuple index out of range
Can I write the returned value x1
to the row[1]
column. Is it possible to write to excel (i.e using row[1]
) instead of accessing single cells like ws.['c1']=x1
Try this:
import openpyxl wb = load_workbook(filename='xxxx.xlsx') ws = wb.worksheets[0] ws['A1'] = 1 ws.cell(row=2, column=2).value = 2
This will set Cells A1 and B2 to 1 and 2 respectively (two different ways of setting cell values in a worksheet).
The second method (specifying row and column) is most useful for your situation:
import openpyxl wb = load_workbook(filename='xxxxx.xlsx') for ws in wb.worksheets: for index, row in enumerate(ws.rows, start=1): print row x1 = ucr(row[0].value) ws.cell(row=index, column=2).value = x1
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With