laravel-excel设定单元格格式

composer require mattwebsite/excel

<?php



use Maatwebsite\Excel\Classes\LaravelExcelWorksheet;
use Maatwebsite\Excel\Writers\LaravelExcelWriter;
use Illuminate\Routing\Controller;

/**
 * @description
 * @author  lfs <leyoumake@gmail.com>
 * @package Tests\http
 */
class DemoController extends Controller
{
    /**
     * @description excel表格生成
     * @return void
     */
    public function exportExcel():void
    {
        Excel::create('导出excel文件名', function (LaravelExcelWriter $excel)
        {
            $excel->sheet('test', function (LaravelExcelWorksheet $sheet)
            {
                //追加表头
                $sheet->appendRow([
                    '文本',
                    '数字',
                ]);
                //追加行内容
                $sheet->appendRow([
                    '你好',
                    '1',
                ]);
                $sheet->appendRow([
                    '你好',
                    '2',
                ]);
                $sheet->setColumnFormat([
                    'A1:A3' => '@',
                    'B1:B3' => '0',
                ]);
            });
        })->export('xlsx');
    }
}