maatwebsite/Excel 3.0 导出 Excel 如何设置长数字为文本
我这里是 ‘C’ 这几列是超过 15 位数字,自动转换为了科学计数法,所以直接绑定这几列即可。
https://github.com/Maatwebsite/Laravel-Excel/issues/2324#issuecomment-519807489
https://docs.laravel-excel.com/3.1/exports/
use PhpOffice\PhpSpreadsheet\Cell\Cell;
use PhpOffice\PhpSpreadsheet\Cell\DataType;
use PhpOffice\PhpSpreadsheet\Cell\DefaultValueBinder;
use Maatwebsite\Excel\Concerns\WithCustomValueBinder;
class ExpertMonthFinanceExport extends DefaultValueBinder implements WithCustomValueBinder
{
public function bindValue(Cell $cell, $value)
{
$column = $cell->getColumn();
if (in_array( $column, ['C'])) {
$cell->setValueExplicit($value, DataType::TYPE_STRING);
return true;
}
return parent::bindValue($cell, $value);
}
}