会计税务一键式统计2.0

最新推荐文章于 2025-12-01 13:49:36 发布
原创 最新推荐文章于 2025-12-01 13:49:36 发布 · 114 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#python

本文介绍了一个使用Python的openpyxl库来自动化处理Excel文件的方法。该方法能够从多个不同的Excel表格中读取特定数据，并将其汇总到一个新的Excel表格中。 
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_fuzhaibiao_nianchucunhuo=''
ws_fuzhaibiao_zichanheji=''
ws_fuzhaibiao_yingshouzhangkuan=''
ws_fuzhaibiao_cunhuo=''
ws_fuzhaibiao_zichanyuanjia=''
ws_fuzhaibiao_zhejiu=''
ws_fuzhaibiao_bennianzhejiu=''
ws_fuzhaibiao_zichanzongji=''


ws_lirunbiao_yingyeshouru=''
ws_lirunbiao_yingyechengben=''
ws_lirunbiao_fujia=''
ws_lirunbiao_xiaoshoufeiyong =''
ws_lirunbiao_guanlifeiyong=''
ws_lirunbiao_yanfafeiyong=''
ws_lirunbiao_caiwufeiyong=''
ws_lirunbiao_lixishouru=''
ws_lirunbiao_lixifeiyong=''
ws_lirunbiao_guanlifeiyong=''
ws_lirunbiao_yanfafeiyong=''
ws_lirunbiao_caiwufeiyong=''
ws_lirunbiao_lixishouru=''
ws_lirunbiao_lixifeiyong=''
ws_lirunbiao_yingyelirun=''
ws_lirunbiao_yingyewaishouru=''
ws_lirunbiao_yingyewaizhichu=''
ws_lirunbiao_lirunzonge=''
ws_lirunbiao_suodeshuifeiyong=''





ws_nashuishenbaobiao_xiaoxiangshuie=0
ws_nashuishenbaobiao_jinxiangshuie=0
ws_nashuishenbaobiao_jianxiangshuiezhuanchu=0
ws_nashuishenbaobiao_yingtuishuie=0
ws_nashuishenbaobiao_yingnashuie=0
ws_nashuishenbaobiao_yingbujiaoshuie=0
ws_nashuishenbaobiao_yingnashuiejianzhenge=0



nianchucunhuo_row = 0
nianchucunhuo_column = 0



zichanheji_row = 0
zichanheji_column = 0

yingshouzhangkuan_row = 0
yingshouzhangkuan_column = 0

cunhuo_row = 0
cunhuo_column = 0

zichanyuanjia_row = 0
zichanyuanjia_column = 0

zhejiu_row = 0
zhejiu_column = 0

bennianzhejiu_row = 0
bennianzhejiu_column = 0

zichanzongji_row = 0
zichanzongji_column = 0

fuzhaiheji_row = 0
fuzhaiheji_column = 0

yingyeshouru_row = 0
yingyeshouru_column = 0

yingyechengben_row = 0
yingyechengben_column = 0

fujia_row = 0
fujia_column = 0

xiaoshoufeiyong_row = 0
xiaoshoufeiyong_column = 0

guanlifeiyong_row = 0
guanlifeiyong_column = 0

yanfafeiyong_row = 0
yanfafeiyong_column = 0

caiwufeiyong_row = 0
caiwufeiyong_column = 0

lixishouru_row = 0
lixishouru_column = 0

lixifeiyong_row = 0
lixifeiyong_column = 0

yingyelirun_row = 0
yingyelirun_column = 0

yingyewaishouru_row = 0
yingyewaishouru_column = 0

yingyewaizhichu_row = 0
yingyewaizhichu_column = 0

lirunzonge_row = 0
lirunzonge_column = 0

suodeshuifeiyong_row = 0
suodeshuifeiyong_column = 0

yingjiaozengzhishui_row = 0
yingjiaozengzhishui_column = 0

pingjunrenshu_row = 0
pingjunrenshu_column = 0


xiaoxiangshuie_row = 0
xiaoxiangshuie_column = 0


jinxiangshuie_row = 0
jinxiangshuie_column = 0


jinxiangshuiezhuanchu_row = 0
jinxiangshuiezhuanchu_column = 0


yingtuishuie_row = 0
yingtuishuie_column = 0


yingnashuie_row = 0
yingnashuie_column = 0


yingbujiaoshuie_row = 0
yingbujiaoshuie_column = 0



yingnashuiejianzhenge_row = 0
yingnashuiejianzhenge_column = 0


fuzhaiheji_row = 0
fuzhaiheji_column = 0


