# 修改了应交增值税 同比下降单位错误的问题 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): # 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("财务季报评估报告") ################################ paragraph01 = document.add_paragraph('封控区') paragraph01.add_run("封控区") paragraph01.add_run(str(getdate('合计', '封控区个数'))) paragraph01.add_run("个,涉及") paragraph01.add_run(str(getdate('合计', '封控区个数'))) paragraph01.add_run("个区、") paragraph01.add_run(str(getdate('合计', '封控区个数'))) paragraph01.add_run("户、") paragraph01.add_run(str(getdate('合计', '封控区个数'))) paragraph01.add_run("人(其中,商河") paragraph01.add_run(str(getdate('商河县', '封控区个数'))) paragraph01.add_run("个,涉及") paragraph01.add_run(str(getdate('合计', '封控区个数'))) paragraph01.add_run("户、") paragraph01.add_run(str(getdate('合计', '封控区个数'))) paragraph01.add_run("人;历城") paragraph01.add_run(str(getdate('历城区', '封控区个数'))) paragraph01.add_run("个,涉及") paragraph01.add_run(str(getdate('合计', '封控区个数'))) paragraph01.add_run("户、") paragraph01.add_run(str(getdate('合计', '封控区个数'))) paragraph01.add_run("人),今日应采检") paragraph01.add_run(str(getdate('合计', '应采检人数'))) paragraph01.add_run("人,已采样") paragraph01.add_run(str(getdate('合计', '已采样数'))) paragraph01.add_run("人,已出结果") paragraph01.add_run(str(getdate('合计', '已出结果'))) paragraph01.add_run("人,均为阴性。") ################################ paragraph02 = document.add_paragraph('管控区') paragraph02.add_run("管控区") paragraph02.add_run(str(getdate('合计', '管控区个数'))) paragraph02.add_run("个,涉及") paragraph02.add_run(str(getdate('合计', '封控区个数'))) paragraph02.add_run("个区、") paragraph02.add_run(str(getdate('合计', '封控区个数'))) paragraph02.add_run("户、") paragraph02.add_run(str(getdate('合计', '封控区个数'))) paragraph02.add_run("人(其中,商河") paragraph02.add_run(str(getdate('商河县', '管控区个数'))) paragraph02.add_run("个,涉及") paragraph02.add_run(str(getdate('合计', '封控区个数'))) paragraph02.add_run("户、") paragraph02.add_run(str(getdate('合计', '封控区个数'))) paragraph02.add_run("人;历城") paragraph02.add_run(str(getdate('历城区', '管控区个数'))) paragraph02.add_run("个,涉及") paragraph02.add_run(str(getdate('合计', '封控区个数'))) paragraph02.add_run("户、") paragraph02.add_run(str(getdate('合计', '封控区个数'))) paragraph02.add_run("人),今日应采检") paragraph02.add_run(str(getdate('合计', '应采检人数'))) paragraph02.add_run("人,已采样") paragraph02.add_run(str(getdate('合计', '封控区个数'))) paragraph02.add_run("人,已出结果") paragraph02.add_run(str(getdate('合计', '封控区个数'))) paragraph02.add_run("人,均为阴性。") ################################ paragraph03 = document.add_paragraph('防范区') paragraph03.add_run(str(getdate('合计', '防范区个数'))) paragraph03.add_run("个,涉及") paragraph03.add_run(str(getdate('合计', '封控区个数'))) paragraph03.add_run("个区、") paragraph03.add_run(str(getdate('合计', '封控区个数'))) paragraph03.add_run("户、") paragraph03.add_run(str(getdate('合计', '封控区个数'))) paragraph03.add_run("人,今日应采检") paragraph03.add_run(str(getdate('合计', '封控区个数'))) paragraph03.add_run("人,已采样") paragraph03.add_run(str(getdate('合计', '封控区个数'))) paragraph03.add_run("人,已出结果") paragraph03.add_run(str(getdate('合计', '封控区个数'))) paragraph03.add_run("人,均为阴性。") print("hello world") print(str(getdate('合计', '封控区个数'))) #paragraph101.add_run('个') document.save('疫情处置快报.docx')
防疫快报快速撰写程序0.02
最新推荐文章于 2024-06-03 11:20:11 发布