1200字范文,内容丰富有趣,写作的好帮手!
1200字范文 > python 生成word表格(合并单元格)

python 生成word表格(合并单元格)

时间:2021-07-27 19:56:57

相关推荐

python 生成word表格(合并单元格)

本人使用pycharm,安装库python-docx

代码:

from docx import Documentfrom docx.shared import Inches, Ptfrom docx.oxml.ns import qnfrom docx.enum.text import WD_ALIGN_PARAGRAPHimport time,datetimedocument = Document()document.styles['Normal'].font.name = u'宋体'document.styles['Normal']._element.rPr.rFonts.set(qn('w:eastAsia'), u'宋体')p=document.add_paragraph()p.paragraph_format.alignment = WD_ALIGN_PARAGRAPH.CENTER#table = document.add_table(rows=37,cols=13,style='Table Grid') row:行 col:列table = document.add_table(rows=13,cols=8,style='Table Grid')#生成rows*cols的表格table.autofit = Falsetable.columns[0].width = Inches(1) #设置表格的列宽和高度table.cell(0,0).merge(table.cell(0,2)) #将左上角至右下角坐标的单元格合并在一起table.cell(0,3).merge(table.cell(0,3))table.cell(0,4).merge(table.cell(0,4)) table.cell(0,5).merge(table.cell(0,7))table.cell(1,0).merge(table.cell(1,2))table.cell(1,3).merge(table.cell(1,3))table.cell(1,4).merge(table.cell(1,4))table.cell(1,5).merge(table.cell(1,7))table.cell(2,0).merge(table.cell(2,2))table.cell(2,3).merge(table.cell(2,7))table.cell(3,0).merge(table.cell(12,3))table.cell(3,4).merge(table.cell(12,7))hdr_cells0 = table.rows[0].cellshdr_cells1 = table.rows[1].cellshdr_cells2 = table.rows[2].cellshdr_cells3 = table.rows[3].cellshdr_cells0[0].add_paragraph('线路名称\n').alignment=WD_ALIGN_PARAGRAPH.CENTER #向表格内输入文字hdr_cells0[3].add_paragraph('塔号').alignment=WD_ALIGN_PARAGRAPH.CENTERhdr_cells0[4].add_paragraph('缺陷定性').alignment=WD_ALIGN_PARAGRAPH.CENTERhdr_cells0[5].add_paragraph('经纬度').alignment=WD_ALIGN_PARAGRAPH.CENTERhdr_cells1[0].add_paragraph('10KV园区线').alignment=WD_ALIGN_PARAGRAPH.CENTERhdr_cells1[3].add_paragraph('塔号链接').alignment=WD_ALIGN_PARAGRAPH.CENTERhdr_cells1[4].add_paragraph('缺陷链接').alignment=WD_ALIGN_PARAGRAPH.CENTERhdr_cells1[5].add_paragraph('经纬度链接').alignment=WD_ALIGN_PARAGRAPH.CENTERhdr_cells2[0].add_paragraph('缺陷描述').alignment=WD_ALIGN_PARAGRAPH.CENTERhdr_cells2[3].add_paragraph('缺陷描述链接').alignment=WD_ALIGN_PARAGRAPH.CENTERhdr_cells3[0].add_paragraph('图片链接').alignment=WD_ALIGN_PARAGRAPH.CENTERhdr_cells3[4].add_paragraph('图片链接').alignment=WD_ALIGN_PARAGRAPH.CENTER

结果图:

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。