防疫快报快速撰写程序0.03

# 修改了应交增值税  同比下降单位错误的问题
from docx import Document
from docx.shared import Inches

document = Document()

from openpyxl import load_workbook

'''
@File    :
@Author  :  william
@Time    :  2020/09/29
@notice  ：  null
@coding  : utf-8
'''
# import xlrd
# from xlutils.copy import copy
import openpyxl

# 下一步还得训练程序
# 使其满足对excel文件名和excel工作薄的识别
# 记得把表格再粘贴下，转成仅值


ws = 0
row_result = 0
column_result = 0
result = 0

#####################################################################锁定资产负债表和工作薄
# 如下代码用于多个相关表的打开操作
fn = '疫情处置工作快报（第21期）附表24时.xlsx'
wb = openpyxl.load_workbook(fn)

ws = wb.get_sheet_by_name('表3三区')


# print(ws)


def getdate(date_row, date_column, offset):
    # print(date_row)
    # print(date_column)

    for row in ws.iter_rows():
        for cell in row:
            if str(str(cell.value).replace(' ', '')).find(date_row) != -1:
                row_result = cell.row
            # print(row_result)
            else:
                result = 0

                break
    for row in ws.iter_rows():
        for cell in row:
            if str(str(cell.value).replace(' ', '')).find(date_column) != -1:
                column_result = cell.column  +  offset
                #  print(column_result)

                break
    # print(column_result)
    if row_result == 0 or column_result == 0:
        result = 0

    else:
        if ws.cell(row=row_result, column=column_result).value != None:
            # print(column_result)
            result = ws.cell(row=row_result, column=column_result).value
        # print(result)

    return result




if __name__ == '__main__':

    #document.add_heading("财务季报评估报告")





################################

    paragraph01 = document.add_paragraph('封控区')
    paragraph01.add_run("封控区")
    paragraph01.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph01.add_run("个，涉及")
    fengkongqu_quxian = 0
    if getdate('历下区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('市中区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('槐荫区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('天桥区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('历城区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('长清区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('章丘区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('济阳区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('莱芜区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('钢城区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('平阴县', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('商河县', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('高新区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('南部山区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    if getdate('起步区', '封控区个数',0)>0 :
        fengkongqu_quxian = fengkongqu_quxian + 1
    paragraph01.add_run(str(fengkongqu_quxian))
    paragraph01.add_run("个区、")

    paragraph01.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph01.add_run("个区、")
    paragraph01.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph01.add_run("户、")
    paragraph01.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph01.add_run("人（其中，商河")
    paragraph01.add_run(str(getdate('商河县', '封控区个数',0)))
    paragraph01.add_run("个，涉及")
    paragraph01.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph01.add_run("户、")
    paragraph01.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph01.add_run("人；历城")
    paragraph01.add_run(str(getdate('历城区', '封控区个数',0)))
    paragraph01.add_run("个，涉及")
    paragraph01.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph01.add_run("户、")
    paragraph01.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph01.add_run("人），今日应采检")
    paragraph01.add_run(str(getdate('合计', '封控区个数',1)))
    paragraph01.add_run("人，已采样")
    paragraph01.add_run(str(getdate('合计', '封控区个数',2)))
    paragraph01.add_run("人，已出结果")
    paragraph01.add_run(str(getdate('合计', '封控区个数',3)))
    # 封控区本轮检测结果为阳性的数量：print(getdate('合计', '封控区个数',4))
    if (getdate('合计', '封控区个数',4)  == 0 ):

        paragraph01.add_run("人，均为阴性。")

################################

    paragraph02 = document.add_paragraph('管控区')
    paragraph02.add_run("管控区")
    paragraph02.add_run(str(getdate('合计', '管控区个数',0)))
    paragraph02.add_run("个，涉及")
    
    guankongqu_quxian = 0
    if getdate('历下区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('市中区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('槐荫区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('天桥区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('历城区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('长清区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('章丘区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('济阳区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('莱芜区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('钢城区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('平阴县', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('商河县', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('高新区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('南部山区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    if getdate('起步区', '管控区个数',0)>0 :
        guankongqu_quxian = guankongqu_quxian + 1
    paragraph02.add_run(str(guankongqu_quxian))
    paragraph02.add_run("个区、")
    paragraph02.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph02.add_run("户、")
    paragraph02.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph02.add_run("人（其中，商河")
    paragraph02.add_run(str(getdate('商河县', '管控区个数',0)))
    paragraph02.add_run("个，涉及")
    paragraph02.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph02.add_run("户、")
    paragraph02.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph02.add_run("人；历城")
    paragraph02.add_run(str(getdate('历城区', '管控区个数',0)))
    paragraph02.add_run("个，涉及")
    paragraph02.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph02.add_run("户、")
    paragraph02.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph02.add_run("人），今日应采检")
    paragraph02.add_run(str(getdate('合计', '管控区个数',1)))
    paragraph02.add_run("人，已采样")
    paragraph02.add_run(str(getdate('合计', '管控区个数',2)))
    paragraph02.add_run("人，已出结果")
    paragraph02.add_run(str(getdate('合计', '管控区个数',3)))
    # 管控区本轮检测结果为阳性的数量：print(getdate('合计', '管控区个数',4))
    if (getdate('合计', '管控区个数',4)  == 0 ):

        paragraph02.add_run("人，均为阴性。")


################################
    paragraph03 = document.add_paragraph('防范区')
    paragraph03.add_run(str(getdate('合计', '防范区个数',0)))
    paragraph03.add_run("个，涉及")


    fangfanqu_quxian = 0
    if getdate('历下区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('市中区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('槐荫区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('天桥区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('历城区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('长清区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('章丘区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('济阳区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('莱芜区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('钢城区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('平阴县', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('商河县', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('高新区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('南部山区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    if getdate('起步区', '防范区个数',0)>0 :
        fangfanqu_quxian = fangfanqu_quxian + 1
    paragraph03.add_run(str(fangfanqu_quxian))




    paragraph03.add_run("个区、")
    paragraph03.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph03.add_run("户、")
    paragraph03.add_run(str(getdate('合计', '封控区个数',0)))
    paragraph03.add_run("人，今日应采检")
    paragraph03.add_run(str(getdate('合计', '防范区个数',1)))
    paragraph03.add_run("人，已采样")
    paragraph03.add_run(str(getdate('合计', '防范区个数',2)))
    paragraph03.add_run("人，已出结果")
    paragraph03.add_run(str(getdate('合计', '防范区个数',3)))
    # 防范区本轮检测结果为阳性的数量：print(getdate('合计', '防范区个数',4))
    if (getdate('合计', '防范区个数',4)  == 0 ):

        paragraph03.add_run("人，均为阴性。")


    print("hello world")

    print(str(getdate('合计', '封控区个数',0)))







    #paragraph101.add_run('个')

    document.save('疫情处置快报.docx')