Error exporting large data

[yakhyomus]

Php version 7.4 Laravel 8

Error message: Trying to add a value that exceeds the maximum number of characters allowed in a cell (32,767)

Table Products with 230 000 data.

function usersGenerator() { set_time_limit(7200); $products = Product::cursor(); foreach ($products as $product) { yield $product; } } return (new FastExcel(usersGenerator()))->export('test.xlsx');

How can i solve this error?

[yakhyomus]

How i solve this error: Just comment: vendor/box/spout/src/Spout/Writer/XLSX/Manager/WorksheetManager.php 272 line //throw new InvalidArgumentException('Trying to add a value that exceeds the maximum number of characters allowed in a cell (32,767)');

[StefanoTesla]

Did you solve a problem introducing another probably problem, did you tried to dump the cells that exceed the 32767 characters? What inside?

[yakhyomus]

Did you solve a problem introducing another probably problem, did you tried to dump the cells that exceed the 32767 characters? What inside?

You were right, inside was big data. I shortened it and problem solved