웹개발/PHP
[PHP] 데이터 엑셀로 저장기능
우주별
2016. 12. 9. 18:26
<?
header( "Content-type: application/vnd.ms-excel; charset=utf-8" );
header( "Cache-Control: must-revalidate, post-check=0,pre-check=0" );
header( "Content-Disposition: attachment; filename=test.xls" );
header( "Pragma: public" );
$array1 = array("1","2","3");
$array2 = array("11","22","33");
$thead = "
<tr>
<td>값1</td>
<td>값2</td>
<td>합계</td>
</tr>
";
for($i=0; $i<sizeof($array1); $i++){
$content = "
<tr>
<td>$array1[$i]</td>
<td>$array2[$i]</td>
<td>".( $array1[$i] + $array2[$i] )."</td>
</tr>
";
}
echo "<table>".$thead.$content."</table>";
?>
filename 은 변경 가능합니다.