copy cell style openpyxl

by

As of openpyxl 2.5.4, python 3.4: (subtle changes over the older version below)

new_sheet = workbook.create_sheet(sheetName)
default_sheet = workbook['default']

from copy import copy

for row in default_sheet.rows:
    for cell in row:
        new_cell = new_sheet.cell(row=cell.row, column=cell.col_idx,
                value= cell.value)
        if cell.has_style:
            new_cell.font = copy(cell.font)
            new_cell.border = copy(cell.border)
            new_cell.fill = copy(cell.fill)
            new_cell.number_format = copy(cell.number_format)
            new_cell.protection = copy(cell.protection)
            new_cell.alignment = copy(cell.alignment)

For openpyxl 2.1

new_sheet = workbook.create_sheet(sheetName)
default_sheet = workbook['default']

for row in default_sheet.rows:
    for cell in row:
        new_cell = new_sheet.cell(row=cell.row_idx,
                   col=cell.col_idx, value= cell.value)
        if cell.has_style:
            new_cell.font = cell.font
            new_cell.border = cell.border
            new_cell.fill = cell.fill
            new_cell.number_format = cell.number_format
            new_cell.protection = cell.protection
            new_cell.alignment = cell.alignment

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. Read Excel cell value and not the formula computing it -openpyxl
  4. Save list of DataFrames to multisheet Excel spreadsheet
  5. Editing workbooks with rich text in openpyxl
  6. Iterate over Worksheets, Rows, Columns
  7. Pandas: Looking up the list of sheets in an excel file
  8. How to access the real value of a cell using the openpyxl module for python
  9. How to concatenate three excels files xlsx using python?
  10. Password Protecting Excel file using Python
  11. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  12. Modify an existing Excel file using Openpyxl in Python
  13. Copy pandas dataframe to excel using openpyxl
  14. How to find the last row in a column using openpyxl normal workbook?
  15. How to save XLSM file with Macro, using openpyxl
  16. python: why does replace not work?
  17. Fill cells with colors using openpyxl?
  18. how to write to a new cell in python using openpyxl
  19. openpyxl – adjust column width size
  20. Python openpyxl data_only=True returning None
  21. Insert row into Excel spreadsheet using openpyxl in Python
  22. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  23. getting the row and column numbers from coordinate value in openpyxl
  24. Get cell color from .xlsx
  25. How to write a list to Excel column?
  26. “@” symbol appearing after inserting IF formula into excel using Openpyxl
  27. No module named ‘openpyxl’ – Python 3.4 – Ubuntu
  28. Is it possible to get an Excel document’s row count without loading the entire document into memory?
  29. Openpyxl check for empty cell
  30. How to write to an existing excel file without breaking formulas with openpyxl?

Leave a Comment