search

rap2hpoutre / fast-excel

🦉 Fast Excel import/export for Laravel
MIT License
2.08k stars 246 forks source link

The empty cells in excel is considered as string (""), which should be NULL. #325

Closed anurag1yadav closed 1 year ago

anurag1yadav commented 1 year ago

Response from ExcelExport for sheet with ["column1"]=> int(1) ["column2"]=>NULL

Response from FastExcel on the sheet ["column1"]=>int(1) ["column2"]=>string(0) ""

Did the var dump and found this, while doing importSheets() the empty cells records are coming as empty string and 'column2' => $value['column2'] ?? null, check is failing, which is giving value as "", instead of null @rap2hpoutre @StyleCIBot