pip install openpyxl  
pip install xlrd  

import xlrd
# 打開(kāi) Excel 文件  
workbook = xlrd.open_workbook('example.xls')
# 獲取第一個(gè)工作表  
sheet = workbook.sheet_by_index(0)
# 遍歷工作表中的所有行和列  
for row in range(sheet.nrows):  
    for col in range(sheet.ncols):  
        cell_value = sheet.cell_value(row, col)  
        print(f'{row}-{col}: {cell_value}')
# 關(guān)閉工作簿  
workbook.close()  

import xlrd
# 打開(kāi) Excel 文件  
workbook = xlrd.open_workbook('example.xls')
# 獲取第一個(gè)工作表  
sheet = workbook.sheet_by_index(0)
# 修改第一個(gè)單元格的值  
sheet.cell(0, 0).value = 'new_value'
# 保存修改后的 Excel 文件  
workbook.save('example_modified.xls')
# 關(guān)閉工作簿  
workbook.close()  

import openpyxl
# 創(chuàng)建新的只讀模式 Excel 文件  
workbook = openpyxl.Workbook(mode='readonly')
# 獲取第一個(gè)工作表  
sheet = workbook.active
# 添加一些數(shù)據(jù)  
sheet['A1'] = 'Hello'  
sheet['B1'] = 'World'
# 保存只讀模式 Excel 文件  
workbook.save('example_readonly.xlsx')
# 關(guān)閉工作簿  
workbook.close()  

import requests  
import xlrd  
from bs4 import BeautifulSoup
# 請(qǐng)求網(wǎng)頁(yè)  
url = 'https://example.com'  
response = requests.get(url)
# 解析網(wǎng)頁(yè)內(nèi)容  
soup = BeautifulSoup(response.text, 'html.parser')
# 提取表格數(shù)據(jù)  
table = soup.find('table')  
rows = table.find_all('tr')
# 創(chuàng)建新的 Excel 文檔  
workbook = xlrd.Workbook()  
sheet = workbook.add_sheet('Table Data')
# 將表格數(shù)據(jù)寫(xiě)入 Excel 文檔  
for row in rows[1:]:  
    cells = row.find_all('td')  
    for col, cell in enumerate(cells):  
        sheet.write(row_num, col, cell.text)
# 保存 Excel 文檔  
workbook.save('example_table.xls')