Php exports to excel a cell whose content exceeds the limit is truncated

Baidu checked and found that the character limit in a cell in excel is 32767, but now the exported cell is beyond this range, resulting in the content being truncated. Is there any good way to solve this problem?

Mar.13,2021

split the data, for example, put 30000 characters into a table, and then put more than one table.


as mentioned above, it is a reasonable method to split the data;
eg. You can kill a Xiaolongbao in one bite; it seems hard for you to eat more than one watermelon at any time.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3c775-2bb6b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3c775-2bb6b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?