2022年10月6日 星期四

Rename Workbook Name Using Python openpyxl module

 #   Rename Workbook Name Using Python openpyxl module


import openpyxl

import os


os.chdir('C:/Users/gary')

ss = openpyxl.load_workbook("file1.xlsx")


ss_sheet = ss.get_sheet_by_name('Workbook00')

ss_sheet.title = 'Workbook01'

ss.save('file1.xlsx')

沒有留言:

張貼留言

Python program to display calendar

# Python program to display calendar of given month of the year # importing calendar module for calendar operations import calendar # set t...