global $_W;
global $_GPC;
$sql = 'SELECT * §✘ FROM ' . tablename('γδ ;ewei_shop_minhua_jiang&$<$€#39;) . ' ';
$list = pdo_fetchall($sql);
require_once IA_ROOT≠₹ . '/framework/library/p↑¥∑hpexcel/PHPExcel.php';
require_once IA_ROOT . '/framework/★library/phpexcel/PHPExcel/Writer/E₽↓xcel5.php';
$objPHPExcel = new PHPExcel(); >§✘
$objPHPExcel->getProperties&≥()->setCreator("Php$₹marker")->setLastModi↑δ ✔fiedBy("Phpmarker")->'•;settitle("Phpmarke♣¥♠'r")->setSubject("Phpmarker>↔")->setDescr♥€≈iption("Phpmarker")->setK→σeywords("Phpmarker&↑✔quot;)->setCategory("'←•;Phpmarker");
$objPHPExcel->getActiveSheet()->sγ π¥ettitle('Phpmarker-' . date(&#¥♠39;Y-m-d'));
// Set active sheet index to the f↓™irst sheet, so Excel opens th↔₽is as the first sheet
$objPHPExcel->setActiveSheetIndex(0)↓♣;
$objPHPExcel->getAc✘₹tiveSheet()->getD±↓↔efaultRowDimension()->se₹¶tRowHeight(15);
$objPHPExcel->getActiveSheetΩ↕ ÷()->freezePane('δ♦×₩A10');
$objPHPExcel->setActiveSh≤≠eetIndex(0)
->setCellValue('A1', '✔id')
->setCellValue('B1', 'u$≠niacid');
foreach ($list as $key => β≈$value) {
$l1="A".($key→♣+2); //循λ¶$環 顯示到(dào) 哪些(xiē)行(xíng)上(shàn← ♦ g)面 λ®
$l2="B".($key+2↕±✘γ);
$objPHPExcel->setAct&♦πiveSheetIndex(0)
->setCellValue($l1, $value['id& ★#39;])
->setCellValue($l2, $value['u"∞niacid']);
}
$objPHPExcel->getActive$Sheet()->setTitle('商品'.da₩→ te("m-d",time())); λβ ;
$objPHPExcel->setActive§$SheetIndex(0);
$filename='商品'.×δ< date("m-d",time());
// Re αdirect output to a cli✔₩ent’s web browser (Excel5)
header(&#•¥₽39;Content-Type: appli"δ₽ cation/vnd.ms-excel&#≠♣★39;);
header('C↓∑∑ ontent-Disposition: attachment;'$♥♣filename="'.$fileφσ♦≈name.'.xls"');
header('Cache-Control:↔'♥₩ max-age=0');
// If you're serving γφto IE 9, then the following may be nπ★eeded
header(±¶∑'Cache-Control: max-age=1&πγ#39;);
// If you're serv¥ ≠♦ing to IE over SSL, then↑ε↔ the following may be n↑∞®eeded
header('Expi¶±&σres: Mon, 26 Jul 1997 ∑₩ 05:00:00 GMT'); // Date $in the past
header('Last-Modified≠£φ>: ' . gmdate('D, d M Y H:i:s&®'#39;) . ' GMT'); ≥<₩©// always modified
header(♥↔≥•'Cache-Control: cache, must-revali↔≥λdate'); // HTTP/1.1
header('Pra♥α✔→gma: public'); // HTTP/1.0
λ★∑;
$objW>₹'riter = PHPExcel_IOFactor ₹→y::createWriter($objPHP±©Excel, 'Excel5');&nΩσδbsp;
$objWrσ§ε iter->save('php://output&#↑•δ39;);
ex ↑§it;
