实例如下所示: from xml.etree.cElementTree import ElementTree,Element import xlrd import re def read_xlsx(xlsx_path): workbook = xlrd.open_workbook(xlsx_path) booksheet = workbook.sheet_by_name("Sheet1") p = list() row_data = [] for row in range(booksheet.nrows): for col in range(booksheet.n