반응형
$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
);
}
반응형