操作excel，，改变列值

import os

import xlrd
import xlwt
from xlutils3.copy import copy

def CaseResult_True(case_file_name):
    # oldwb = xlrd.open_workbook(u'testData.xlsx')
    oldwb = xlrd.open_workbook(case_file_name)
    table = oldwb.sheet_by_index(0)
    nrows = table.nrows#行数
    newwb = copy(oldwb)
    newWs = newwb.get_sheet(0)
    #table = worksh_eet.sheet_by_index(0) #第一个sheet
    # colContent=table.col_values(1) # 读第二列

    for i in range(1,nrows):    # 从第2行开始
        newWs.write(i,1,u'通过') # 每一行的第二列赋值 “通过”

    newwb.save(case_file_name+'-result.xls')


def detect_walk(dir_path):
    for root, dirs, files in os.walk(dir_path):
        for filename in files:
            print ("file:%s\n" % filename)

            if (u'测试案例' in filename) and ("result" not in filename):
                path = os.path.join(root,filename)
                CaseResult_True(path)

        for dirname in dirs:
            print ("dir:%s\n" % dirname)

if __name__ == "__main__":
    detect_walk(".")