composer 설치 없이 PhpSpreadsheet 적용기

require _MODULE_URL . '/PhpSpreadsheet/vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

public function downloadExcel($downArea, $selectedIds, $board_code)
    {
        $boardTitleResult = $this->objDBH->query("select title from board where code = $board_code");
        if (!$boardTitleResult) {
            die("게시판 제목 조회 실패: " . $this->objDBH->error);
        }
        $boardTitleRow = $boardTitleResult->fetch_assoc();
        $setTitle = $boardTitleRow['title'];

        if ($downArea == 'selected') {
            // 선택된 ID들을 쉼표로 구분된 문자열로 변환
            $selectedIds = json_decode(stripslashes($selectedIds), true);
            $ids = implode(',', array_map('intval', $selectedIds));
    
            $result = $this->objDBH->query("select * from board_data where code in ($ids) and board_code = $board_code");
        } else if ($downArea == 'all') {
            $result = $this->objDBH->query("select * from board_data where board_code = $board_code");
        } else {
            die("잘못된 접근입니다.");
        }

        if (!$result) {
            die("데이터 조회 실패: " . $this->objDBH->error);
        }

        $column_cnt = $result->field_count;
        $column_name = array();
        while ($field = $result->fetch_field()) {
            $column_name[] = $field->name;
        }

        $spreadsheet = new Spreadsheet();
        $excel = $spreadsheet->getActiveSheet();

        $excel->setTitle($setTitle);

        for ($i = 1, $a = 'A'; $i <= $column_cnt; $i++, $a++) {
            $excel->setCellValue($a . '1', $column_name[$i - 1]);
        }

        $data = $result->fetch_all(MYSQLI_ASSOC);

        foreach ($data as $key => $value) {
            $num = $key + 1;
            $key = $key + 2;
            for ($i = 1, $a = 'A'; $i <= $column_cnt; $i++, $a++) {
                $excel->setCellValue($a . $key, $value[$column_name[$i - 1]]);
            }
        }

        $downDate = date('Y-m-d');

        $writer = new Xlsx($spreadsheet);
        $file_name = $setTitle . '_' . $downDate . '.xlsx';
        $writer->save($file_name);
        header("Content-Type: application/vnd.ms-excel");
        header('Content-Disposition: attachment; filename="' . basename($file_name) . '"');
        header('Expires: 0');
        header('Cache-Control: must-revalidate');
        header('Pragma: public');
        header('Content-Length: ' . filesize($file_name));
        flush();

        readfile($file_name);
        unlink($file_name); // 엑셀다운 받아지면 파일 삭제
        exit;
    }