返回当月的实际天数
import calendar
# 第二个参数:当月天数
m = calendar.monthrange(2023,5)
print(m) # (0, 31)
print(m[1]) # 31
写入Excel
import calendar
import openpyxl
wb = openpyxl.load_workbook(r"C:\Users\HP\Desktop\日历.xlsx")
ws = wb.active
max_row = ws.max_row
max_col = ws.max_column
for i in range(2,max_row+1):
y = int(ws.cell(i,2).value)
m = int(ws.cell(i,4).value)
ws.cell(i,10).value = calendar.monthrange(y,m)[1]
wb.save(r"C:\Users\HP\Desktop\日历.xlsx")