批量新建工作簿、工作表---while、for

赵乾舟

首先用while循环

1. import xlwt
   
2. year = 2020
   
3. while year <2023:
   
4.     nwb = xlwt.Workbook('utf-8')
   
5.     mouth = 1
   
6.     while mouth<13:
   
7.         nws = nwb.add_sheet(f'{mouth}月')
   
8.         mouth +=1
   
9.     nwb.save(f'{year}年.xls')
   
10.     year +=1

复制代码

用for循环代码更简洁易懂

1. import xlwt
   
2. for i in range(2010,2015):
   
3.     nwb = xlwt.Workbook('utf-8')
   
4.     for j in range(1,13):
   
5.         nws = nwb.add_sheet(f'{j}月')
   
6.     nwb.save(f'{i}年.xls')

复制代码