writing to an Excel file in Python

Question

I am trying to write a string to a certain cell in an Excel file by Python. This is what I have written:

from openpyxl import Workbook
wb = Workbook()
ws = wb.active
ws.cell(row =1, column=2).value = t1

However, the following error appears:

TypeError: Value must be a list, tuple, range or generator, or a dict. Supplied value is <class 'str'>

How can I write a string to cell?

Utpal Dutt · Accepted Answer · 2021-02-26 18:19:59Z

1

Is this what you are looking to accomplish ?

from openpyxl import Workbook
wb = Workbook()
ws = wb.active
t1='asd'
ws.cell(row =1, column=2,value = t1)
wb.save("fileName.xls")

this save a file with value asd in the cell

answered Feb 26, 2021 at 18:19

Utpal Dutt

4034 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

This does indeed answer the question.