================================================================= chart 소스 ================================================================= ================================================================= Login창 소스 =================================================================
================================================================= Excel 소스 (생략된 소스 부분 있음) ================================================================= $sheet = new Spreadsheet(); $sheet->getActiveSheet()->getColumnDimension("A")->setWidth(12); // 각 칼럼 (너비) ( 생략 )-------------- $sheet->getActiveSheet()->getStyle("A")->getAlignment()->setHorizontal("center"); // 각 칼럼 (정렬) ( 생략 )-------------- $sheet->setActiveSheetIndex(0)->setCellValue("A1", "매출입장"); // 제목 (글자 크기, 굵게) $sheet->getActiveSheet()->getStyle('A1')->getFont()->setSize(13); $sheet->getActiveSheet()->getStyle('A1')->getFont()->setBold(true); $sheet->setActiveSheetIndex(0)->setCellValue("G1", "기간: " . $text1 . " - " . $text2); // 기간 (정렬) $sheet->getActiveSheet()->getStyle("G1")->getAlignment()->setHorizontal("right"); // 2행 : 헤더 가운데 정렬 $sheet->getActiveSheet()->getStyle("A2:G2")->getAlignment()->setHorizontal("center"); // 헤더 배경색(밝은 회색) $sheet->getActiveSheet()->getStyle("A2:G2")->getFill() ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID) ->getStartColor()->setARGB('FFCCCCCC'); // 헤더 글자 출력 $sheet->setActiveSheetIndex(0) ->setCellValue("A2", "날짜") ( 생략 )-------------- $i=3; foreach ( $list as $row ) // 3행부터 자료 출력 { $sheet->setActiveSheetIndex(0) ->setCellValue("A$i",$row->writeday) ( 생략 )-------------- $i++; } $sheet->setActiveSheetIndex(0); $fname="매출입장($text1 - $text2).xlsx"; // 파일이름 생성 header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml. sheet"); header("Content-Disposition: attachment;filename=$fname"); header("Cache-Control: max-age=0"); $writer = IOFactory::createWriter($sheet, "Xlsx"); // xlsx형식 $writer->save("php://output"); } ================================================================= Bootstrap Carousel slide =================================================================