修改表格

import openpyxl
from  random import *
s=[36.1,36.2,36.3,36.4,36.5,36.6,36.7,36.8,36.9]
workbook=openpyxl.load_workbook("C:\\Users\\24669\\Desktop\\工作簿1.xlsx")
worksheet=workbook.worksheets[0]


for row in range(4,52):
    for col in range(5,35):
        worksheet.cell(row,col,36+randint(1,9)/10)
workbook.save(filename="C:\\Users\\24669\\Desktop\\工作簿1.xlsx")

打印值日表

import openpyxl
from  random import *
name=['朱文海','蒋湃东','栾瑛琪','钱彪','王嘉展','来浩文']
workbook=openpyxl.load_workbook("C:\\Users\\24669\\Desktop\\1.xlsx")
worksheet=workbook.worksheets[0]

count=0
day=12
month='3'
for row in range(1,80):
    for col in range(1,9):
        if col%2==0:
            worksheet.cell(row,col,name[count])
            count=(count+1)%6
        else:
            worksheet.cell(row, col, month+'/'+str(day))
            if month=='3'or month=='5'or month=='7'or month=='8'or month=='10':
                day=(day+1)%32
                if day==0:
                    month=str(int(month)+1)
                    day=1
                    print(month)
            elif month=='4'or month=='6' or month=='9':
                day=(day+1)%31
                if day==0:
                    month=str(int(month)+1)
                    day=1
                    print(month)




workbook.save(filename="C:\\Users\\24669\\Desktop\\1.xlsx")