#####################################################################锁定资产负债表和工作薄
#如下代码用于多个相关表的打开操作
fn_fuzhaibiao = '资产负债表.xlsx'
wb_fuzhaibiao = openpyxl.load_workbook(fn_fuzhaibiao)


fuzhaibiao_allSheets = wb_fuzhaibiao.get_sheet_names()
#print(fuzhaibiao_allSheets)

for i in range(len(fuzhaibiao_allSheets)):
    fuzhaibiao_sheet = wb_fuzhaibiao.get_sheet_by_name(fuzhaibiao_allSheets[i])
    for row in fuzhaibiao_sheet.iter_rows():
        for cell in row:
            if str(str(cell.value).replace(' ', '')).find("资产负债表") != -1:

                fuzhaibiao_sheet = wb_fuzhaibiao.get_sheet_by_name(fuzhaibiao_allSheets[i])
                print(fuzhaibiao_sheet.title)
                break

ws_fuzhaibiao = wb_fuzhaibiao.get_sheet_by_name(fuzhaibiao_sheet.title)





##################################################锁定利润表和工作薄
fn_lirunbiao = '利润表.xlsx'
wb_lirunbiao = openpyxl.load_workbook(fn_lirunbiao)


lirunbiao_allSheets = wb_lirunbiao.get_sheet_names()
#print(fuzhaibiao_allSheets)

for i in range(len(lirunbiao_allSheets)):
    lirunbiao_sheet = wb_lirunbiao.get_sheet_by_name(lirunbiao_allSheets[i])
    print(lirunbiao_sheet)
    for row in lirunbiao_sheet.iter_rows():
        for cell in row:
            if str(str(cell.value).replace(' ', '')).find("利润表") != -1:
                lirunbiao_sheet = wb_lirunbiao.get_sheet_by_name(lirunbiao_allSheets[i])
                print(lirunbiao_sheet.title)
                break

ws_lirunbiao = wb_lirunbiao.get_sheet_by_name(lirunbiao_sheet.title)


##############################################################################锁定财务表和工作薄

fn_caiwuzhuangkuangbiao = '财务状况表.xlsx'
wb_caiwuzhuangkuangbiao = openpyxl.load_workbook(fn_caiwuzhuangkuangbiao)


caiwuzhuangkuangbiao_allSheets = wb_caiwuzhuangkuangbiao.get_sheet_names()
#print(fuzhaibiao_allSheets)

for i in range(len(caiwuzhuangkuangbiao_allSheets)):
    caiwuzhuangkuangbiao_sheet = wb_caiwuzhuangkuangbiao.get_sheet_by_name(caiwuzhuangkuangbiao_allSheets[i])
    print(caiwuzhuangkuangbiao_sheet)
    for row in caiwuzhuangkuangbiao_sheet.iter_rows():
        for cell in row:
            if str(str(cell.value).replace(' ', '')).find("财务状况表") != -1:
                caiwuzhuangkuangbiao_sheet = wb_caiwuzhuangkuangbiao.get_sheet_by_name(caiwuzhuangkuangbiao_allSheets[i])
                print(caiwuzhuangkuangbiao_sheet.title)
                break

ws_caiwuzhuangkuangbiao = wb_caiwuzhuangkuangbiao.get_sheet_by_name(caiwuzhuangkuangbiao_sheet.title)



################################################锁定纳税申报表和工作薄


fn_nashuishenbaobiao = '纳税申报表.xlsx'
wb_nashuishenbaobiao = openpyxl.load_workbook(fn_nashuishenbaobiao)


nashuishenbaobiao_allSheets = wb_nashuishenbaobiao.get_sheet_names()
#print(fuzhaibiao_allSheets)

for i in range(len(nashuishenbaobiao_allSheets)):
    nashuishenbaobiao_sheet = wb_nashuishenbaobiao.get_sheet_by_name(nashuishenbaobiao_allSheets[i])
    print(nashuishenbaobiao_sheet)
    for row in nashuishenbaobiao_sheet.iter_rows():
        for cell in row:
            if str(str(cell.value).replace(' ', '')).find("一般纳税人适用") != -1:
                nashuishenbaobiao_sheet = wb_nashuishenbaobiao.get_sheet_by_name(nashuishenbaobiao_allSheets[i])
                print(nashuishenbaobiao_sheet.title)
                break

ws_nashuishenbaobiao = wb_nashuishenbaobiao.get_sheet_by_name(nashuishenbaobiao_sheet.title)


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

#如下代码用于将多个表中的相关数据写入财务状况表




########### 资产负债表     1年初存货



