Aion.Liu $ pip install xlrd
Collecting xlrd
  Downloading xlrd-2.0.1-py2.py3-none-any.whl(96 kB)     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 96.5/96.5 kB 18.1 kB/s eta 0:00:00Installing collected packages: xlrd
Successfully installed xlrd-2.0.1Aion.Liu $ pip install xlwt
Collecting xlwt
  Downloading xlwt-1.3.0-py2.py3-none-any.whl(99 kB)     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 100.0/100.0 kB 11.9 kB/s eta 0:00:00Installing collected packages: xlwt
Successfully installed xlwt-1.3.0

>>> import xlwt
>>> # 创建一个表格
>>> xlwt.Workbook(encoding ="utf8")<xlwt.Workbook.Workbook object at 0x105c190f0>>>> # 设置表格编码
>>> workbook = xlwt.Workbook(encoding ="utf8")>>> # 增加sheet页
>>> worksheet = workbook.add_sheet('python_study_users')>>> # 将数据写入指定单元格
>>> worksheet.write(0,0,"python")>>>>>> worksheet.write(0,1,"张三")>>>>>> worksheet.write(0,3,"男")>>> # 保存数据到文件
>>> workbook.save("python_users.xls")>>>>>> exit()

Aion.Liu $ ll
total 16drwxr-xr-x   3 Aion.Liu  staff    9681022:09 ./drwxr-xr-x  10 Aion.Liu  staff   32081021:59 ../-rw-r--r--   1 Aion.Liu  staff  5632  8 10 22:09 python_users.xls

def body_style():    # 一、创建一个样式对象，初始化样式 style
    style = xlwt.XFStyle()  # Create Style对象
    # 二、字体风格设置
    font = xlwt.Font()  # Create Font对象
    font.name="SimSun"  # 设置字体类型，宋体
    font.colour_index=4  # 设置字体颜色
    font.height=20*12  # 字体大小，12为字号，20为衡量单位
    font.bont=True  # 设置字体加粗
    font.underline=True  # 下划线
    font.italic=True  # 斜体字
    # 二、背景设置
    pattern = xlwt.Pattern()    pattern.pattern= xlwt.Pattern.SOLID_PATTERN  # May be: NO_PATTERN, SOLID_PATTERN,or0x00 through 0x12    pattern.pattern_fore_colour=4  # 给背景颜色赋值
    # 三、边框设置
    borders = xlwt.Borders()  # 创建边框对象，    # .DASHED：虚线；.NO_LINE：没有
    # 上下左右都添加边框
    borders.left=1    borders.right=1    borders.top=1    borders.bottom=1    # 设置边框颜色
    borders.left_colour=2    borders.right_colour=2    borders.top_colour=2    borders.bottom_colour=2    # 四、位置设置
    alignment = xlwt.Alignment()    alignment.horz=1  # 设置水平位置，0是左对齐，1是居中，2是右对齐
    alignment.wrap=1  # 设置自动换行
    # 五、设置好之后，全部都加到style上
    style.alignment= alignment
    style.font= font
    style.borders= borders
    return style

>>> import xlrd
>>> # 打开文件
>>> workbook = xlrd.open_workbook("./python_users.xls")>>> print(workbook)<xlrd.book.Book object at 0x10867db40>>>> # 打印所有的sheet页
>>> print(workbook.sheet_names())['python_study_users']>>> # 根据索引号，打印所有的sheet页
>>> print(workbook.sheet_by_index(0))Sheet  0:<python_study_users>>>> # 根据索引号，打印所有的sheet页（我打印一个Excel中没有的索引号）
>>> print(workbook.sheet_by_index(1))Traceback (most recent call last):  File "<stdin>", line 1,in<module>  File "/usr/local/lib/python3.10/site-packages/xlrd/book.py", line 450,in sheet_by_index
    return self._sheet_list[sheetx]or self.get_sheet(sheetx)IndexError: list index out of range
>>> # 根据sheet页名称，打印所有的sheet页
>>> print(workbook.sheet_by_name("python_study_users"))Sheet  0:<python_study_users>>>> # 根据sheet页名称，打印所有的sheet页（我打印一个Excel中没有的sheet名称）
>>> print(workbook.sheet_by_name("python_study_users2"))Traceback (most recent call last):  File "/usr/local/lib/python3.10/site-packages/xlrd/book.py", line 466,in sheet_by_name
    sheetx = self._sheet_names.index(sheet_name)ValueError:'python_study_users2'isnotin list
During handling of the above exception, another exception occurred:Traceback (most recent call last):  File "<stdin>", line 1,in<module>  File "/usr/local/lib/python3.10/site-packages/xlrd/book.py", line 468,in sheet_by_name
    raise XLRDError('No sheet named <%r>'% sheet_name)xlrd.biffh.XLRDError: No sheet named <'python_study_users2'>>>>

# 1.获取sheet表总函数：sheet.nrowsprint("总行数为：", sheet_1.nrows)# 2.返回由该行中所有的单元格对象组成的列表，列表内是键值对: sheet.row(1)print(sheet_1.row(1))# 或者sheet.row_slice(1)print(sheet_1.row_slice(1))# 3.返回指定行的所有单元格数值组成的列表: sheet.row_values(rowx, start_colx=0,end_colx=None)print(sheet_1.row_values(1))# 4.返回指定行的有效长度：sheet.row_len(rowx)print("返回指定行的有效长度：", sheet_1.row_len(1))print('-'*20)# 5. 读取整个表
for i in range(sheet_1.nrows):    print(sheet_1.row_values(i))

# 1. 返回指定sheet表的有效列数：sheet.ncolsprint("总列数为：", sheet_1.ncols)# 2. 返回由该列中所有的单元格对象组成的列表，列表内是键值对：sheet.col(1)print(sheet_1.col(1))# 或者sheet.col_slice(1)print(sheet_1.col_slice(1))# 3. 返回指定列的所有单元格数值组成的列表：sheet.col_values(colx, start_colx=0, end_colx=None)print(sheet_1.col_values(0))  # 带列名
print(sheet_1.col_values(0,1))  # 不带列名
print('-'*20)# 4. 读取全部表
for i in range(sheet_1.ncols):    print(sheet_1.col_values(i))