 |
|
ส่วนโค๊ด
Code (PHP)
<?PHP ob_start();?>
<?PHP
include("connect/connect.php");
include_once("class/php_writeexcel-0.3.0/class.writeexcel_worksheet.inc.php");
include_once("class/php_writeexcel-0.3.0/class.writeexcel_workbook.inc.php");
$st_date = $_POST[st_date];
$end_date = $_POST[end_date];
$token = md5( uniqid(rand(), true ) );
$fname= "tmp/$token.xls";
$workbook =& new writeexcel_workbook($fname);
$worksheet =& $workbook->addworksheet("Test");
$worksheet->set_margin_right(0.50);
$worksheet->set_margin_bottom(1.10);
## Set Format ##
$xlscelldesc_header =& $workbook->addformat();
$xlscelldesc_header->set_font('Angsana New');
$xlscelldesc_header->set_size(14);
$xlscelldesc_header->set_color('black');
$xlscelldesc_header->set_bold(1);
$xlscelldesc_header->set_align('left');
$xlscelldesc_header->set_text_v_align(1);
$xlscelldesc_header->set_merge(1);
$xlsCellDesc =& $workbook->addformat();
$xlsCellDesc->set_font('Angsana New');
$xlsCellDesc->set_size(14);
$xlsCellDesc->set_color('black');
$xlsCellDesc->set_bold(0);
$xlsCellDesc->set_align('left');
$xlsCellDesc->set_text_v_align(1);
## End of Set Format ##
## Set Column Width & Height to Cell
$worksheet->set_column('A:B',10);
$worksheet->set_column('B:C',8);
$worksheet->set_column('C:D',10);
$worksheet->set_column('D:E',10);
$worksheet->set_column('E:F',10);
$worksheet->set_column('F:G',13);
$worksheet->set_column('G:H',10);
$worksheet->set_column('H:I',10);
$worksheet->set_column('I:J',10);
$worksheet->set_column('J:K',10);
$celldesc_h = 10;
//หัวคอลัมม์
$xlsRow = 1;
$worksheet->set_row($xlsRow,$celldesc_h);
$worksheet->write("A$xlsRow","ลำดับ", $xlscelldesc_header);
$worksheet->write("B$xlsRow","จังหวัด", $xlscelldesc_header);
$worksheet->write("C$xlsRow","สาขา", $xlscelldesc_header);
$worksheet->write("D$xlsRow","ชื่อ-สกุล", $xlscelldesc_header);
$worksheet->write("E$xlsRow","เพศ", $xlscelldesc_header);
$worksheet->write("F$xlsRow","หมายเลขโทรศัพท์", $xlscelldesc_header);
$worksheet->write("G$xlsRow","อีเมล์", $xlscelldesc_header);
$worksheet->write("H$xlsRow","ยี่ห้อรถ", $xlscelldesc_header);
$worksheet->write("I$xlsRow","รุ่น", $xlscelldesc_header);
$worksheet->write("J$xlsRow","ปีรุ่น", $xlscelldesc_header);
$xlsRow++;
$no_format =& $workbook->addformat(array(num_format => '0'));
$no_format->set_align('center');
$character =& $workbook->addformat();
$sql = "SELECT
request_customer.rcust_id,
request_customer.rcust_fullname,
REPLACE(REPLACE(request_customer.rcust_gender,'M','ชาย'),'F','หญิง') AS GENDER,
request_customer.rcust_email,
request_customer.rcust_dateadd,
INSERT(INSERT(request_customer.rcust_telephone,7,0,'-'),4,0,'-') AS telephone,
request_customer.rcust_brand,
request_customer.rcust_model,
request_customer.rcust_myear,
depart.depart as rcust_province,
depart_sub.depart_sub as rcust_branch
FROM request_customer
INNER JOIN depart ON request_customer.rcust_province = depart.id
INNER JOIN depart_sub ON request_customer.rcust_branch = depart_sub.id
WHERE date(request_customer.rcust_dateadd) BETWEEN '$st_date' AND '$end_date'
ORDER BY request_customer.rcust_dateadd";
$Query = mysql_query($sql);
//$countNo=1;
while($rows = mysql_fetch_array($Query))
{
$worksheet->set_row($xlsRow, 15.80);
//$worksheet->write("A$xlsRow", $countNo, $character);
$worksheet->write("B$xlsRow", $rows['rcust_province'], $character);
$worksheet->write("C$xlsRow", $rows['rcust_branch'], $character);
$worksheet->write("D$xlsRow", $rows['rcust_fullname'], $character);
$worksheet->write("E$xlsRow", $rows['rcust_gender'], $character);
$worksheet->write("F$xlsRow", $rows['rcust_telephone'], $character);
$worksheet->write("G$xlsRow", $rows['rcust_email'], $character);
$worksheet->write("H$xlsRow", $rows['rcust_brand'], $character);
$worksheet->write("I$xlsRow", $rows['rcust_model'], $character);
$worksheet->write("J$xlsRow", $rows['rcust_myear'], $character);
$xlsRow++;
//$countNo++;
}
//Save as Excel
$workbook->close();
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=".basename('Rcust_'.$st_date.'_'.$end_date.'.xls').";");
header("Content-Transfer-Encoding: UTF-8");
header("Content-Length: ".filesize($fname));
readfile($fname);
unlink($fname);
exit();
?>
<?php
ob_end_flush();
?>
และส่วนที่ได้ใน excel
Code
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
ะฯเกฑแ> l ษTestBไ=ผ%r8X"1ศArial1ศArial1ศArial1ศArial1ศArial1ศArial1ผAngsana New1Angsana Newเ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ๕ @ภ เ @ภ เ Hภ เHภ เHภ เ"@ภ เ @ภ “€’โ8€€€€€€€€€ภภภ€€€3fฬฬff€€fฬฬฬ€€€€€€ฬฬฬฬฬฬฬฬ3f3ฬฬฬฬfff–––3f3f33333f33333…ฏTest
l ษU}ธ
}ธ}ธ
}ธ
}ธ
}ธ
}ธ
}ธ
} ธ
}
ธ
*+มก"dXXเ?เ?
ศภเธฅเธณเธ”เธฑเธเธเธฑเธเธซเธงเธฑเธ”เธชเธฒเธเธฒ!เธเธทเนเธญ-เธชเธเธธเธฅ เน€เธเธจ5-เธซเธกเธฒเธขเน€เธฅเธเนเธ—เธฃเธจเธฑเธเธ—เนเธญเธตเน€เธกเธฅเน เธขเธตเนเธซเนเธญเธฃเธ–เธฃเธธเนเธ เธเธตเธฃเธธเนเธ<ภ กำแพงเพชรคลองลานtess
pheon ffee ๚ฃ@<ภ กาฬสินธุ์ กาฬสินธุ์tess
pheon ffee ๚ฃ@)๑?(๐?'เ?&่?>
ถ
Root EntryBook
Tag : PHP, Excel (Excel.Application)
|
|
 |
 |
 |
 |
Date :
2014-05-23 09:59:25 |
By :
T_Programmer |
View :
2179 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
 |