for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(str(cell.value).replace(' ', '')).find("存货") != -1:
            nianchucunhuo_row = cell.row
        #    print(cunhuo_row)

            break
for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if  str(cell.value).find("年初余额")  != -1 or str(cell.value).find("年初数")  != -1 :
            nianchucunhuo_column = cell.column
         #   print(cunhuo_column)
            break
print("######################")
#print(len(ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value))

#if ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value is  cell.value:
#    print(ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value)

#if  len(str(ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value))  == 0:
 #   print(ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value)



if ws_fuzhaibiao.cell(row= nianchucunhuo_row,column=nianchucunhuo_column).value != None :
    print("hello= ")
    ws_fuzhaibiao_nianchucunhuo =  round(ws_fuzhaibiao.cell(row= nianchucunhuo_row,column=nianchucunhuo_column).value/1000)

########### 资产负债表    2流动资产合计

for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(cell.value).find("流动资产合计") != -1 and str(cell.value).find("非流动资产合计") == -1 :
            zichanheji_row = cell.row
         #   print(zichanheji_row)
            break
for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(cell.value).find("期末余额")  != -1 or str(cell.value).find("期末数")  != -1 :
            zichanheji_column = cell.column
          #  print(zichanheji_column)
            break

if ws_fuzhaibiao.cell(row= zichanheji_row,column=zichanheji_column).value != None :
    ws_fuzhaibiao_zichanheji= round(ws_fuzhaibiao.cell(row=zichanheji_row,column=zichanheji_column).value/1000)




########################################资产负债表  应收账款



for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(cell.value).find("应收账款") != -1  :
            yingshouzhangkuan_row = cell.row
           # print(zichanyuanjia_row)
            break
for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(cell.value).find("期末余额")  != -1 or str(cell.value).find("期末数")  != -1 :
            yingshouzhangkuan_column = cell.column
          #  print(zichanyuanjia_column)
            break


if ws_fuzhaibiao.cell(row= yingshouzhangkuan_row,column=yingshouzhangkuan_column).value != None :
    ws_fuzhaibiao_yingshouzhangkuan=  round(ws_fuzhaibiao.cell(row=yingshouzhangkuan_row,column=yingshouzhangkuan_column).value/1000)



################################      资产负债表    4存货

for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(str(cell.value).replace(' ', '')).find("存货") != -1:
            cunhuo_row = cell.row
        #    print(cunhuo_row)

            break
for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if  str(cell.value).find("期末余额")  != -1 or str(cell.value).find("期末数")  != -1 :
            cunhuo_column = cell.column
         #   print(cunhuo_column)
            break
print("######################")
#print(len(ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value))

#if ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value is  cell.value:
#    print(ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value)

#if  len(str(ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value))  == 0:
 #   print(ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value)



if ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value != None :
    print("hello= ")
    ws_fuzhaibiao_cunhuo =  round(ws_fuzhaibiao.cell(row= cunhuo_row,column=cunhuo_column).value/1000)


########### 资产负债表    5固定资产原价


for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(cell.value).find("固定资产原价") != -1  :
            zichanyuanjia_row = cell.row
           # print(zichanyuanjia_row)
            break
for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(cell.value).find("期末余额")  != -1 or str(cell.value).find("期末数")  != -1 :
            zichanyuanjia_column = cell.column
          #  print(zichanyuanjia_column)
            break


if ws_fuzhaibiao.cell(row= zichanyuanjia_row,column=zichanyuanjia_column).value != None :
    ws_fuzhaibiao_zichanyuanjia=  round(ws_fuzhaibiao.cell(row=zichanyuanjia_row,column=zichanyuanjia_column).value/1000)

########### 资产负债表    6累计折旧

for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(cell.value).find("累计折旧") != -1  :
            zhejiu_row = cell.row
          #  print(zhejiu_row)
            break
for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(cell.value).find("期末余额")  != -1 or str(cell.value).find("期末数")  != -1 :
            zhejiu_column = cell.column
           # print(zhejiu_column)
            break


if ws_fuzhaibiao.cell(row= zhejiu_row,column=zhejiu_column).value != None :
    ws_fuzhaibiao_zhejiu=  round(ws_fuzhaibiao.cell(row=zhejiu_row,column=zhejiu_column).value/1000)

#######################7本年折旧

########### 资产负债表   8资产总计

for row in ws_fuzhaibiao.iter_rows():
    for cell in row:


        if str(str(cell.value).replace(' ','')).find("资产总计") != -1  :

            zichanzongji_row = cell.row
      #      print(zichanzongji_row)
            break
