# Custom Formatting Values
# Value Binder
By default Laravel Excel uses PhpSpreadsheet's default value binder to intelligently format a cell's value when reading it. You may override this behavior by implementing the WithCustomValueBinder concern and the bindValue method. Your import class may also extend DefaultValueBinder to return the default behavior.
namespace App\Imports;
use PhpOffice\PhpSpreadsheet\Cell\Cell;
use Maatwebsite\Excel\Concerns\ToModel;
use PhpOffice\PhpSpreadsheet\Cell\DataType;
use Maatwebsite\Excel\Concerns\WithCustomValueBinder;
use PhpOffice\PhpSpreadsheet\Cell\DefaultValueBinder;
class UsersImport extends DefaultValueBinder implements WithCustomValueBinder, ToModel
{
public function bindValue(Cell $cell, $value)
{
if (is_numeric($value)) {
$cell->setValueExplicit($value, DataType::TYPE_NUMERIC);
return true;
}
// else return default behavior
return parent::bindValue($cell, $value);
}
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
# Available DataTypes
PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRINGPhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_FORMULAPhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERICPhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_BOOLPhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NULLPhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_INLINEPhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_ERROR
# Disable intelligent formatting
If you want to disable the intelligent formatting of values, you can extend your import class with \PhpOffice\PhpSpreadsheet\Cell\StringValueBinder. In this case all values are passed on as strings.
namespace App\Imports;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithCustomValueBinder;
class UsersImport extends \PhpOffice\PhpSpreadsheet\Cell\StringValueBinder implements WithCustomValueBinder, ToModel
{
}
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
# Default Value Binder
If you want to use one value binder for all your imports, you can configure the default value binder in the config.
In config/excel.php:
'value_binder' => [
'default' => Maatwebsite\Excel\DefaultValueBinder::class,
],
1
2
3
2
3