+2 votes
43 views

in Back-end by (6k points) | 43 views

1 Answer

+1 vote

Hi Imen,

Total number of characters that an Excel cell can contain is 32,767 characters (you can check this link: https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 )

Try to change this file: addons/web/controllers/main.py:

 cell_value = re.sub("\r", " ", cell_value)

with:

cell_value = re.sub("\r", " ", cell_value)[:32767]

--------------

Hope this was helpful!

by (3.7k points)
202 questions
178 answers
34 comments
111,037 users