for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(cell.value).find("期末余额")  != -1 or str(cell.value).find("期末数")  != -1 :
            zichanzongji_column = cell.column
           # print(zichanzongji_column)
            break
if ws_fuzhaibiao.cell(row= zichanzongji_row,column=zichanzongji_column).value != None :
    ws_fuzhaibiao_zichanzongji= round(ws_fuzhaibiao.cell(row=zichanzongji_row,column=zichanzongji_column).value/1000)





########### 资产负债表   9负债合计


for row in ws_fuzhaibiao.iter_rows():
    for cell in row:

        if str(str(cell.value).replace(' ','')).find("负债合计")  != -1 and str(cell.value).find("流动负债合计")  == -1 and str(cell.value).find("非流动负债合计")  == -1  :

            fuzhaiheji_row = cell.row
         #   print(fuzhaiheji_row)
            break
for row in ws_fuzhaibiao.iter_rows():
    for cell in row:
        if str(cell.value).find("期末余额")  != -1 or str(cell.value).find("期末数")  != -1 :
            fuzhaiheji_column = cell.column
         #   print(fuzhaiheji_column)
            break

if ws_fuzhaibiao.cell(row= fuzhaiheji_row,column=fuzhaiheji_column).value != None :
    ws_fuzhaibiao_fuzhaiheji= round(ws_fuzhaibiao.cell(row = fuzhaiheji_row , column = fuzhaiheji_column).value/1000)







########### 利润表   10营业收入


for row in ws_lirunbiao.iter_rows():

    for cell in row:
     #   print(cell.value)
        if str(cell.value).find("营业收入") != -1   :

            yingyeshouru_row = cell.row
       #     print(yingyeshouru_row)
            break
for row in ws_lirunbiao.iter_rows():
  #  print(cell.value)
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            yingyeshouru_column = cell.column
        #    print(yingyeshouru_column)
            break
if ws_lirunbiao.cell(row= yingyeshouru_row,column=yingyeshouru_column).value != None :
    ws_lirunbiao_yingyeshouru= round(ws_lirunbiao.cell(row=yingyeshouru_row,column=yingyeshouru_column).value/1000)



########### 利润表    11营业成本

for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("营业成本") != -1   :
            yingyechengben_row = cell.row
          #  print(yingyechengben_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            yingyechengben_column = cell.column
       #     print(yingyechengben_column)
            break

if ws_lirunbiao.cell(row= yingyechengben_row,column=yingyechengben_column).value != None :
    ws_lirunbiao_yingyechengben=  round(ws_lirunbiao.cell(row=yingyechengben_row,column=yingyechengben_column).value/1000)

########### 利润表    12税金及附加


for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("税金及附加") != -1 or str(cell.value).find("主营业务税金及附加") != -1  :
            fujia_row = cell.row
         #   print(fujia_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            fujia_column = cell.column
         #   print(fujia_column)
            break
if ws_lirunbiao.cell(row= fujia_row,column=fujia_column).value != None :
    ws_lirunbiao_fujia=   round(ws_lirunbiao.cell(row=fujia_row,column=fujia_column).value/1000)


########### 利润表    13销售费用


for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("销售费用") != -1 or str(cell.value).find("营业费用") != -1 :
            xiaoshoufeiyong_row = cell.row
          #  print(xiaoshoufeiyong_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            xiaoshoufeiyong_column = cell.column
          #  print(xiaoshoufeiyong_column)
            break

if ws_lirunbiao.cell(row= xiaoshoufeiyong_row,column=xiaoshoufeiyong_column).value != None :
    ws_lirunbiao_xiaoshoufeiyong= round(ws_lirunbiao.cell(row=xiaoshoufeiyong_row,column=xiaoshoufeiyong_column).value/1000)

########### 利润表   14管理费用

for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("管理费用") != -1  :
            guanlifeiyong_row = cell.row
         #   print(guanlifeiyong_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            guanlifeiyong_column = cell.column
         #   print(guanlifeiyong_column)
            break

if ws_lirunbiao.cell(row= guanlifeiyong_row,column=guanlifeiyong_column).value != None :
    ws_lirunbiao_guanlifeiyong= round(ws_lirunbiao.cell(row=guanlifeiyong_row,column=guanlifeiyong_column).value/1000)



########### 利润表  15研发费用 研究费用?

for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("研究费用") != -1 or str(cell.value).find("研发费用") != -1  :
            yanfafeiyong_row = cell.row
         #   print(yanfafeiyong_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            yanfafeiyong_column = cell.column
          #  print(yanfafeiyong_column)
            break

