0.00 should not be left empty in the rows. about laravel-nova-excel HOT 2 CLOSED

This most likely bottles down to the parent package PhpSpreadsheet and their DefaultValueBinder. You can either create custom action with a custom WithMapping and WithColumnFormatting or create your own value binder \PhpOffice\PhpSpreadsheet\Cell::setValueBinder(new YourValueBinder)
The issue for sure isn't located in this package, as we only pass on the data from eloquent to phpspreadsheet.

from laravel-nova-excel.

To anyone else facing this issue, or the one described in issue #18, I've found a way to resolve both problems. Below is a base class I created to allow all other exporters to extend. The classes that extend it just define the columns in protected $columns in the order you'd like them exported. The base class takes care of the rest.

<?php

namespace App\Nova\Actions\Excel;

use Maatwebsite\Excel\Excel;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\LaravelNovaExcel\Actions\DownloadExcel as DownloadExcelBase;

class DownloadExcel extends DownloadExcelBase implements WithMapping
{
	protected $columns = [];
	
	public function __construct()
	{
		$this->withWriterType(Excel::CSV);
		$this->withHeadings($this->columns);
	}
	
	public function map($row): array
	{
		$out = [];
		foreach ($this->columns as $column) {
			
			$value = $row->{$column};
			$this->parseValue($value);
			$out[] = $value;
			
		}
		
		return $out;
	}
	
	protected function parseValue(&$value)
	{
		if (is_bool($value)) {
			$value = $value === false ? "0" : "1";
		}
	}
}

from laravel-nova-excel.