PHP Excel Excel バージョン偵察瀰緥絠ｇ爜_PHP珁欑▼ 宁涔嫔-PHPチュートリアル-php.cn

PHP Excel Excel バージョン偵察瀰緥絠ｇ爜_PHP珁欑▼ 宁涔嫔

WBOY

リリース： 2016-07-13 17:06:27

オリジナル

1448 人が閲覧しました

鍦╬hp涓瀵煎叆excel琛ㄦ牸鎴戜滑链€绠€鍗旷殑豪辨槸槸槸揆csv鏂囦欢锛岃修给绛囅変竴绐嶅嶅変竴绐嶅嶅≒HPExcel 鎻掍欢鏉ュ疄鐜帮紝颍哥敤鐨勯兘鏄娇鐢≒HPExcel 鎻掍欢浜嗭紝瀹冩湁寮嗭紝瀹冩湁寮哄ぇ鐨勬姝姝姝湅涓疄渚嬨€?p>寰堝缃戠珯閮芥湁瀵煎嚭鏁版嵁涓篹xcel鐨勫姛鑳斤紝紝链€寮嬫姛兂鐢╦s瀼倵鐨勬枃兜犲嚑涔"櫒纨鐞嗕笉瀛桦湪忚忚鍣ㄥ寸瀹圭殑闂銆?/p>

涓婂浘鏄」鐩直感瑕佽瀵煎嚭鐨勬暟鎹紝鍓嶄袱琛屾槸頭锛屽悗闈㈡胴体锛堥噷闈㈢殑tr鏁伴噺涓嶅畾锛夈€傞鍏堟槸銮峰彇鏁版嵁鍙戦€佸埌phpdan鐞嗐€?/p>

浠g爜湿备笅

澶嶅埔浠g爜

require_once '../Classes/PHPExcel.php';
require_once '../Classes/PHPExcel/IOFactory.php';
$objPHPExcel = 新しい PHPExcel();
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX テストドキュメント")->OfficeLSUX0" テストドキュメント") ->setDescription("Office 2007 XLSX のドキュメント、PHP クラスを使用して生成されました。")->setKeywords("office 2007 openxml php")->setCategory("テスト結果ファイル");

$objPHPExcel->setActiveSheetIndex(0);
$objRichText = 新しい PHPExcel_RichText();
$objRichText->createText('');
$objPayable = $objRichText->createTextRun('鍗虫椂鐩戞祴鏁版嵁');
$objPayable->getFont()->setColor( new PHPExcel_Style_Color( PHPExcel_Style_Color::COLOR_RED ));
$objPayable->getFont()->setBold(true);
$objPayable->getFont()->setSize(24);
$objPHPExcel->getActiveSheet()->getCell('B1')->setValue($objRichText);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true); // $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(24); // 瀛椾綋澶у皬
; $objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED) // 鏂囨掆掆; $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getFill()->getStartColor()->setARGB('00FFFFE3');// 汗

// 鍒楀

//$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);

$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(18);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(18);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(18);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);

// 陳岄平

for($i = 2; $i $objPHPExcel->getActiveSheet()->getRowDimension($i)->setRowHeight(22);
}

$objPHPExcel->getActiveSheet()->setCellValue('A2', '濮撳悕');
$objPHPExcel->getActiveSheet()->setCellValue('A3', 'PHP');
$objPHPExcel->getActiveSheet()->setCellValue('A4', 'EXCEL');
$objPHPExcel->getActiveSheet()->setCellValue('A5', '');
$objPHPExcel->getActiveSheet()->setCellValue('A6', 'XXX');
$objPHPExcel->getActiveSheet()->setCellValue('A7', 'V');
$objPHPExcel->getActiveSheet()->setCellValue('A8', 'd');
$objPHPExcel->getActiveSheet()->setCellValue('A9', 'name');
$objPHPExcel->getActiveSheet()->setCellValue('A10', '鎻忚我慢');
for($i = 2; $i $objPHPExcel->getActiveSheet()->getStyle('A' . $i)->getFont()->setBold(true); // 鍔犵矖
}

$objPHPExcel->getActiveSheet()->setCellValue('B2', '[濮撳悕]');
$objPHPExcel->getActiveSheet()->setCellValue('B3', '瀵煎嚭甯﹀浘鐗囩殑EXCEL');
$objPHPExcel->getActiveSheet()->setCellValue('B4', 'XXXXX');

// 涓篹xcel鍔犲浘鐗?br /> //$objDrawing = new PHPExcel_Worksheet_Drawing();
//$objDrawing->setName('写真');
//$objDrawing->setDescription('写真');
//$objDrawing->setPath('../images/touxiang.jpg');
//$objDrawing->setHeight(170);
//$objDrawing->setWidth(120);
//$objDrawing->setCoowned('G2');
//$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

$objPHPExcel->getActiveSheet()->setCellValue('A17', '鍏跺畠瑕佹眰');
$objPHPExcel->getActiveSheet()->setCellValue('B17', '[鍏跺畠瑕佹眰]');

$objPHPExcel->getActiveSheet()->getStyle('A17')->getFont()->setBold(true); // 鍔犵矖

$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setTitle('鍗虫椂鐩戞祴鏁版嵁');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save('PHPExcel.xls');