Is There data limitation for Writer ?

[rakaarifbudiman]

Hi,
I have query for download to excel (7252 data), when i use the writer to download it's only return 6215 data.
I have used flush method.

This is my code :
$lup = LUPParent::where('approved', '1')
->join('lup_actions', 'lup_actions.code', '=', 'lup_parents.code')->get();

    $filename = 'List LUP '.date('d-M-y', strtotime(now())).'.xlsx';
    $stream = SimpleExcelWriter::streamDownload($filename);
    $writer = $stream->getWriter();       
    
    $nameSheet = $writer->getCurrentSheet();
    $nameSheet->setName('List LUP');
    foreach ($lup as $index=>$data) {
        $stream->addRows([
            ['Code' => $data->code, 'No LUP' => $data->nolup,
                'Title' => $data->documentname, 'Status LUP' => $data->lupstatus,
                'Change Related To' => $data->lup_type, 'Change Sub Category' => $data->lup_subtype,
                'Categorization' => $data->categorization, 'Risk Assessment' => htmlspecialchars($data->risk_assestment),
                'Inisiator' => $data->inisiator, 'Department' => $data->inisiators->department, 'Proposed' => htmlspecialchars($data->lup_proposed),
                'Current Condition' => htmlspecialchars($data->lup_current), 'Reason of Change' => htmlspecialchars($data->lup_reason),
                'Change Related To' => $data->lup_type, 'Change Sub Category' => $data->lup_subtype,
                'Others' => $data->lup_type_others, 'Change Type' => $data->duedate_type,
                'Regulatory Change Type' => $data->regulatory_change_type, 'Regulatory Variation' => $data->regulatory_variation,
                'Date Created' => date('d-M-y', strtotime($data->date_input)), 'Date Approved' => date('d-M-y', strtotime($data->dateapproved)),
                'Action' => $data->action, 'PIC Action' => $data->pic_action, 'Due Date Action' => date('d-M-y', strtotime($data->duedate_action)),
                'Date Submit Evidence' => ($data->dateupload_evidence ? date('d-M-y', strtotime($data->dateupload_evidence)) : ''), 'Date Approved Evidence' => ($data->dateapproved_evidence ? date('d-M-y', strtotime($data->dateapproved_evidence)) : ''),
            ],
        ]);
        if ($index % 1000 === 0) {
            flush(); // Flush the buffer every 1000 rows
        }
    }
    return $stream->toBrowser();

[rakaarifbudiman]

I've been able to download all data, with exclude all LongText Field. Maybe its not support for LongText type field