python修改excel表格

# This is a sample Python script.

# Press Shift+F10 to execute it or replace it with your code.
# Press Double Shift to search everywhere for classes, files, tool windows, actions, and settings.
import xlrd
import xlwt
from xlwt import Workbook
import os
import os.path
from openpyxl.reader.excel import load_workbook
from xlutils.copy import copy

def print_hi(name):
    # Use a breakpoint in the code line below to debug your script.
    print(f'Hi, {name}')  # Press Ctrl+F8 to toggle the breakpoint.

# 遍历目录里所有的excel文件，并修改每一个文件特定的单元格
def modifycell():
    rootdir = 'C:\\Users\\Administrator\\Documents\\七色米模版\\标准钢构\\3p3k'
    list = os.listdir(rootdir)
    for i in range(0, len(list)):
        path = os.path.join(rootdir, list[i])
        print(path)
        rb = xlrd.open_workbook(path)
        wb = copy(rb)
        ws = wb.get_sheet(0)
        # for i in range(3, 28):
        #     for j in range(0, 3,2):
        #