Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to write to a new cell in python using openpyxl

Tags:

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

like image 667
Priyaranjan Avatar asked Jul 13 '15 23:07

Priyaranjan


1 Answers

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 
like image 153
Jake Griffin Avatar answered Oct 18 '22 22:10

Jake Griffin