xlsx' bug

[jayzh1010]

my Python version is 2.7;
'11111111111111111111' or 11111111111111111111 both will truncated to 11111111111111100000;
maybe the openpyxl in you package has something wrong;
when i use the latest official openpyxl, '11111111111111111111' will not be truncated;

[kennethreitz]

This is because our openpyxl needs to be updated.

[kennethreitz]

#197 is the same bug.

[jayzh1010]

when will u fix this bug? tks

[YiuTerran]

still not fixed? So...Should I use openpyxl instead?

[jayzh1010]

@YiuTerran i think u should use openpyxl and encapsulate it.

[hugovk]

Retesting:

• Python 3.7.4
• tablib==0.14.0 (newest)
• openpyxl==3.0.0 (newest)

import tablib

data = tablib.Dataset()
data.headers = ["test_id"]

a = "11111111111111111111"
b = 11111111111111111111
data.append([a])
data.append([b])
with open("test.xls", "wb") as f:
    f.write(data.xls)

test.xls contains:

test_id
11111111111111111111
11111111111111100000

The string matches the input, but not the integer. Closing as a duplicate of #197, which is reported upstream:

• https://bitbucket.org/openpyxl/openpyxl/issues/1355/wrong-long-int-value-exported