word中表格转到excel案例

from docx import Document
from openpyxl import Workbook

doc = Document(r"C:\Users\meiya\PycharmProjects\TransferWebTestCase\name.docx")
t0 = doc.tables[0]
workbook = Workbook()
sheet = workbook.active

for i in range(len(t0.rows)):
    list1 = []
    for j in range(len(t0.columns)):
        list1.append(t0.cell(i,j).text)
    sheet.append(list1)

workbook.save(filename = r"C:\Users\meiya\PycharmProjects\TransferWebTestCase\name.xlsx")

安装docx  pip install python-docx

posted @ 2022-07-15 15:17  Mia妈妈加油呀  阅读(84)  评论(0)    收藏  举报