php生成xls(最简单的方法)

最新推荐文章于 2024-03-07 17:08:51 发布

初刃

最新推荐文章于 2024-03-07 17:08:51 发布

阅读量299

点赞数

文章标签： PHP Cache .net Blog

本文链接：https://blog.csdn.net/zhangskills/article/details/83888423

版权

<?php
//生成xls文件,调例子如下
/*
include("outputXLS.php");
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=aaa.xls "); 
header("Content-Transfer-Encoding: binary ");

          xlsBOF(); 
                xlsWriteLabel(1,0,"Student Register 9/2008");
                xlsWriteLabel(2,0,"COURSENO : ");
                xlsWriteLabel(2,1,"aaa");
                xlsWriteLabel(3,0,"TITLE : ");
                xlsWriteLabel(3,1,"bbbbb");
                xlsWriteLabel(4,0,"SETION : ");
                xlsWriteLabel(4,1,"ccccc");
                xlsWriteLabel(6,0,"NO");
                xlsWriteLabel(6,1,"ID");
                xlsWriteLabel(6,2,"Gender");
                xlsWriteLabel(6,3,"Name");
                xlsWriteLabel(6,4,"Lastname");
                $xlsRow = 7;
                $i=0;
                while($i<10) {
                   $i++;
                          xlsWriteNumber($xlsRow,0,"aa");
                          xlsWriteNumber($xlsRow,1,"bb");
                          xlsWriteLabel($xlsRow,2,"cc");
                          xlsWriteLabel($xlsRow,3,"dd");
                          xlsWriteLabel($xlsRow,4,"ee");
                    $xlsRow++;
                    }
                     xlsEOF();
                 exit();

*/
function xlsBOF() { 
    echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);  
    return; 
} 

function xlsEOF() { 
    echo pack("ss", 0x0A, 0x00); 
    return; 
} 

function xlsWriteNumber($Row, $Col, $Value) { 
    echo pack("sssss", 0x203, 14, $Row, $Col, 0x0); 
    echo pack("d", $Value); 
    return; 
} 

function xlsWriteLabel($Row, $Col, $Value ) { 
    $L = strlen($Value); 
    echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L); 
    echo $Value; 
return; 
}
?>

转自－－－－ http://blog.csdn.net/zjwtnt/archive/2008/05/07/2412744.aspx