Search code examples
pythonexcelpandasopenpyxlxlrd

AttributeError: 'workbook' object has no attribute 'max_row'

I already referred this post here but it has no response.

Am using a public github package here to copy all the formatting from one excel file to another excel file.

By formatting, I mean the color, font, freeze panes etc.

style_sheet = load_workbook(filename = 'sty1.xlsx')
data_sheet = load_workbook(filename = 'dat1.xlsx')
copy_styles(style_sheet, data_sheet) # the error happens in this line

The error producing line within copy_styles function is given below

def copy_styles(style_sheet, data_sheet):
    max_matched_row = min(style_sheet.max_row, data_sheet.max_row)
    max_matched_col = min(style_sheet.max_column, data_sheet.max_column)

The full copy_styles function can be found in this github link here

The error that I encounter is given below

AttributeError: 'workbook' object has no attribute 'max_row'

If you want a sample file to test, it can be found in this github issue here

Solution

  • Assuming you want to copy the style of the first sheet in the workbook, you should do:

    copy_styles(style_sheet.sheet_by_index(0), data_sheet.sheet_by_index(0))

    If you want to copy the style of all worksheets (assuming that they match), just loop over them:

    style_wb = open_workbook(filename = 'sty1.xlsx')
data_wb = open_workbook(filename = 'dat1.xlsx')

for sheet_from, sheet_to in zip(style_wb.sheets(), data_wb.sheets()):
    copy_styles(sheet_from, sheet_to)

    I changed the variable names on the second example to make it clear that they are workbooks, not sheets.