xls文件的读和写

读：

path = "d:/word_kk/"
path1="c:/Users/Lenovo/PycharmProjects/screen_wj/data1/"


pathDir = os.listdir(path)

#进入path文件夹中循环文件
for allDir in pathDir:

    R=[]
    Q=[]
    name = allDir.split('.')[0]

    workBook = xlrd.open_workbook(os.path.join(path, allDir))
    table = workBook.sheet_by_name('Sheet1')
    #行数
    nrows = table.nrows



    for i in range(nrows):  # 循环逐行打印

        # 跳过第一行.write(result1)
        if i == 0:
            continue
        a1 = table.row_values(i)[0]
        a6 = table.row_values(i)[7]

写：

  

path2 = 'c:/Users/Lenovo/PycharmProjects/screen_wj/data/table1.xls'

workbook = xlwt.Workbook(encoding='ascii')
worksheet = workbook.add_sheet('Sheet1')

worksheet.write(hang, lie, d[18:])

#保存excel表格
workbook.save(path2)