반응형
    
    
    
  
    $Rows = $spreadsheet->getActiveSheet()->getHighestRow(); // 줄수 계산
    
    for($i=1; $i<=$Rows; $i++){ // A열의 자료를 문자형태로 변환 
        $cellValue = $spreadsheet->getActiveSheet()->getCell('A'.$i)->getValue();  
        $spreadsheet->getActiveSheet()->getCell('A'.$i)
        ->setValueExplicit(
            $cellValue,
            \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING
        );
       
    }반응형