Sign Up

Sign In

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

You must login to ask question.

how to write to a new cell in python using openpyxl

  • 5

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
        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


1 Answer

  1. 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
    ws.cell(coordinate="C3").value = 3  # 'coordinate=' is optional here

    This will set Cells A1, B2 and C3 to 1, 2 and 3 respectively (three 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
    • 0
Leave an answer

Leave an answer