對這文章發表回應
發表限制: 非會員 可以發表
Everybody knows phpMyAdmin can export file to Excel format but phpMyAdmin just export .csv file,not real Excel file format. If you are interest in PHP programming and need to export to the real Excel format please check it out !
Example PHP export to XLS file format.
1. Create Function for XLS
function xlsBOF () { |
2. Send Header to Browser in download format.
| // Query Database $result = mysql_db_query ( $dbname , "select id,prename,name,sname,grade from appdata where course='$courseid' and sec='$section'" ) // Send Header header ( "Pragma: public" ); header ( "Expires: 0" ); header ( "Cache-Control: must-revalidate, post-check=0, pre-check=0" ); header ( "Content-Type: application/force-download" ); header ( "Content-Type: application/octet-stream" ); header ( "Content-Type: application/download" );; header ( "Content-Disposition: attachment;filename=$courseid-$sec.xls " ); // à¹?ล้วนี่à¸?็ชื่à¸à¹„ฟล์ header ( "Content-Transfer-Encoding: binary " ); // XLS Data Cell xlsBOF (); xlsWriteLabel ( 1 , 0 , "Student Register $semester/$year" ); xlsWriteLabel ( 2 , 0 , "COURSENO : " ); xlsWriteLabel ( 2 , 1 , "$courseid" ); xlsWriteLabel ( 3 , 0 , "TITLE : " ); xlsWriteLabel ( 3 , 1 , "$title" ); xlsWriteLabel ( 4 , 0 , "SETION : " ); xlsWriteLabel ( 4 , 1 , "$sec" ); xlsWriteLabel ( 6 , 0 , "NO" ); xlsWriteLabel ( 6 , 1 , "ID" ); xlsWriteLabel ( 6 , 2 , "Gender" ); xlsWriteLabel ( 6 , 3 , "Name" ); xlsWriteLabel ( 6 , 4 , "Lastname" ); $xlsRow = 7 ; while(list( $id , $prename , $name , $sname , $grade )= mysql_fetch_row ( $result )) { ++ $i ; xlsWriteNumber ( $xlsRow , 0 , "$i" ); xlsWriteNumber ( $xlsRow , 1 , "$id" ); xlsWriteLabel ( $xlsRow , 2 , "$prename" ); xlsWriteLabel ( $xlsRow , 3 , "$name" ); xlsWriteLabel ( $xlsRow , 4 , "$sname" ); $xlsRow ++; } xlsEOF (); exit(); |
原文出處：AppServNetwork - Easy way to create XLS file from PHP