word2excel python code

51 阅读1分钟

将word表格数据转换成xlsx文件 import docx from docx import Document from openpyxl import Workbook

create xlsx file

Workbook = Workbook() sheet = Workbook.active header = ['序号', '部门','问题', '参考答案'] sheet.append(header)

load word content(document object)

doc = Document('D:\python_load_web_data\test.docx') tb = doc.tables for i in range(len(tb)): tb = tb[i] # 获取表格的行 tb_rows = tb.rows # 读取每一行内容 for i in range(len(tb_rows)): row_data = [] row_cells = tb_rows[i].cells # 读取每一行单元格内容 for cell in row_cells: # 单元格内容 row_data.append(cell.text) sheet.append(row_data) print(row_data) Workbook.save(r'D:\python_load_web_data\dyout.xlsx') # write content to xlsx file print('word2excel finished')