//------------------------------------------------------
// Sheet1 : 인적사항
//------------------------------------------------------
$students = [];
$sheet1 = $spreadsheet->getSheet(0);
$highestRow1 = $sheet1->getHighestRow();
$highestColumn1 = $sheet1->getHighestColumn();
$header1 = $sheet1->rangeToArray(
"A10:{$highestColumn1}10",
null,
true,
true,
false
)[0];
$map1 = [];
foreach ($header1 as $idx => $title) {
$title = trim((string)$title);
if ($title != '') {
$map1[$title] = $idx;
}
}
for ($row = 11; $row <= $highestRow1; $row++) {
$data = $sheet1->rangeToArray(
"A{$row}:{$highestColumn1}{$row}",
null,
true,
true,
false
)[0];
$name = trim((string)($data[$map1['이름']] ?? ''));
if ($name == '') {
continue;
}
$students[] = [
'school' => trim((string)($data[$map1['학교']] ?? '')),
'name' => $name,
'birth' => trim((string)($data[$map1['생년월일']] ?? '')),
'grade' => trim((string)($data[$map1['학년']] ?? '')),
'address' => trim((string)($data[$map1['주소']] ?? '')),
'parent_phone' => preg_replace('/[^0-9]/', '', (string)($data[$map1['부모전번']] ?? '')),
'student_phone' => preg_replace('/[^0-9]/', '', (string)($data[$map1['학생전번']] ?? '')),
'teacher' => trim((string)($data[$map1['T']] ?? '')),
'status' => trim((string)($data[$map1['진행사항']] ?? '')),
'weekday' => trim((string)($data[$map1['요일']] ?? '')),
'class_name' => trim((string)($data[$map1['반명']] ?? ''))
];
}
// ===== 테스트 =====
echo "";
print_r(array_slice($students, 0, 5));
echo "
";
exit;
M108스터디 일정 – 과천 M108스터디 학원
맨 위로
댓글