一键式统计10.0

一键式统计10.0"/>

一键式统计10.0

# 需要进入的第三方库
# pip install pypiwin32
# openpyxl
# shutil
# pyinstaller# 更新了单元格中数值不填写的bug
# 不填写的数据，默认取值为空# coding:utf-8
import os
import win32com.client as win32
import shutil
import openpyxl# import time#####part onedef makedir():mydir = 'bak'  # 基本逻辑就是分两种情况，文件夹有和无，有时，为了避免里面数据污染，删了重建一个；没有则是正常建一个就好if os.path.exists(mydir) == 0:os.mkdir(mydir)else:shutil.rmtree('bak')if os.path.exists(mydir) == 0:os.mkdir(mydir)def movedir():path = os.getcwd()  # 转换前程序所在文件目录path_bak = os.getcwd() + r'/bak/'pathdir_bak = os.listdir(path_bak)pathdir = os.listdir(path)# print(pathdir)for s in pathdir:newdir = os.path.join(path, s)if os.path.isfile(newdir):os.chdir(path_bak)pathdir_bak = os.listdir(path_bak)# print(pathdir_bak)if os.path.splitext(newdir)[1] == ".xls":t = os.path.split(s)[1] + r'x'if os.path.exists(t):#    print(os.path.exists(os.path.split(s)[1]))breakelse:excel = win32.gencache.EnsureDispatch('Excel.Application')wb = excel.Workbooks.Open(newdir)#   print(newdir)path_dir = os.path.split(newdir)[0]path_file = os.path.split(newdir)[1]#  print(path_dir)#   print(path_file)wb.SaveAs(path_dir + '/bak/' + path_file + 'x',FileFormat=51)  # FileFormat = 51 is for .xlsx extensionwb.Close()  # FileFormat = 56 is for .xls extensionexcel.Application.Quit()elif os.path.splitext(newdir)[1] == ".xlsx":file.append(newdir)elif os.path.isdir(newdir):continuefor i in range(len(file)):pcm_file = file[i]path_0 = os.path.split(file[i])[0]path_1 = os.path.split(file[i])[1]oldname = path_0 + '/' + path_1newname = path_0 + r'/bak/' + path_1shutil.copyfile(oldname, newname)# time.sleep(5)  #暂停10秒#####第二步将文件目录切换至bak文件夹中，，切片u v wdef getbaklist(path_deal):pathdir_deal = os.listdir(path_deal)# print(pathdir_deal)path_bak = os.getcwd()pathdir_bak = os.listdir(path_bak)# print(pathdir_bak)for u in pathdir_bak:newdir_deal = os.path.join(path_deal, u)file_deal.append(newdir_deal)# print(file_deal)# print(file_deal)# print(file_deal)def getbooksheet(path, filename):# print( path + r'/' + filename )wb = openpyxl.load_workbook(path + r'/' + filename)allSheets = wb.get_sheet_names()for i in range(len(allSheets)):sheet = wb.get_sheet_by_name(allSheets[i])for row in sheet.iter_rows():for cell in row:if str(str(cell.value).replace(' ', '')).find("资产负债表") != -1:sheet_selected = wb.get_sheet_by_name(allSheets[i])# print(sheet_selected)# print(path_1_deal)# print(path_0_deal)fn['资产负债表'] = path_1_deal# print(fn_fuzhaibiao)ws['资产负债表'] = allSheets[i]# print(type(ws['资产负债表']))# print(ws['资产负债表'])continueelif str(str(cell.value).replace(' ', '')).find("利润表") != -1 or str(str(cell.value).replace(' ', '')).find("损益表") != -1:sheet_selected = wb.get_sheet_by_name(allSheets[i])# print(sheet_selected)# print(path_1_deal)# path['利润表'] = path_0_dealfn['利润表'] = path_1_dealws['利润表'] = allSheets[i]continueelif str(str(cell.value).replace(' ', '')).find("一般纳税人适用") != -1 or str(str(cell.value).replace(' ', '')).find("小规模纳税人适用") != -1:sheet_selected = wb.get_sheet_by_name(allSheets[i])# print(sheet_selected)# print(path_1_deal)# path['纳税申报表'] = path_0_dealfn['纳税申报表'] = path_1_deal# print(path_1_deal)ws['纳税申报表'] = allSheets[i]continueelif str(str(cell.value).replace(' ', '')).find("***子表开始") != -1:sheet_selected = wb.get_sheet_by_name(allSheets[i])# print(sheet_selected)# print(path_1_deal)# path['财务状况表'] = path_0_dealfn['财务状况表'] = path_1_deal# print(fn['财务状况表'])ws['财务状况表'] = allSheets[i]# print(type(ws['资产负债表']))continuewb.close()'''
def getbooksheet():for j in range(len(file_deal)):pcm_file_deal = file_deal[j]path_0_deal = os.path.split(file_deal[j])[0]  # 文件所在目录path_1_deal = os.path.split(file_deal[j])[1]  # 文件名称带后缀#  print(pcm_file_deal)#  print(path_0_deal)# print(path_1_deal)wb = openpyxl.load_workbook(path_1_deal)allSheets = wb.get_sheet_names()for i in range(len(allSheets)):sheet = wb.get_sheet_by_name(allSheets[i])for row in sheet.iter_rows():for cell in row:#print(cell.value)if str(str(cell.value).replace(' ', '')).find("资产负债表") != -1:sheet_selected = wb.get_sheet_by_name(allSheets[i])# print(sheet_selected)# print(path_1_deal)#print(path_0_deal)fn['资产负债表'] = path_1_deal# print(fn_fuzhaibiao)ws['资产负债表'] = allSheets[i]#print(type(ws['资产负债表']))#print(ws['资产负债表'])continueelif str(str(cell.value).replace(' ', '')).find("利润表") != -1 or str(str(cell.value).replace(' ', '')).find("损益表") != -1:sheet_selected = wb.get_sheet_by_name(allSheets[i])# print(sheet_selected)# print(path_1_deal)#path['利润表'] = path_0_dealfn['利润表'] = path_1_dealws['利润表'] = allSheets[i]continueelif str(str(cell.value).replace(' ', '')).find("一般纳税人适用") != -1 or str(str(cell.value).replace(' ', '')).find("小规模纳税人适用") != -1:sheet_selected = wb.get_sheet_by_name(allSheets[i])# print(sheet_selected)# print(path_1_deal)# path['纳税申报表'] = path_0_dealfn['纳税申报表'] = path_1_deal#print(path_1_deal)ws['纳税申报表'] = allSheets[i]continueelif str(str(cell.value).replace(' ', '')).find("***子表开始") != -1:sheet_selected = wb.get_sheet_by_name(allSheets[i])# print(sheet_selected)# print(path_1_deal)# path['财务状况表'] = path_0_dealfn['财务状况表'] = path_1_deal#print(fn['财务状况表'])ws['财务状况表'] = allSheets[i]# print(type(ws['资产负债表']))continue
'''def getdata(path, filename, worksheet, data_row, data_column):wb = openpyxl.load_workbook(path + r'/' + filename)ws = wb.get_sheet_by_name(worksheet)getdata_result = 0row_result = 0row_column = 0column_result = 0column_temp = 0stop_row = 0stop_column = 0for row in ws.iter_rows():for cell in row:if stop_row == 1:breakelse:for i in range(len(data_row)):if str(str(cell.value).replace(' ', '')).find(data_row[i]) != -1:# print(data_row[i])row_result = cell.rowprint(row_result)column_temp = cell.columnstop_row = 1breakfor row in ws.iter_rows():for cell in row:if stop_column == 1:breakelse:for i in range(len(data_column)):if str(str(cell.value).replace(' ', '')).find(data_column[i]) != -1 and cell.column > column_temp:# print(data_column[i])column_result = cell.columnprint(column_result)stop_column = 1break# print(row_result)# print(column_result)if row_result == 0 or column_result == 0:getdata_result = 0else:if ws.cell(row=row_result, column=column_result).value != None:# print(ws_source.cell(row=row_result, column=column_result).value)getdata_result = ws.cell(row=row_result, column=column_result).valueprint(getdata_result)wb.close()return getdata_resultdef writedata(path, filename, worksheet, data_row, data_column, data_write):# print( path + r'/' + filename )wb = openpyxl.load_workbook(path + r'/' + filename)# print(wb)ws = wb.get_sheet_by_name(worksheet)row_result = 0row_column = 0column_result = 0column_temp = 0stop_row = 0stop_column = 0for row in ws.iter_rows():for cell in row:if stop_row == 1:breakelse:for i in range(len(data_row)):if str(str(cell.value).replace(' ', '')).find(data_row[i]) != -1:# print(data_row[i])row_result = cell.rowprint(row_result)column_temp = cell.columnstop_row = 1breakfor row in ws.iter_rows():for cell in row:if stop_column == 1:breakelse:for i in range(len(data_column)):if str(str(cell.value).replace(' ', '')).find(data_column[i]) != -1 and cell.column > column_temp:# print(data_column[i])column_result = cell.columnprint(column_result)stop_column = 1break# print(data_write)if row_result == 0 or column_result == 0:print("未获取需要写入的行或列号")else:print(len(str(data_write)))if len(str(data_write)) == 0:data_write = 0ws.cell(row=row_result, column=column_result).value = round(data_write / 1000, 0)else:ws.cell(row=row_result, column=column_result).value = round(data_write / 1000, 0)# print(data_write)# print(data_write)wb.save(filename)wb.closedef writedata_especial(path, filename, worksheet, data_row, data_row_especial, data_column, data_write):# print( path + r'/' + filename )wb = openpyxl.load_workbook(path + r'/' + filename)# print(wb)ws = wb.get_sheet_by_name(worksheet)row_result = 0row_column = 0column_result = 0column_temp = 0stop_row = 0stop_column = 0for row in ws.iter_rows():for cell in row:if stop_row == 1:breakelse:for i in range(len(data_row)):if str(str(cell.value).replace(' ', '')).find(data_row[i]) != -1 and str(str(cell.value).replace(' ', '')).find(data_row_especial[0]) == -1:# print(data_row[i])row_result = cell.rowprint(row_result)column_temp = cell.columnstop_row = 1breakfor row in ws.iter_rows():for cell in row:if stop_column == 1:breakelse:for i in range(len(data_column)):if str(str(cell.value).replace(' ', '')).find(data_column[i]) != -1 and cell.column > column_temp:# print(data_column[i])column_result = cell.columnprint(column_result)stop_column = 1break# print(data_write)if row_result == 0 or column_result == 0:print("未获取需要写入的行或列号")else:print(len(str(data_write)))if len(str(data_write)) == 0:data_write = 0ws.cell(row=row_result, column=column_result).value = round(data_write / 1000, 0)else:ws.cell(row=row_result, column=column_result).value = round(data_write / 1000, 0)# print(data_write)wb.save(filename)wb.closeif __name__ == '__main__':file = []file_deal = []fn = {'资产负债表': 0, '利润表': 0, '纳税申报表': 0, '财务状况表': 0}ws = {'资产负债表': 0, '利润表': 0, '纳税申报表': 0, '财务状况表': 0}makedir()movedir()getbaklist(os.getcwd())for i in range(len(file_deal)):pcm_file_deal = file_deal[i]path_0_deal = os.path.split(file_deal[i])[0]path_1_deal = os.path.split(file_deal[i])[1]# print(path_0_deal)# print(path_1_deal)getbooksheet(path_0_deal, path_1_deal)# print(fn)# print(ws)###第一部分：全都是资产负债表，准备批量处理下print(getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['存货'], ['年初余额', '年初数']))###写入操作# 季报/年报---年初存货writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['年初存货'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['存货'], ['年初余额', '年初数', '期初余额']))# 季报/年报---流动资产合计writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['流动资产合计'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['流动资产合计'], ['期末余额', '期末数']))# 季报/年报---应收账款writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['应收账款'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['应收账款'], ['期末余额', '期末数']))# 季报/年报---存货 期末数writedata_especial(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['存货'], ['年初存货'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['存货'], ['期末余额', '期末数']))# 季报/年报---固定资产原价writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['固定资产原价'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['固定资产原价'], ['期末余额', '期末数']))# 年报---房屋和构筑物# 年报---机器设备# writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['无形资产'],['1-本季','本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'],['无形资产'],['期末余额','期末数']))# 季报/年报---累计折旧writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['累计折旧'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['累计折旧'], ['期末余额', '期末数']))# 季报/年报---本年折旧# 年报---固定资产净额# 年报---在建工程# 年报---无形资产# 年报---土地使用权# 季报---资产总计writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['资产总计'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['资产总计'], ['期末余额', '期末数']))# 季报/年报---流动负债合计writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['流动负债合计'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['流动负债合计'], ['期末余额', '期末数']))# 年报---应付账款writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['应付账款'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['应付账款'], ['期末余额', '期末数']))# 季报/年报---负债合计writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['负债合计'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['负债合计'], ['期末余额', '期末数']))# 年报---所有者权益合计writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['所有者权益合计'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['所有者权益合计'], ['期末余额', '期末数']))# 年报---实收资本writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['实收资本'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'], ['实收资本'], ['期末余额', '期末数']))# 年报---个人资本# writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['个人资本'],['1-本季','本年'],getdata(os.getcwd() + r'/', fn['资产负债表'], ws['资产负债表'],['个人资本'],['期末余额','期末数']))###第二部分：全都是利润表，准备批量处理下# 季报/年报---营业收入writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['营业收入'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['营业收入'], ['本年累计数', '本年累计金额']))# 年报---主营业务收入# 季报/年报---营业成本writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['营业成本'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['营业成本'], ['本年累计数', '本年累计金额']))# 季报/年报---税金及附加writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['税金及附加'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['税金及附加'], ['本年累计数', '本年累计金额']))# 季报/年报---销售费用writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['销售费用'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['销售费用'], ['本年累计数', '本年累计金额']))# 季报/年报---管理费用print("管理费用---------------------")writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['管理费用'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['管理费用'], ['本年累计数', '本年累计金额']))# 季报/年报---研发费用writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['研发费用'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['研究费用', '研发费用'], ['本年累计数', '本年累计金额']))# 季报/年报---财务费用writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['财务费用'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['财务费用'], ['本年累计数', '本年累计金额']))# 季报/年报---利息收入writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['利息收入'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['利息费用'], ['本年累计数', '本年累计金额']))# 季报/年报---利息费用# writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['利息费用'],['1-本季','本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'],['利息费用'],['本年累计数','本年累计金额']))# 投资收益/年报writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['投资收益'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['投资收益'], ['期末余额', '期末数']))# 季报/年报---营业利润writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['营业利润'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['营业利润'], ['本年累计数', '本年累计金额']))# 季报/年报---营业外收入writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['营业外收入'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['营业外收入'], ['本年累计数', '本年累计金额']))# 季报/年报---营业外支出writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['营业外支出'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['营业外支出'], ['本年累计数', '本年累计金额']))# 季报/年报---利润总额writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['利润总额'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['利润总额'], ['本年累计数', '本年累计金额']))# 季报/年报---所得税费用writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['所得税费用'], ['1-本季', '本年'],getdata(os.getcwd() + r'/', fn['利润表'], ws['利润表'], ['所得税费用'], ['本年累计数', '本年累计金额']))# 年报---应付职工薪酬# 季报/年报---应交.增值税= 销项税额 -（进项税额 - 进项税额转出 - 免、抵、退应退税额）+ 简易计税办法计算的应纳税额 + 按简易计税办法计算的纳税检查应补缴税额 - 应征税额减征额# writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['应交增值税'], ['1-本季', '本年'], getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['销项税额'], ['本年累计', '累计金额']) - getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['进项税额'], ['本年累计', '累计金额']) - getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['进项税额转出'], ['本年累计', '累计金额']) - getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['简易计税办法计算的应纳税额'], ['本年累计', '累计金额'])) + getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['按简易计税办法计算的纳税检查应补缴税额'], ['本年累计', '累计金额']) - getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['应征税额减征额'], ['本年累计', '累计金额']))###第三部分：全都是纳税申报表，准备批量处理下print("销项税")print(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['销项税额'], ['本年累计', '累计金额']))print(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['进项税额'], ['本年累计', '累计金额']))print(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['进项税额转出'], ['本年累计', '累计金额']))print(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['简易计税办法计算的应纳税额'], ['本年累计', '累计金额']))print(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['按简易计税办法计算的纳税检查应补缴税额'], ['本年累计', '累计金额']))print(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['应征税额减征额'], ['本年累计', '累计金额']))xiaoxiangshui = getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['销项税额'], ['本年累计', '累计金额'])jinxiang = getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['进项税额'], ['本年累计', '累计金额'])jinxiangzhuan = getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['进项税额转出'], ['本年累计', '累计金额'])chukoudi = getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['简易计税办法计算的应纳税额'], ['本年累计', '累计金额'])jianmian = getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['按简易计税办法计算的纳税检查应补缴税额'], ['本年累计', '累计金额'])chukoutui = getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['应征税额减征额'], ['本年累计', '累计金额'])yingjiaozengzhishui = xiaoxiangshui - (jinxiang - jinxiangzhuan) - chukoudi - jianmian + chukoutuiwritedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['应交增值税'], ['1-本季', '本年'], yingjiaozengzhishui)# writedata(os.getcwd() + r'/', fn['财务状况表'], ws['财务状况表'], ['应交增值税'], ['1-本季', '本年'],   int(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['销项税额'], ['本年累计', '累计金额'])) - int(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['进项税额'], ['本年累计', '累计金额'])) - int(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['进项税额转出'], ['本年累计', '累计金额'])) - int(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['简易计税办法计算的应纳税额'], ['本年累计', '累计金额']))) + int(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['按简易计税办法计算的纳税检查应补缴税额'], ['本年累计', '累计金额'])) - int(getdata(os.getcwd() + r'/', fn['纳税申报表'], ws['纳税申报表'], ['应征税额减征额'], ['本年累计', '累计金额']))# 季报/年报---从事批发和零售业活动的从业人员平均人数