if ws_lirunbiao.cell(row= yanfafeiyong_row,column=yanfafeiyong_column).value != None :
    ws_lirunbiao_yanfa= round(ws_lirunbiao.cell(row=yanfafeiyong_row,column=yanfafeiyong_column).value/1000)





########### 利润表    16财务费用

for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("财务费用") != -1  :
            caiwufeiyong_row = cell.row
          #  print(caiwufeiyong_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            caiwufeiyong_column = cell.column
         #   print(caiwufeiyong_column)
            break


if ws_lirunbiao.cell(row= caiwufeiyong_row,column=caiwufeiyong_column).value != None :
    ws_lirunbiao_caiwufeiyong = round(ws_lirunbiao.cell(row=caiwufeiyong_row,column=caiwufeiyong_column).value/1000)

######################################################### 利润表 17利息收入


for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("利息费用") != -1  :
            lixishouru_row = cell.row
          #  print(caiwufeiyong_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            lixishouru_column = cell.column
         #   print(caiwufeiyong_column)
            break


if ws_lirunbiao.cell(row= lixishouru_row,column=lixishouru_column).value <  0 :
    ws_lirunbiao_lixishouru = round(ws_lixishouru.cell(row=lixishouru_row,column=lixishouru_column).value/1000)


#################################################         利润表  18利息费用

for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("利息费用") != -1  :
            lixifeiyong_row = cell.row
          #  print(caiwufeiyong_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            lixifeiyong_column = cell.column
         #   print(caiwufeiyong_column)
            break


if ws_lirunbiao.cell(row= caiwufeiyong_row,column=caiwufeiyong_column).value >  0 :
    ws_lirunbiao_lixifeiyong = round(ws_lirunbiao.cell(row=lixifeiyong_row,column=lixifeiyong_column).value/1000)


########### 利润表   19营业利润

for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("营业利润") != -1  :
            yingyelirun_row = cell.row
          #  print(yingyelirun_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            yingyelirun_column = cell.column
           # print(yingyelirun_column)
            break


if ws_lirunbiao.cell(row= yingyelirun_row,column=yingyelirun_column).value != None :
    ws_lirunbiao_yingyelirun= round(ws_lirunbiao.cell(row=yingyelirun_row,column=yingyelirun_column).value/1000)


########### 利润表   20营业外收入


for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("营业外收入") != -1  :
            yingyewaishouru_row = cell.row
           # print(yingyewaishouru_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            yingyewaishouru_column = cell.column
          #  print(yingyewaishouru_column)
            break

if ws_lirunbiao.cell(row= yingyewaishouru_row,column=yingyewaishouru_column).value != None :
    ws_lirunbiao_yingyewaishouru= round(ws_lirunbiao.cell(row=yingyewaishouru_row,column=yingyewaishouru_column).value/1000)


########### 利润表   营业外支出

for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("营业外支出") != -1  :
            yingyewaizhichu_row = cell.row
           # print(yingyewaizhichu_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            yingyewaizhichu_column = cell.column
           # print(yingyewaizhichu_column)
            break


if ws_lirunbiao.cell(row= yingyewaizhichu_row,column=yingyewaizhichu_column).value != None :
    ws_lirunbiao_yingyewaizhichu= round(ws_lirunbiao.cell(row=yingyewaizhichu_row,column=yingyewaizhichu_column).value/1000)




########### 利润表   22利润总额


for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("利润总额") != -1  :
            lirunzonge_row = cell.row
          #  print(lirunzonge_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            lirunzonge_column = cell.column
          #  print(lirunzonge_column)
            break


if ws_lirunbiao.cell(row= lirunzonge_row,column=lirunzonge_column).value != None :
    ws_lirunbiao_lirunzonge= round(ws_lirunbiao.cell(row=lirunzonge_row,column=lirunzonge_column).value/1000)


########### 利润表   23所得税费用


for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("所得税费用") != -1  :
            suodeshuifeiyong_row = cell.row
          #  print(suodeshuifeiyong_row)
            break
for row in ws_lirunbiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计数")  != -1 or str(cell.value).find("本年累计金额")  != -1 :
            suodeshuifeiyong_column = cell.column
          #  print(suodeshuifeiyong_column)
            break
if ws_lirunbiao.cell(row= suodeshuifeiyong_row,column=suodeshuifeiyong_column).value != None :
    ws_lirunbiao_suodeshuifeiyong= round(ws_lirunbiao.cell(row=suodeshuifeiyong_row,column=suodeshuifeiyong_column).value/1000)






########### 纳税申报表    应交增值税


##############纳税申报表    应交增值税  24.1 销项税额


