KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Excel export return FALSE in null cells #1633

Closed Daniel Cordeiro opened this topic on on Sep 29, 2020 - 4 comments
Daniel Cordeiro commented on Sep 29, 2020

When I using ColumnMeta

The Cell with null value return always FALSE (or FALSO in portuguese) I'll try set data with Map, but can't success

Remember is sheet with many columns with data_type.

David Winterburn commented on Sep 29, 2020

...

KoolReport commented on Sep 29, 2020

I suggest you to use the CleanData package with two processes: FillNull or DropNull. As the name suggested, you can drop the whole rows when null happens or you can fill null value with a chosen value.

KoolReport commented on Sep 29, 2020

I suggest you to use the CleanData package with two processes: FillNull or DropNull. As the name suggested, you can drop the whole rows when null happens or you can fill null value with a chosen value.

Daniel Cordeiro commented on Sep 29, 2020

the suggest isn't work. The date field still return false when is null. The solution was add a test in the koolreport/excel/Table.php, and check if the $value is empty, changed to null.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed
solved
Excel

Designed and built with by KoolPHP Inc.

Code licensed MIT.