CODEWITHSUNDEEP
excelopenpyxl
Sebastian
Sebastian

Reputation: 49

Openpyxl: Zoom out from existing workbook

I would like open an existing Excel file, go through all available sheets and zoom out (level 85%) on all sheets. Afterwards save it again. I use Openpyxl (version 2.4.0) but it seems to be impossible. Either I get a error message or it runs but I havn't any changes.

My steps are:

    from openpyxl import load_workbook

    wb = load_workbook(excelFile)

    for eachSheet in wb.worksheets:

     eachSheet.zoom = 85
     #views.zoomScale= 60

    wb.save(excelFile)

Thank you very much.

Upvotes: 3

Views: 2350

Answers (1)

gar
gar

Reputation: 14560

You can set the zoom on the worksheet view, not on the worksheet directly.

The code would be something like:

from openpyxl import load_workbook
wb = load_workbook(excelFile)
for ws in wb.worksheets:
     ws.sheet_view.zoomScale = 85
wb.save(excelFile)

Upvotes: 10

Related Questions