for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("销项税额") != -1  :
            xiaoxiangshuie_row = cell.row
            print(xiaoxiangshuie_row)
          #  print(xiaoxiangshuie_row)
            break
for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计") != -1 or  str(cell.value).find("累计金额") != -1 :
            xiaoxiangshuie_column = cell.column
          #  print(xiaoxiangshuie_column)
            break
if ws_nashuishenbaobiao.cell(row= xiaoxiangshuie_row,column=xiaoxiangshuie_column).value != None :
    ws_nashuishenbaobiao_xiaoxiangshuie  =round(ws_nashuishenbaobiao.cell(row=xiaoxiangshuie_row,column=xiaoxiangshuie_column).value/1000)


##############纳税申报表    应交增值税   24.2进项税额


for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("进项税额") != -1  and  str(cell.value).find("进项税额转出") == -1:
            jinxiangshuie_row = cell.row
         #   print(jinxiangshuie_row)
            break
for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计") != -1 or  str(cell.value).find("累计金额") != -1 :
            jinxiangshuie_column = cell.column
          #  print(jinxiangshuie_column)
            break
if ws_nashuishenbaobiao.cell(row= jinxiangshuie_row,column=jinxiangshuie_column).value != None :
    ws_nashuishenbaobiao_jinxiangshuie=  round(ws_nashuishenbaobiao.cell(row=jinxiangshuie_row,column=jinxiangshuie_column).value/1000)



##############纳税申报表    应交增值税   24.3进项税额转出

for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("进项税额转出") != -1  :
            jinxiangshuiezhuanchu_row = cell.row
        #    print(jinxiangshuiezhuanchu_row)
            break
for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计") != -1 or  str(cell.value).find("累计金额") != -1 :
            jinxiangshuiezhuanchu_column = cell.column
         #   print(jinxiangshuiezhuanchu_column)
            break
if ws_nashuishenbaobiao.cell(row= jinxiangshuiezhuanchu_row,column=jinxiangshuiezhuanchu_column).value != None :
    ws_nashuishenbaobiao_jinxiangshuiezhuanchu= round(ws_nashuishenbaobiao.cell(row=jinxiangshuiezhuanchu_row,column=jinxiangshuiezhuanchu_column).value/1000)



##############纳税申报表    应交增值税   24.4免、抵、退应退税额

for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("免、抵、退应退税额") != -1  :
            yingtuishuie_row = cell.row
          #  print(yingtuishuie_row)
            break
for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计") != -1 or  str(cell.value).find("累计金额") != -1 :
            yingtuishuie_column = cell.column
           # print(yingtuishuie_column)
            break


if ws_nashuishenbaobiao.cell(row= yingtuishuie_row,column=yingtuishuie_column).value != None :
    ws_nashuishenbaobiao_yingtuishuie= round(ws_nashuishenbaobiao.cell(row=yingtuishuie_row,column=yingtuishuie_column).value/1000)



##############纳税申报表    应交增值税   24.5简易计税办法计算的应纳税额


for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("简易计税办法计算的应纳税额") != -1  :
            yingnashuie_row = cell.row
          #  print(yingnashuie_row)
            break
for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计") != -1 or  str(cell.value).find("累计金额") != -1 :
            yingnashuie_column = cell.column
          #  print(yingnashuie_column)
            break


if ws_nashuishenbaobiao.cell(row= yingnashuie_row,column=yingnashuie_column).value != None :
    ws_nashuishenbaobiao_yingnashuie= round(ws_nashuishenbaobiao.cell(row=yingnashuie_row,column=yingnashuie_column).value/1000)

##############纳税申报表    应交增值税   24.6按简易计税办法计算的纳税检查应补缴税额


for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("按简易计税办法计算的纳税检查应补缴税额") != -1  :
            yingbujiaoshuie_row = cell.row
          #  print(yingbujiaoshuie_row)
            break
for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计") != -1 or  str(cell.value).find("累计金额") != -1 :
            yingbujiaoshuie_column = cell.column
          #  print(yingbujiaoshuie_column)
            break

if ws_nashuishenbaobiao.cell(row= yingbujiaoshuie_row,column=yingbujiaoshuie_column).value != None :
    ws_nashuishenbaobiao_yingbujiaoshuie= round(ws_nashuishenbaobiao.cell(row=yingbujiaoshuie_row,column=yingbujiaoshuie_column).value/1000)
#print(ws_nashuishenbaobiao_Z31)


##############纳税申报表    应交增值税   24.7应纳税额减征额

for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("应纳税额减征额") != -1  :
            yingnashuiejianzhenge_row = cell.row
          #  print(yingnashuiejianzhenge_row)
            break
