python xlrd 拆分已合并的单元格
文件格式
代码案例(此案例在没有空值的情况下适用xls/xlsx均可)
def chai_excel():
import xlrd
workbook = xlrd.open_workbook('/home/uu/桌面/text.xlsx')
worksheet = workbook.sheet_by_index(0) # 填写读取的子文件
data = []
for rx in range(worksheet.nrows):
line = []
for ry in range(worksheet.ncols):
cell = worksheet.cell_value(rx, ry)
if not cell:
cell = data[-1][ry] if data else ''
line.append(cell)
data.append(line)
for i in data:
print(i)