how to write to a new cell in python using openpyxl

by

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

More Related Contents:

  1. Editing workbooks with rich text in openpyxl
  2. Pandas: Looking up the list of sheets in an excel file
  3. How to concatenate three excels files xlsx using python?
  4. How to copy worksheet from one workbook to another one using openpyxl?
  5. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  6. How to find the last row in a column using openpyxl normal workbook?
  7. Python openpyxl data_only=True returning None
  8. Insert row into Excel spreadsheet using openpyxl in Python
  9. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  10. Get cell color from .xlsx
  11. How to write to an existing excel file without breaking formulas with openpyxl?
  12. Openpyxl max_row and max_column wrongly reports a larger figure
  13. Setting styles in Openpyxl
  14. Extract the data and modify an existing excel with openpyxl
  15. Running an Excel macro via Python?
  16. How to convert a python datetime.datetime to excel serial date number
  17. xls to csv converter
  18. copy cell style openpyxl
  19. Error: Unsupported format, or corrupt file: Expected BOF record
  20. pandas xlsxwriter, format table header – not sheet header
  21. Refresh Excel External Data with Python
  22. How can I see the formulas of an excel spreadsheet in pandas / python?
  23. Python: Open Excel Workbook using Win32 COM Api
  24. Copy pandas dataframe to excel using openpyxl
  25. How to save XLSM file with Macro, using openpyxl
  26. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  27. Edit existing excel workbooks and sheets with xlrd and xlwt
  28. Openpyxl check for empty cell
  29. python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets
  30. Excel, How to split cells by comma delimiter into new cells

Leave a Comment