python-写入Excel(.xls)方法

python-写入Excel(.xls)方法

import xlrd
from xlutils.copy import copy
# work_book为Excel工作簿
work_book = xlrd.open_workbook(r'绝对路径')

# sheet_by_index(0) 表示工作簿的第一sheet    

sheet1 = work_book.sheet_by_index(0)

shee1_copy = copy(work_book)
write_sheet1 = shee1_copy.get_sheet(0)

table = work_book.sheets()[0]
# row 行
# col 列
# write（行，列，填入的值）
for i in range (0, len(c)):
    write_sheet1.write(i + 1, 1, 2)
    write_sheet1.write(i + 1, 2, 4)
    write_sheet1.write(i + 1, 3, 6)
    shee1_copy.save(r'绝对路径')
    ```