Min's아빠

header('Content-Type: application/vnd.ms-excel');

header('Content-Disposition: attachment;filename=apply.xlsx');

header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

$objWriter->save('php://output');

create index 인덱스이름 on 테이블(필드);

create index idx_goodscd on gd_goods(goodscd);

show index from 테이블;