for row in ws_nashuishenbaobiao.iter_rows():
    for cell in row:
        if str(cell.value).find("本年累计") != -1 or  str(cell.value).find("累计金额") != -1 :
            yingnashuiejianzhenge_column = cell.column
          #  print(yingnashuiejianzhenge_column)
            break
if ws_nashuishenbaobiao.cell(row= yingnashuiejianzhenge_row,column=yingnashuiejianzhenge_column).value != None :
    ws_nashuishenbaobiao_yingnashuiejianzhenge= round(ws_nashuishenbaobiao.cell(row=yingnashuiejianzhenge_row,column=yingnashuiejianzhenge_column).value/1000)
#print(ws_nashuishenbaobiao_Z32)


ws_caiwuzhuangkuangbiao['E3'] = ws_fuzhaibiao_nianchucunhuo
ws_caiwuzhuangkuangbiao['E5'] = ws_fuzhaibiao_zichanheji
ws_caiwuzhuangkuangbiao['E6'] = ws_fuzhaibiao_yingshouzhangkuan
ws_caiwuzhuangkuangbiao['E7'] = ws_fuzhaibiao_cunhuo
ws_caiwuzhuangkuangbiao['E8'] = ws_fuzhaibiao_zichanzongji
ws_caiwuzhuangkuangbiao['E9'] = ws_fuzhaibiao_fuzhaiheji
ws_caiwuzhuangkuangbiao['E10'] = ws_fuzhaibiao_yingyeshouru
ws_caiwuzhuangkuangbiao['E11'] = ws_fuzhaibiao_C35
ws_caiwuzhuangkuangbiao['E12'] = ws_fuzhaibiao_G26


ws_caiwuzhuangkuangbiao['E14'] = ws_lirunbiao_C4
ws_caiwuzhuangkuangbiao['E15'] = ws_lirunbiao_C5
ws_caiwuzhuangkuangbiao['E16'] = ws_lirunbiao_C6
ws_caiwuzhuangkuangbiao['E17'] = ws_lirunbiao_C14
ws_caiwuzhuangkuangbiao['E23'] = ws_lirunbiao_C24
ws_caiwuzhuangkuangbiao['E24'] = ws_lirunbiao_C25
ws_caiwuzhuangkuangbiao['E25'] = ws_lirunbiao_C27
ws_caiwuzhuangkuangbiao['E26'] = ws_lirunbiao_C33
ws_caiwuzhuangkuangbiao['E27'] = ws_lirunbiao_C34
#如下代码用于将多个表中的相关数据写入财务状况表------特例：利润表中利息费用指标，如果为正计财务状况表的利息收入，如果为负数计财务状况表的利息费用

#print(ws_lirunbiao_C22)




ws_caiwuzhuangkuangbiao['E28'] = ws_nashuishenbaobiao_Z20-ws_nashuishenbaobiao_Z21+ws_nashuishenbaobiao_Z23+ws_nashuishenbaobiao_Z24+ws_nashuishenbaobiao_Z30+ws_nashuishenbaobiao_Z31-ws_nashuishenbaobiao_Z32



#保存财务状况表中修改的数据




