python可以正确地从excel读取长字符串编号

Question

当我在Linux中读取Python的Excel长数数据时， 它无法获得正确的值：.EG

6666896190981400000

77798171000076400000

它将获得以下值：

6666896190981400064

77779817100000076402688

我尝试添加一个公式来转换为字符串， 并读取配方单元仍然获得错误的价值。 有人对此有好主意吗？ 我的源代码：

from openpyxl import load_workbook
from openpyxl import Workbook
from pycel.excelcompiler import ExcelCompiler

wb = load_workbook(filename="test.xlsx", data_only=True)
ws = wb.active
print("A1:", ws['A1'].value)
col = ws['A']

i = 0
for cell in col:
    i= i+1
    ws['A' + str(i)].number_format = '0'
    ws['B' + str(i)].value = "=\"ID\" & A" + str(i)
    ws['C' + str(i)].value = "=Trim(A" + str(i) + ")"
wb.save('test1.xlsx')
wb.close()

excel = ExcelCompiler('test1.xlsx')
value = excel.evaluate('SHEET1!B1")
print("Value-B1:", value)
value = excel.evaluate('SHEET1!C2')
print("Value-B2:", value)