批量新建工作簿、工作表---while、for
首先用while循环import xlwt
year = 2020
while year <2023:
nwb = xlwt.Workbook('utf-8')
mouth = 1
while mouth<13:
nws = nwb.add_sheet(f'{mouth}月')
mouth +=1
nwb.save(f'{year}年.xls')
year +=1用for循环代码更简洁易懂
import xlwt
for i in range(2010,2015):
nwb = xlwt.Workbook('utf-8')
for j in range(1,13):
nws = nwb.add_sheet(f'{j}月')
nwb.save(f'{i}年.xls')
页:
[1]