「Phpexcel常用語法」:修訂間差異
| 第37行: | 第37行: | ||
//參照"PHPExcel developer documentation.doc"第4.6.11.</php> | //參照"PHPExcel developer documentation.doc"第4.6.11.</php> | ||
==設定列印範圍== | ==設定列印範圍== | ||
$objPHPExcel->getActiveSheet()->getPageSetup()->setPrintArea('A1:E5,G4:M20'); | $objPHPExcel->getActiveSheet()->getPageSetup()->setPrintArea('A1:E5,G4:M20'); | ||
==設定檔名== | ==設定檔名== | ||
於 2017年4月12日 (三) 16:47 的修訂
設定儲存格內容(欄位名稱)
<php>$objPHPExcel->getActiveSheet()->setCellValue('B8', 'Some value'); //參照"PHPExcel developer documentation.doc"第4.5.1.</php>
設定儲存格字體大小及粗體
<php>$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->setSize(20)->setBold(true); //參照"PHPExcel developer documentation.doc"第4.6.21</php>
儲存格轉為文字格式(防止客戶代號0006變為6)
<php>$objPHPExcel->getActiveSheet()->setCellValueExplicit('A'.$i, (string)$txt_row['TC004'],PHPExcel_Cell_DataType::TYPE_STRING); //參照"PHPExcel developer documentation.doc"第4.6.7.</php>
畫儲存格外框底線
<php>$objPHPExcel->getActiveSheet()->getStyle("A".$i.":M".$i)->getBorders()->getBottom() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //參照"PHPExcel developer documentation.doc"第4.6.18.</php>
設定欄寬
<php>$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(5); //參照"PHPExcel developer documentation.doc"第4.6.28.</php>
凍結窗格
<php>$objPHPExcel->getActiveSheet()->freezePane('A4'); //google search</php>
每頁列印表頭
<php>$objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1, 3); $objPHPExcel->getActiveSheet()->getPageSetup()->setPrintArea('A1:M'.($i-1)); //參照"PHPExcel developer documentation.doc"第4.6.16. //參照"PHPExcel developer documentation.doc"第4.6.17.</php>
每頁表頭頁數
<php>$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&R &P / &N 頁'); $objPHPExcel->getActiveSheet()->getHeaderFooter()->setEvenFooter('&R &P / &N 頁'); //參照"PHPExcel developer documentation.doc"第4.6.13.</php>
設定列印方向(橫式)及紙張大小
<php>$objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE); <php>$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); //參照"PHPExcel developer documentation.doc"第4.6.9.</php>
設定列印邊界(單位:英吋)
<php>$objPHPExcel->getActiveSheet()->getPageMargins()->setTop(0.19); $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(0.39); $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft(0.39); $objPHPExcel->getActiveSheet()->getPageMargins()->setBottom(0.59); //參照"PHPExcel developer documentation.doc"第4.6.11.</php>
設定列印範圍
$objPHPExcel->getActiveSheet()->getPageSetup()->setPrintArea('A1:E5,G4:M20');
設定檔名
<php>header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="'.$TODAY.'加工製令庫存盤點表.xlsx"'); header('Cache-Control: max-age=0');</php>