How to write a list to Excel column?

by

To assign a value to a cell, use =:

cell.value = statN

You also need to fix your loops. Notice that right now, for each element in lstStat, you are writing the entire range. Besides not being what you intended, it also is less flexible: What happens if lstStat has more or fewer elements?

What you want to do is just loop over lstStat and increment the row number as you go. Something like

r = 3
for statN in lstStat:
    ws.cell(row=r, column=1).value = statN
    r += 1

You could also use Python’s enumerate function:

for r, statN in enumerate(lstStat, start=3):
    ws.cell(row=r, column=1).value = statN

(Note that A1 is referenced as cell(row=1, column=1) as of OpenPyXL version 2.0.0; in earlier versions, A1 was cell(row=0, column=0).)

More Related Contents:

  1. Extract the data and modify an existing excel with openpyxl
  2. How to save a new sheet in an existing excel file, using Pandas?
  3. Save list of DataFrames to multisheet Excel spreadsheet
  4. Editing workbooks with rich text in openpyxl
  5. Iterate over Worksheets, Rows, Columns
  6. copy cell style openpyxl
  7. How to concatenate three excels files xlsx using python?
  8. Password Protecting Excel file using Python
  9. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  10. Modify an existing Excel file using Openpyxl in Python
  11. Copy pandas dataframe to excel using openpyxl
  12. How to find the last row in a column using openpyxl normal workbook?
  13. How to save XLSM file with Macro, using openpyxl
  14. python: why does replace not work?
  15. Fill cells with colors using openpyxl?
  16. how to write to a new cell in python using openpyxl
  17. openpyxl – adjust column width size
  18. Python openpyxl data_only=True returning None
  19. Insert row into Excel spreadsheet using openpyxl in Python
  20. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  21. getting the row and column numbers from coordinate value in openpyxl
  22. Get cell color from .xlsx
  23. “@” symbol appearing after inserting IF formula into excel using Openpyxl
  24. Is it possible to get an Excel document’s row count without loading the entire document into memory?
  25. Openpyxl check for empty cell
  26. python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets
  27. How to write to an existing excel file without breaking formulas with openpyxl?
  28. Openpyxl max_row and max_column wrongly reports a larger figure
  29. Get sheet by name using openpyxl
  30. Setting styles in Openpyxl

Leave a Comment