#读取xslx文件,按列写入列表
from openpyxl import load_workbook
import matplotlib.pyplot as plt
workload = load_workbook('filename')
booksheet = workload.active #GET the first sheet by default.
columns = booksheet.columns
rows = booksheet.rows
EN_loss=[]
EN_acc=[]
CH_loss=[]
CH_acc=[]
for row in rows:
val = row[0].value
EN_loss.append(val)
val1=row[1].value
EN_acc.append(val1)
val2 = row[3].value
CH_loss.append(val2)
val3 = row[4].value
CH_acc.append(val3)