def dataframe_to_table(df):
t = document.add_table(df.shape[0]+1, df.shape[1])
for j in range(df.shape[-1]):
t.cell(0,j).text = df.columns[j]# add the rest of the data frame
for i in range(df.shape[0]):
for j in range(df.shape[-1]):
t.cell(i+1,j).text = str(df.values[i,j])
return t
df1=pd.read_excel('E:/testfile/a.xlsx')
t1=dataframe_to_table(df1)
t1.cell(1,0).merge(t1.cell(2,0))
t1.cell(3,0).merge(t1.cell(4,0))
t1.cell(5,0).merge(t1.cell(6,0))
t1.cell(7,0).merge(t1.cell(8,0))
t1.cell(1,1).merge(t1.cell(2,1))
t1.cell(3,1).merge(t1.cell(4,1))
t1.cell(5,1).merge(t1.cell(6,1))
t1.cell(7,1).merge(t1.cell(8,1))
t1.cell(1,0).merge(t1.cell(2,0)).text='6'
t1.cell(3,0).merge(t1.cell(4,0)).text='7'
t1.cell(5,0).merge(t1.cell(6,0)).text='8'
t1.cell(7,0).merge(t1.cell(8,0)).text='9'
t1.cell(1,1).merge(t1.cell(2,1)).text='373'
t1.cell(3,1).merge(t1.cell(4,1)).text='380'
t1.cell(5,1).merge(t1.cell(6,1)).text='385'
t1.cell(7,1).merge(t1.cell(8,1)).text='392'
你好,我是有问必答小助手,非常抱歉,本次您提出的有问必答问题,技术专家团超时未为您做出解答
本次提问扣除的有问必答次数,已经为您补发到账户,我们后续会持续优化,扩大我们的服务范围,为您带来更好地服务。