java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32767 characters

0
I am using Excel exporter 6.1.3 to generate excel report .  In excel template used document type – Excel 2007 and higher. While downloading report getting above exception. I am using mendix 8.18.13. Is there any solution?
asked
2 answers
1

HI Sidheshwari,

This is a limitation of Excel itself: https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 . There's a hard limit in both the .xls and .xlsx file formats of 32,767 characters. Normally you can check the source and see why there is a data more than 32k in a singe cell .  Your best option would be switching the export to CSV .

Regards,

Harisanker

answered
1

That is the maximum number of characters allowed in the excel cell value. Truncate the characters if it is more than 32676.

 

Check this link. https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3#ID0EDBD=Newer_versions 

answered