- 论坛徽章:
- 0
|
header ('Content-type: application/x-msexcel');
header ("Content-Disposition: attachment; filename=$ExcelFile" );
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;
}
xlsBOF();
for ($i=0;$i<count($Data[0]);$i++)
{
for ($j=0;$j<count($Data);$j++)
{
$v=$Data[$j][$i];
xlsWriteLabel($j,$i,$v);
}
}
xlsEOF();
}
从excel_class.php中抠出来的代码 |
|