本文共 1010 字，大约阅读时间需要 3 分钟。

import xlrdimport randomfrom xlutils.copy import copyimport xlutils# https://github.com/python-excel/xlrd# https://xlrd.readthedocs.io/en/latest/api.htmldef test1():    file = xlrd.open_workbook(filename=r'1.xlsx')    print(file.sheet_names())    # 获取工作表的名称    table = file.sheets()[0]    # 通过索引顺序获取    table = file.sheet_by_index(sheetx=0)    # 通过索引顺序获取    table = file.sheet_by_name(sheet_name='Sheet1')    # 通过名称获取    print("{0} {1} {2}".format(table.name, table.nrows, table.ncols))    # 打印工作表的名称，表的总行数，表的总列数    print("Cell A18 is {0}".format(table.cell_value(rowx=17, colx=0)))    # 打印单元格的值def test2():    x = random.random()    x = round(number=x, ndigits=1) # 保留一位小数    print(x)def main():    file = xlrd.open_workbook(filename=r'1.xlsx')    table = file.sheets()[0]    wb = copy(wb=file)    for i in range(1, table.nrows):        x = random.uniform(0.1, 0.5) + 29        wb.get_sheet(0).write(i, 2, round(number=x, ndigits=1))    wb.save('2.xlsx')if __name__ == '__main__':    main()

转载地址：http://ahden.baihongyu.com/