python读取excel表格，并进行相关行列之间的计算，最后将结果存入txt中

import xlrd

# 导入需要读取的第一个Excel表格的路径

data1 = xlrd.open_workbook(r'G:kcptaiping数据分析.xls')
table = data1.sheets()[0]

# 创建一个空列表，存储Excel的数据
tables = []
# 将excel表格内容导入到tables列表中


def import_excel(excel):
    for rown in range(excel.nrows):
        array = []
        for colx in range(table.row_len(1)):
            array.append(table.cell_value(rown, colx))
        tables.append(array)


if __name__ == '__main__':
    #  将excel表格的内容导入到列表中
    import_excel(table)
    A = []   # 存放两行之间的差值
    for i in range(len(tables)):
        B = []
        if i % 2 == 0:  # 判断是否为偶数
            reduce_rown_odd = tables[i]
            reduce_rown_even = tables[i+1]
            for j in range(len(reduce_rown_even)):
                reduce = reduce_rown_even[j] - reduce_rown_odd[j]
                B.append(reduce)
            A.append(B)
    D = []  # 存放最后结果
    for m in range(len(A)):
        C = []
        indx_A = A[m]
        for n in range(len(indx_A)):
            if n % 2 == 0:
                odd = indx_A[n]    # 奇数
                even = indx_A[n+1]   # 偶数
                result = (odd + even) / 2
                C.append(result)
        D.append(C)

    print(D)
    with open('G:/mmdetection-master-5-8/kcp/taiping/result.txt', 'w') as f:
        for i in range(len(D)):
            f.write(str(D[i]))
            f.write('n')
    f.close()