import openpyxl as px
filepath = r'c:\sample/excel_test/test.xlsx'
savepath = r'c:\sample/excel_test/test2.xlsx'
wb = px.load_workbook(filepath)
ws = wb.get_sheet_by_name('Sheet1')
ws.sheet_view.zoomScale = 85
wb.save(savepath)
- 前ページ
- 次ページ
import openpyxl as px
filepath = r'c:\sample/excel_test/test.xlsx'
savepath = r'c:\sample/excel_test/test2.xlsx'
wb = px.load_workbook(filepath)
ws = wb.get_sheet_by_name('Sheet1')
ws.sheet_view.zoomScale = 85
wb.save(savepath)