日期:2014-05-16  浏览次数:20747 次

一种最好用的php生成excel的代码 适用于windows和linux

原文链接?http://hi.baidu.com/viwovi/blog/item/710e5b370f52d4380b55a9ff.html

<?php

function xlsBOF() {
?echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
?return;
}
function xlsEOF() {
?echo pack("ss", 0x0A, 0x00);
?return;
}
function format( $STR ){
?$STR = str_replace( "\"", "", $STR );
?if ( strpos( $STR, "," ) ){
??$STR = "\"".$STR."\"";
?}
?$STR = iconv( "utf-8", "gb2312", $STR );
?return $STR;
}
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;
}
function write_excel_line($hang,$lie,$val){
?if(is_numeric($val)){
??xlsWriteNumber($hang,$lie,$val);
?}else{
??xlsWriteLabel($hang,$lie,$val);
?}
}
$mktime = mktime();
header('Content-Type: text/html; charset=utf-8');
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=$mktime.xls ");
header("Content-Transfer-Encoding: binary ");
// XLS Data Cell
xlsBOF();
xlsWriteLabel(0, 0, format('单元格A1'));
xlsWriteLabel(0, 1, format('单元格B1'));
xlsWriteLabel(0, 2, format('单元格C1'));
write_excel_line(1, 0, 'A2');
write_excel_line(1, 1, 'B2');
write_excel_line(1, 2, 'C2');
write_excel_line(2, 0, 'A3');
write_excel_line(2, 1, 'B3');
write_excel_line(2, 2, 'C3');
write_excel_line(3 , 0, '40');
write_excel_line(3 , 1, '41');
write_excel_line(3 , 2, '42');