第一次用python解决了个Excel实际问题，纪念一下。。。

from openpyxl import load_workbook
import os

sr = os.path.join(os.path.expanduser('~'), 'desktop')
wb = load_workbook(os.path.join(sr, 'asd.xlsx'))
ws = wb.active
col = ws.max_column
ws.cell(row=1, column=col + 1, value='结果')
dic = {
    1: ['高度近视', 1],
    2: ['中度近视', 2],
    3: ['低度近视', 3],
    0: ['正常', 0]
}


def test(x):
    if x < -6:
        value = dic[1]
    elif -3 >= x >= -5.75:
        value = dic[2]
    elif -1 >= x >= -2.75:
        value = dic[3]
    else:
        value = dic[0]
    return value


def inp(row1, col1, tt):
    ws.cell(row=row1, column=col1, value=tt)


for i in ws.iter_rows(min_row=2, max_row=ws.max_row, min_col=35, max_col=36):
    row = i[0].row
    kk = i[0].value
    kk1 = i[1].value
    if all([kk, kk1]):
        t = float(kk)
        mm1 = test(t)
        inp(row, col + 1, mm1[0])

        x1 = float(kk1)
        mm = test(x1)
        inp(row, col + 2, mm[0])

        max_mm = max(mm[1], mm1[1])
        inp(row, col + 3, dic[max_mm][0])

wb.save(os.path.join(sr, 'asd_do.xlsx'))