用PHP生成Excel文档(非CSV)

 以下为代码，说白了就是Excel能解析HTML的Table，并对应到单元格中。

 

<? php

header ( " Content-Type: application/vnd.ms-excel " );
header ( " Expires: 0 " );
header ( " Cache-Control: must-revalidate, post-check=0, pre-check=0 " );
header ( " content-disposition: attachment;filename=yourFileName.xls " );

?>< html >
< head >
< title > Excel Spreadsheet </ title >
< meta http - equiv = " Content-Type "  content = " text/html; charset=iso-8859-1 " >
</ head >
< body >
< table width = " 200 "  border = " 1 "  cellspacing = " 0 "  cellpadding = " 2 " >
   < tr align = " center "  bgcolor = " #FFFF00 " >
     < td colspan = " 2 " >
       < font face = " Arial, Helvetica, sans-serif " >< strong > Article
         </ strong >   </ font >     
     </ td >
   </ tr >
   < tr >
     < td width = " 155 "  align = " right " >
     < font size = " 6 "  face = " Times New Roman, Times, serif " >< em > Apples :</ em ></ font >     
     </ td >
     < td width = " 31 "  align = " left "  bgcolor = " #FF9900 " >
       < strong >< font color = " #FFFFFF " > 5 </ font ></ strong >
     </ td >
   </ tr >
   < tr >
     < td align = " right " >
     < font size = " 6 "  face = " Times New Roman, Times, serif " >< em > Oranges :</ em ></ font >     
     </ td >
     < td align = " left "  bgcolor = " #FF9900 " >
       < strong >< font color = " #FFFFFF " > 5
       </ font >   </ strong >     
     </ td >
   </ tr >
   < tr >
     < td align = " right " >
      Total :
     </ td >
     < td align = " left "  bgcolor = " #FF0000 " >
       < font color = " #FFFF00 "  size = " 5 "  face = " Arial, Helvetica, sans-serif " >< strong >= SUM(B2 : B3) </ strong ></ font >
     </ td >
   </ tr >
</ table >
</ body >
</ html >

上述代码中，=SUM(B2:B3) 为对B2到B3的单元格求和，有些本地化的Excel可能是SUMA或者别的，这要视具体情况。