PHPexcel删除前导零的问题

require_once 'PHPExcel/PHPExcel.php';

$excel = PHPExcel_IOFactory::load('your_excel_file.xlsx');

$sheet = $excel->getActiveSheet();

foreach ($sheet->getRowIterator() as $row) {
    foreach ($row->getCellIterator() as $cell) {
        $value = $cell->getValue();
        
        // 检查值是否以0开头
        if (is_string($value) && substr($value, 0, 1) === '0') {
            // 设置单元格格式为文本格式，以保留前导零
            $cell->getStyle()->getNumberFormat()->setFormatCode("@");
        }
    }
}

$writer = PHPExcel_IOFactory::createWriter($excel, 'Excel2007');
$writer->save('modified_excel_file.xlsx');