python中数据存入execle、读取excel数据

def write_execle_of_reinforcement(time_all, y_single):
    data = xlwt.Workbook()
    # table = data.add_sheet('reinforcement_of_servo')
    # print(len(a))
    outwb = Workbook()
    # 创立工作空间
    outws = outwb.create_sheet(title="jiaodu")
    # 保存在第一列
    for i in range(len(time_all)):
        outws.cell(row=i + 1, column=1).value = time_all[i]
    # 保存在第2列
    for i in range(len(y_single)):
        outws.cell(row=i + 1, column=2).value = y_single[i]
    #将文件保存
    outwb.save('reinforcement_of_servo.xlsx')

import xlrd
import matplotlib.pyplot as plt
def read_20180829():
    fname = "20180829.xlsx"
    bk = xlrd.open_workbook(fname)
    # shxrange = range(bk.nsheets)
    try:
        sh = bk.sheet_by_name("Sheet1")
    except:
        print("no sheet in %s named Sheet1" % fname)
    # 获取行数
    nrows = sh.nrows
    # 获取列数
    ncols = sh.ncols
    # print("nrows %d, ncols %d" % (nrows, ncols))
    # 获取第一行第一列数据
    cell_value = sh.cell_value(1, 0)
    # print(cell_value)
    time = []
    single1 = []
    single2 = []
    single3 = []
    # 获取各行数据
    for i in range(1, nrows):
        row_data = sh.cell_value(i, 0)
        # print('time', row_data)
        time.append(row_data)
    for i in range(1, nrows):
        row_data = sh.cell_value(i, 1)
        # print('a', row_data)
        single1.append(row_data)
    for i in range(1, nrows):
        row_data = sh.cell_value(i, 2)
        # print('a', row_data)
        single2.append(row_data)
    for i in range(1, nrows):
        row_data = sh.cell_value(i, 3)
        # print('a', row_data)
        single3.append(row_data)
    return time,single1,single2,single3