ถามเรื่องการ exprot PHP to excel ครับ คือว่าผมได้ บันทึกข้อมูลลงในฐานข้อมูลแล้วและทำการสแสดงข้อมูล

Quote:

<?php
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;
}

Quote:

function onExport( $pluginParameters, $requestParameters, $data ){

$records = $data['records'];
$labels = explode("\r\n", $requestParameters['labels']);

header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/vnd.ms-excel");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=exported-data.xls ");
header("Content-Transfer-Encoding: binary ");

xlsBOF();
for($i=0;$i<count($labels);$i++){
xlsWriteLabel( 0, $i, $labels[$i] );
}


for($i=0;$i<count($records);$i++){
for($j=0;$j<count($records[$i]);$j++){
if(is_numeric($records[$i][$j]))xlsWriteNumber( $i+1, $j, $records[$i][$j] );
else xlsWriteLabel( $i+1, $j, $records[$i][$j] );
}
}
xlsEOF();
exit();