Excel 파일 만드는 샘플 소스 입니다.
header( "Content-type: application/vnd.ms-excel" ); header( "Content-type: application/vnd.ms-excel; charset=utf-8"); header( "Content-Disposition: attachment; filename = 회원목록.xls" ); header( "Content-Description: PHP4 Generated Data" ); $sql = "select * From member "; $result = mysql_query($sql); $EXCEL = " <table border='1'> <tr> <td>No.</td> <td>아이디</td> <td>서비스 만료일</td> </tr>"; $i = 1; while($row = mysql_fetch_array($result)) { $EXCEL .= " <tr> <td style='text-align:center;'>".$i."</td> <td>".$row['MEMBER_ID']."</td> <td>".$row['MEMBER_EXPIRY_DATE']."</td> </tr> "; $i = $i + 1; } $EXCEL .= "</table>"; echo "<meta content=\"application/vnd.ms-excel; charset=UTF-8\" name=\"Content-type\"> "; echo $EXCEL;