求帮！xlrd无法读取excel中函数

读取的表格中，我想要读取再输出的单元格数据有函数，目前读取后输出无内容

import xlrd
import xlwt
import os

path = 'data/'
workbook = xlwt.Workbook(encoding='utf-8')  # 新建工作簿
sheet1 = workbook.add_sheet("1")

flag = True
a = b = c = d = 1
e = 2
for file in os.listdir(path):
    x = 0
    xl = xlrd.open_workbook(os.path.join(path, file))
    # xl = xlrd.open_workbook(r'data/1.xlsx')
    if flag:
        name = xl.sheets()[0].col_values(2, 5, 8)
        for i in range(name.__len__()):
            sheet1.write(i + x + 1, 0, name[i])
        x += (name.__len__() + 1)

        name = xl.sheets()[1].col_values(2, 5, 9)
        for i in range(name.__len__()):
            sheet1.write(i + x + 1, 0, name[i])
        sheet1.write(x + name.__len__() + 1, 0, xl.sheets()[1].cell_value(20, 2))
        x += (name.__len__() + 2)

        name = xl.sheets()[2].col_values(1, 4, 6)
        for i in range(name.__len__()):
            sheet1.write(i + x + 1, 0, name[i])
        x += (name.__len__() + 1)

        name = xl.sheets()[3].col_values(1, 5, 9)
        for i in range(name.__len__()):
            sheet1.write(i + x + 1, 0, name[i])
        x += (name.__len__() + 1)

        name = xl.sheets()[4].col_values(1, 5, 92)
        name1 = xl.sheets()[4].col_values(0, 5, 92)
        for i in range(name.__len__()):
            sheet1.write(i + x + 1, 0, name1[i])
            sheet1.write(i + x + 1, 1, name[i])
        x += (name.__len__() + 1)

        flag=False

    x = 0
    data = xl.sheets()[0].col_values(3, 5, 8)
    sheet1.write(x, a, file)
    for i in range(data.__len__()):
        sheet1.write(i + x + 1, a, data[i])
    a += 1
    x += (data.__len__() + 1)

    data = xl.sheets()[1].col_values(3, 5, 9)
    sheet1.write(x, b, file)
    for i in range(data.__len__()):
        sheet1.write(x + i + 1, b, data[i])
    sheet1.write(x + data.__len__() + 1, b, xl.sheets()[1].cell_value(20, 3))
    b += 1
    x += (data.__len__() + 2)

    data = xl.sheets()[2].col_values(2, 4, 6)
    sheet1.write(x, c, file)
    for i in range(data.__len__()):
        sheet1.write(x + i + 1, c, data[i])
    c += 1
    x += (data.__len__() + 1)

    data1 = xl.sheets()[3].col_values(4, 5, 9)
    data2 = xl.sheets()[3].col_values(5, 5, 9)
    sheet1.write(x, d, file)
    for i in range(data1.__len__()):
        sheet1.write(x + i + 1, d, data1[i])
        sheet1.write(x + i + 1, d+1, data2[i])
    d += 2
    x += data1.__len__() + 1

    data = xl.sheets()[4].col_values(2, 5, 71)
    sheet1.write(x, e, file)
    for i in range(data.__len__()):
        sheet1.write(x + i + 1, e, data[i])
    e += 1
    x += (data.__len__() + 1)

workbook.save(r'test.xls')


workbook.save(r'实验输出可变.xls')

简单的等于别的单元格这种函数都无法输出
求帮忙看看是什么问题呀？有没有解决方法呢？

考虑下用openpyxl 库,data_only=True 模式