wb_caiwuzhuangkuangbiao.save('财务状况表.xlsx')
必看！智能财务AI助手设计中鲜为人知的架构技巧
大数据洞察的博客
08-11 1110
智能财务AI助手是以AI技术为核心，融合财务专业知识，覆盖“数据-决策-执行”全流程的智能系统。感知能力：理解多模态财务数据（文本、表格、图像、语音）；决策能力：基于规则与AI模型生成财务决策（如自动审批、风险预警）；交互能力：通过自然语言与用户交互（如“小财，帮我查一下Q3差旅费总和”）。
一键式统计流程图，待更新
jidawanghao的专栏
03-10 209
税务一键式统计2.0待完善流程图
jidawanghao的专栏
12-16 142
一键式统计5.0基本搞定
jidawanghao的专栏
01-27 117
import os import win32com.client as win32 import shutil import openpyxl import os import win32com.client as win32 import shutil import openpyxl import time import time #####part one fn = {'资产负债表':0,'利润表':0,'纳税申报表':0,'财务状况表':0 } ws = {'资产负债表':0,'利润表':.
终于搞定一键式统计6.0
jidawanghao的专栏
02-01 121
import os import win32com.client as win32 import shutil import openpyxl import time #coding:utf-8 # import os import win32com.client as win32 import shutil import openpyxl import os import win32com.client as win32 import shutil import openpyxl import .
税务会计一键式统计2.0
jidawanghao的专栏
12-21 111
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_fuzhaibiao_D13='' w.
会计税务一键式统计2.0_按照内容锁定动态锁定工作薄，待更新
jidawanghao的专栏
12-21 126
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_fuzhaibiao_D13='' w.
一键式统计管理系统2.0
12-18
"一键式统计管理系统2.0"是一款专为会计和财务管理设计的高效工具，旨在简化复杂的统计过程，提高工作效率。这款系统的核心功能在于能够方便地整合并处理来自不同财务报表的数据，如利润表、资产负债表以及税务报表...
一键式统计管理系统2.0：财务数据导出与报表统计
一键式统计管理系统2.0可能具备与会计软件、税务软件等其他企业管理系统集成的能力，这使得它能够从不同系统中提取必要的财务数据，并对数据进行综合分析。这种集成化的处理方式可以大大提高数据处理的效率和准确性...
Sage One API集成包安装与配置指南
通过 Gulp 配置文件（gulpfile.js），开发者可以定义一系列任务流程，实现“一键部署”式的开发体验，这也是现代 Web 应用开发的标准实践之一。 结合标签信息，“API”显然是整个项目的中心主题，意味着其主要功能...
2025 全电发票“乐企直连+AI 大模型”硬升级：财务人需要掌握的 5 维选型公式与场景化落地路线
a777758的博客
09-11 1108
全电发票"单轨制"转型不仅是格式转换，更是企业财税管理的系统性重构。文章从企业规模、行业特性、技术适配等维度，提出分阶段实施方案：中小企业可选择轻量化SaaS工具（如好会计），日均成本低至0.8元/人；大型企业需业财一体化平台（如泛微业票通），支持智能风控与ERP深度集成。重点提示：必须通过乐企直连认证，满足国产信创要求，并关注AI风控、区块链验真等前沿技术应用。实施路径包括需求调研（1-2周）、试点测试（2-4周）、全面上线（1-2周）三阶段，建议优先选择支持开放API和本地化服
c语言统计空格程序流程图,C语言代码统计器-新版.doc
weixin_39902508的博客
05-23 388
PAGE 2摘 要本课题的主要任务是开发一款代码行数统计器，专门用于统计C语言或C++语言程序代码文件。该统计器的主要功能是统计代码文件的文件行数、有效代码行数、注释行数、空白行数，以及计算代码的注释率。和那些只能统计单个文件的统计器不同，这款统计器能够接受文件夹路径，批量统计整个文件夹的所有文件，包括子文件夹中的有效文件。这样可以大大的提高统计效率，节约用户的时间，使编程人员能集中更多精力编写...
MapReduce读,计算,写流程图
王傲旗的大数据之路
11-19 4979
课堂练习---统计空格流程图、Jackson图
weixin_30416871的博客
04-09 966
统计空格流程图 火车 Jackson图 转载于:https://www.cnblogs.com/qinmiaomiao/p/8763105.html
Python Pandas多列合并成一长列(扁平化)
视觉算法小趴菜的博客
11-29 390
本文介绍了Pandas中三种数据扁平化方法：melt()按变量名和值两列重组数据，concat()垂直拼接多列，stack()将多列转为单列。测试数据显示melt()保留原列名信息，concat()和stack()仅保留数值。三种方法各有特点，适用于不同的数据扁平化需求。
【推荐系统】深度学习训练框架（五）：pyspark分布式TorchDistributor主从读取OSS文件认证机制
人工智能领域博客
11-28 1831
摘要： 本文详细解释了Spark Driver端与Worker端在OSS认证上的核心区别。Driver端通过Spark配置自动认证，而Worker端（独立Python进程）需显式提供认证信息。认证来源优先级为：1)Driver传递参数，2)环境变量，3)IAM角色。文章分析了架构差异导致的不同认证方式，并推荐从Driver传递认证信息的解决方案。当前实现已采用该方案，通过Spark配置或环境变量获取认证后传递给Worker进程，确保PyArrow能正确访问OSS数据。
【Android逆向工程】第8章：Frida 高级应用：函数追踪与 RPC 调用
最新发布
w987333120的博客
12-01 263
本文介绍了Frida框架的核心功能与应用技巧，包括函数调用栈追踪、RPC机制、批量Hook、内存操作和脚本模块化等关键技术。重点讲解了Thread.backtrace()和DebugSymbol.fromAddress()的用法，提供Java和Native函数的调用栈追踪示例，并展示了调用栈过滤与分析方法。最后通过实战案例演示登录流程追踪和RPC调用，同时给出常见问题解决方案。这些技术可有效提升逆向分析效率，适用于移动应用安全测试场景。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值