python用xlrd和xlwt来读取数据整理写入Excel

python用xlrd和xlwt来读取数据整理写入Excel
@[TOC]python用xlrd和xlwt来读取数据整理写入Excel

python用xlrd和xlwt来读取数据整理写入Excel

python用xlrd和xlwt来读取数据整理写入Excel
对多级字段的表格整理成文档模式写入Excel，原有表格对应字段对应只有数据，表格空格多，字段多，数据邵，不好阅读，通过处理可以快速读取成文本，通过读取字段名与值匹配整理删除空置，整后方便阅读和提取数据。
import xlrd
import xlwt
data = xlrd.open_workbook(‘现场调查统计表村.xls’)
workbook = xlwt.Workbook(‘现场调查统计表 .xls’)
##sheet_name = data.sheet_names()
##print(sheet_name)
##sheet2 = data.sheet_by_index(0)
##print(sheet2.name)
##print(sheet2.ncols)
##print(sheet2.nrows)
##sheet1 = data.sheet_by_name(‘狛枝村’)
##print(sheet1.row_values(1))
##print(sheet1.col_values(3))
##print(sheet1.cell(1,2).value)
##print(sheet1.cell_value(1,2))
##print(sheet1.row(1)[2].value)
##print(sheet1.cell(1,2).ctype)#输出数据类型0为emy

##if sheet1.cell(1,1).ctype == 1:
print(sheet1.cell(1,1).value)
sheet1 = data.sheet_by_index(0)
sheet2 = workbook.add_sheet(‘Sheet2’)
sheet2.col(0).width = 3333
sheet2.col(1).width = 33333
lie = sheet1.ncols
hang = sheet1.nrows
for m in range(3,hang):

zhi=''
name=''
for n in range(3,lie):
    if n == lie-1 and zhi != '':

        print(zhi)
        name = zhi[4:].split(",")[0]
        print(name)
        sheet2.write(m-2,0,name)
        sheet2.write(m-2,1,zhi)
        workbook.save('表.xls')
        
    if sheet1.cell(m,n).value !='':
        if sheet1.cell(2,n).value =='':
            if sheet1.cell(1,n).value =='':
                if zhi == '':
                    zhi = sheet1.cell(0,n).value+':'+str(sheet1.cell(m,n).value)
                else:
                    zhi = zhi+','+sheet1.cell(0,n).value+':'+str(sheet1.cell(m,n).value)
            else:
                if zhi == '':
                    zhi = sheet1.cell(1,n).value+':'+str(sheet1.cell(m,n).value)
                else:
                    zhi = zhi+','+sheet1.cell(1,n).value+':'+str(sheet1.cell(m,n).value)
        else:
            if zhi == '':
                    zhi = sheet1.cell(2,n).value+':'+str(sheet1.cell(m,n).value)
            else:
                    zhi = zhi+','+sheet1.cell(2,n).value+':'+str(sheet1.cell(m,n).value)