财务季报评估报表数据提取+自动撰写2.5

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 = '资产负债表.xlsx'
wb = openpyxl.load_workbook(fn)

ws = wb.get_sheet_by_name('资产负债表')


# print(ws)


def getdate(date_row, date_column):
    # 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
                #  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


def getdate_lastyear(date_row, date_column):
    # 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 + 1
                #  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


def getspeed(date_row, date_column):
    # 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 + 2
                #  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("财务季报评估报告")
    paragraph100 = document.add_paragraph('一、四行业总体情况')

    paragraph101 = document.add_paragraph('1-2季度，济南市财务季报上报单位')
    paragraph101.add_run(str(round(getdate('总计', '企业数'), 1)))
    paragraph101.add_run('个')
    paragraph101.add_run("。其中批发业企业")
    paragraph101.add_run("个，占比")
    paragraph101.add_run("%；零售业企业")
    paragraph101.add_run("个，占比")
    paragraph101.add_run("%；住宿业企业")
    paragraph101.add_run("个，占比")
    paragraph101.add_run("%；餐饮业企业")
    paragraph101.add_run("个，占比")
    paragraph101.add_run("%。")







    paragraph200 = document.add_paragraph('二、财务数据分析')




    paragraph201 = document.add_paragraph('1、资产情况。1-2季度，全市限额以上企业资产总计')
    paragraph201.add_run(str(round(getdate('总计', '资产总计'), 1)))
    paragraph201.add_run('亿元，')
    if(round(getspeed('总计', '资产总计'), 1) > 0):
        paragraph201.add_run('同比增长')
    else:
        paragraph201.add_run('同比下降')
    paragraph201.add_run(str(round(getspeed('总计', '资产总计'), 1)))
    paragraph201.add_run('%。其中，批发业企业资产总计')
    paragraph201.add_run(str(round(getdate('一、批发业', '资产总计'), 1)))
    paragraph201.add_run('亿元，')
    if(round(getspeed('一、批发业', '资产总计'), 1) > 0):
        paragraph201.add_run('同比增长')
    else:
        paragraph201.add_run('同比下降')
    paragraph201.add_run(str(round(getspeed('一、批发业', '资产总计'), 1)))

    paragraph201.add_run('%；零售业企业资产总计')
    paragraph201.add_run(str(round(getdate('二、零售业', '资产总计'), 1)))
    paragraph201.add_run('亿元，')
#############
    if(round(getspeed('二、零售业', '资产总计'), 1) > 0):
        paragraph201.add_run('同比增长')
    else:
        paragraph201.add_run('同比下降')

    paragraph201.add_run(str(round(getspeed('二、零售业', '资产总计'), 1)))


    paragraph201.add_run('%；住宿业企业资产总计')
    paragraph201.add_run(str(round(getdate('三、住宿业', '资产总计'), 1)))
    paragraph201.add_run('亿元，')

    if(round(getspeed('三、住宿业', '资产总计'), 1) > 0):
        paragraph201.add_run('同比增长')
    else:
        paragraph201.add_run('同比下降')

    paragraph201.add_run(str(round(getspeed('三、住宿业', '资产总计'), 1)))
    paragraph201.add_run('%；餐饮业企业资产总计')
    paragraph201.add_run(str(round(getdate('四、餐饮业', '资产总计'), 1)))
    paragraph201.add_run('亿元，')

    if(round(getspeed('四、餐饮业', '资产总计'), 1) > 0):
        paragraph201.add_run('同比增长')
    else:
        paragraph201.add_run('同比下降')

    paragraph201.add_run(str(round(getspeed('四、餐饮业', '资产总计'), 1)))
    paragraph201.add_run('%。')

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


    paragraph202 = document.add_paragraph('2、负债情况。1-2季度，全市限额以上企业负债合计')
    paragraph202.add_run(str(round(getdate('总计', '负债合计'), 1)))
    paragraph202.add_run('亿元，')

    if(round(getspeed('总计', '负债合计'), 1) > 0):
        paragraph202.add_run('同比增长')
    else:
        paragraph202.add_run('同比下降')

    paragraph202.add_run(str(round(getspeed('总计', '负债合计'), 1)))
    paragraph202.add_run('%。其中，批发业企业负债合计')
    paragraph202.add_run(str(round(getdate('一、批发业', '负债合计'), 1)))
    paragraph202.add_run('亿元，')

    if(round(getspeed('一、批发业', '资产总计'), 1) > 0):
        paragraph202.add_run('同比增长')
    else:
        paragraph202.add_run('同比下降')

    paragraph202.add_run(str(round(getspeed('一、批发业', '负债合计'), 1)))
    paragraph202.add_run('%；零售业企业负债合计')
    paragraph202.add_run(str(round(getdate('二、零售业', '负债合计'), 1)))
    paragraph202.add_run('亿元，')

    if(round(getspeed('二、零售业', '负债合计'), 1) > 0):
        para