import openpyxl
import os
import os.path as osp
def readexcel(disease,proint,antiint,memoryint,doubleint):
workbook = openpyxl.load_workbook('./text.xlsx')
sheets = workbook.get_sheet_names() # 从名称获取sheet
booksheet = workbook.get_sheet_by_name(sheets[0])
if disease == 'aaa':
position = 'F'
elif disease == 'bbb':
position = 'I'
#初始化,将aaa或bbb列全部置0
for i in range(13,272):
booksheet[position+str(i)] = '0'
#修改值
if proint < 72:
booksheet[position + str(proint)] = '1'
if antiint < 143:
booksheet[position + str(antiint)] = '1'
if antiint < 214:
booksheet[position + str(memoryint)] = '1'
if antiint < 273:
booksheet[position + str(doubleint)] = '1'
workbook.save('./text.xlsx')
source_path = osp.dirname(__file__)
path_01 = source_path+r'./diagnosis.exe'
os.startfile(path_01)
if __name__=="__main__":
readexcel('./text.xlsx','aaa','Correct Rate','vertical')
文章来源: blog.csdn.net,作者:qq_29284813,版权归原作者所有,如需转载,请联系作者。
原文链接:blog.csdn.net/qq_29284813/article/details/109286178