如何在Python中对带有图片的表格进行and抓取并导出到Excel中？

pip install openpyxl
pip install pytesseract
pip install pillow

import openpyxl
import pytesseract
from PIL import Image

image_path = 'path_to_image.png'
image = Image.open(image_path)
text = pytesseract.image_to_string(image)

workbook = openpyxl.Workbook()
sheet = workbook.active

# 将文本按行分割
lines = text.split('\n')

# 将文本写入工作表
for i, line in enumerate(lines):
    # 将每行文本按列分割
    cells = line.split('\t')
    for j, cell in enumerate(cells):
        sheet.cell(row=i+1, column=j+1).value = cell

# 保存Excel文件
output_path = 'path_to_output.xlsx'
workbook.save(output_path)