今日份试题，关于Python办公自动化应用

总是对着教材练习，晚上自己出几个试题考考自己，一考都不会。。。纸上得来终觉浅，绝知此事要躬行。

#1、新建10个excel工作簿，命名为test1-test10,
# import xlwings as xw
# file_path = '/Users/hugua/Desktop/pytest'
# app = xw.App(visible=True,add_book=False)
# for i in range(10):
#     workbook = app.books.add()
#     workbook.save(file_path + '/test' + str(i+1) + '.xlsx')
# app.quit()

#2、批量打开刚才新建的10个工作簿
# import xlwings as xw
# import os
# file_path = '/Users/hugua/Desktop/pytest'
# file_list = os.listdir(file_path)
# app =xw.App(visible=True,add_book=False)
# for i in file_list:
#     if os.path.splitext(i)[1] == '.xlsx':
#         app.books.open(file_path  + '/' + i )

#3、重命名10个工作簿为exam1-exam10
import os
file_path = '/Users/hugua/Desktop/pytest'
file_list = os.listdir(file_path)
old_name = 'test'
new_name = 'exam'
for i in file_list:
    if i.startswith('~$'):
        continue
    new_file = i.replace(old_name,new_name)
    new_file_path = os.path.join(file_path,new_file)
    old_file_path = os.path.join(file_path,i)
    os.rename(old_file_path,new_file_path)