python修改excel内容怎么覆盖_Python修改Excel的内容,python,excel

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')