I am using Apache POI to write data into Microsoft Excel, but it throw this exception during the process:
Here is the code snippet, this exception result from line 12:
According to Apache POI's source code, it will check the maximum length of each cell cannot be larger than 32,767 characters.
And it is also XLS's imitation, so we need to do substring or use XLSX format instead. We choose the former option. Therefore, my source code should be modified as following: