php 生成excel文件

class excel{


var $header = "
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="">";

var $footer = "";
var $lines = array ();
var $worksheet_title = "table1";

function addrow ($array) {


$cells = "";


foreach ($array as $k => $v):

// 加个字符串与数字的判断 避免生成的 excel 出现数字以字符串存储的警告
if(is_numeric($v)) {
// 防止首字母为 0 时生成 excel 后 0 丢失
if(substr($v, 0, 1) == 0) {
$cells .= "" . $v . " ";
} else {
$cells .= "" . $v . " ";
}
} else {
$cells .= "" . $v . " ";
}

endforeach;

// transform $cells content into one row
$this->lines[] = " " . $cells . " ";

}

function addarray ($array) {

// run through the array and add them into rows
foreach ($array as $k => $v):
$this->addrow ($v);
endforeach;

}

function setworksheettitle ($title) {

// strip out special chars first
$title = preg_replace ("/[|:|/|?|*|[|]]/", "", $title);

// now cut it to the allowed length
$title = substr ($title, 0, 31);

// set title
$this->worksheet_title = $title;

}

function generatexml ($filename) {


header("content-type: application/vnd.ms-excel; charset=utf-8");
header("content-disposition: inline; filename="" . $filename . ".xls"");

echo strips教程lashes ($this->header);
echo " worksheet_title . "">

?>

header("content-type:application/vnd.ms-excel");

header("content-disposition:filename=test.xls");

echo "test1";

echo "test2";

echo "test1";

echo "test2";

echo "test1";

echo "test2";

echo "test1";

echo "test2";

echo "test1";

echo "test2";

echo "test1";

echo "test2";

?>

方法三

header("content-type: application/octet-stream");
header("accept-ranges: bytes");
header("content-type:application/vnd.ms-excel");
header("content-disposition:attachment;filename=export_excel_gshjsl.xls");

$tx='表头';
echo $tx." ";
echo "编号"." ";
echo "姓名"." ";
echo " ";

echo "="411481198507150666""." ";
echo "="0123456""." ";
echo " ";
?>