--<\/p>\n
\u5982\u679c\u60f3\u5077\u5403\u6b65\u53ef\u4ee5\u628a HTML \u5b58\u6210 .xls \u6a94\u6848\u5c31\u53ef\u4ee5\u4f7f\u7528 Excel \u8edf\u9ad4\u958b\u555f\uff0c\u7f3a\u9ede\u662f\u958b\u555f\u6703\u51fa\u73fe\u8b66\u544a\u3002\u8981\u6a19\u6e96\u7684 Excel \u53ef\u4ee5\u4f7f\u7528 PHPExcel \u4f86\u8655\u7406<\/p>\n
--<\/p>\n
<?php\r\nrequire_once WEB_ROOT .'\/Component_Back\/PHPExcel-1.8.1\/Classes\/PHPExcel\/IOFactory.php';\r\n\r\n\/\/ \u8b93PHPExcel\u6c7a\u5b9a\u4f7f\u7528\u54ea\u7a2e\u683c\u5f0f\u8b80\u53d6Excel\r\n$excel= \\PHPExcel_IOFactory::load($_FILES['File']['tmp_name']);\r\n\r\n\/\/ \u6293\u53d6\u7b2c\u4e00\u500bSheet\r\n$sheet = $excel->getSheet(0);\r\n\r\n\/\/ \u8b80\u51fa\u8cc7\u6599\u8b8a\u6210\u9663\u5217\r\n$rowData = $sheet->toArray();\r\n\r\n\/\/ \u8cc7\u6599\u7b46\u6578\r\n$Count = count($rowData);\r\n\r\nfor ($i = 1; $i<$Count; $i++) {\r\n\r\n \/\/ \u986f\u793a A \u6b04\u8cc7\u6599\r\n echo $rowData[$i][0];\r\n \r\n $j++;\r\n}<\/pre>\n--<\/p>\n
\u7522\u751f Excel<\/h2>\n\n- 18. \u6191\u7a7a\u751f\u51faExcel\u6a94<\/a><\/li>\n<\/ul>\n
require_once( OS_PATH .'\/Component_Back\/PHPExcel_1.8.0\/Classes\/PHPExcel.php' );\r\n$objPHPExcel= new PHPExcel();\r\n\r\n\/\/ A1 \u5132\u5b58\u683c\u586b\u5165 123\r\n$objPHPExcel->getActiveSheet()->setCellValue('A1', 123);\r\n\/\/ B1 \u586b\u5165\u5b57\u4e32\r\n$objPHPExcel->getActiveSheet()->setCellValue('B1', 'Test value');\r\n\/\/ C1 \u5132\u5b58\u683c\u8a2d\u5b9a\u5c0f\u6578\u9ede\u5169\u4f4d\u767e\u5206\u6bd4\u683c\u5f0f\r\n$objPHPExcel->getActiveSheet()->getStyle('C1')->getNumberFormat()->setFormatCode('0.00%');\r\n\r\n\/\/ \u5beb\u5165\u5132\u5b58\r\n$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');\r\n$objWriter->save( sys_get_temp_dir() .'\/Report.xls' );\r\n\r\n<\/pre>\n\u5132\u5b58\u683c\u683c\u5f0f\u00a0PHPExcel_Style_NumberFormat<\/a><\/p>\n\u7bc4\u4f8b 2 - \u76f4\u63a5\u8f38\u51fa\u4e0b\u8f09\u6a94\u6848<\/p>\n
<?php\r\nrequire_once WEB_ROOT .'\/Component_Back\/PHPExcel-1.8.1\/Classes\/PHPExcel\/IOFactory.php';\r\n\r\n\/\/\r\n$objPHPExcel = new \\PHPExcel(); \/\/\u5be6\u9ad4\u5316Excel\r\n\r\n$objPHPExcel->setActiveSheetIndex(0); \/\/\u8a2d\u5b9a\u9810\u8a2d\u986f\u793a\u7684\u5de5\u4f5c\u8868\r\n$objActSheet = $objPHPExcel->getActiveSheet(); \/\/\u6307\u5b9a\u9810\u8a2d\u5de5\u4f5c\u8868\u70ba $objActSheet\r\n$objActSheet->setTitle(\"wwww\"); \/\/\u8a2d\u5b9a\u6a19\u984c\r\n\/\/$objPHPExcel->createSheet(); \/\/\u5efa\u7acb\u65b0\u7684\u5de5\u4f5c\u8868\uff0c\u4e0a\u9762\u90a3\u4e09\u884c\u518d\u4f86\u4e00\u6b21\uff0c\u7de8\u865f\u8981\u6539\r\n\r\n\/\/\r\n\r\n$objActSheet->setCellValue('A1', 'xx');\r\n$objActSheet->setCellValue('B1', 'yyy');\r\n$objActSheet->setCellValue('C1', 'zzz');\r\n\r\nheader('Content-Type: application\/vnd.ms-excel');\r\nheader('Content-Disposition: attachment;filename='. $Filename .'aaa.xls');\r\nheader('Cache-Control: max-age=0');\r\n$objWriter = \\PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');\r\n$objWriter->save('php:\/\/output');<\/pre>\n--<\/p>\n
\u8a2d\u5b9a\u5132\u5b58\u683c\u6a23\u5f0f<\/h2>\n\n- phpexcel set font color Code Example (iqcode.com)<\/a><\/li>\n<\/ul>\n
$objActSheet->setCellValue('A2')->getStyle('A2')->getFont()->getColor()->setRGB('FF0000');\r\n<\/pre>\n\u90a3\u500b getStyle('A2') \u4e0d\u53ef\u4ee5\u7701\u7565<\/p>\n
--<\/p>\n
\u5de5\u4f5c\u8868\u6a23\u5f0f<\/h2>\n\n- PHPExcel - change font face for all document<\/a><\/li>\n<\/ul>\n
$writeExcel = new \\PHPExcel();\r\n$writeExcel->setActiveSheetIndex(0); \/\/\u8a2d\u5b9a\u9810\u8a2d\u986f\u793a\u7684\u5de5\u4f5c\u8868\r\n$writeExcel->getDefaultStyle()->applyFromArray(array(\r\n 'font' => array(\r\n 'size' => 14,\r\n 'name' => '\u6b63\u9ed1\u9ad4',\r\n )));<\/pre>\n--<\/p>\n
Fatal error: Allowed memory size<\/h2>\n
\u5728\u5beb\u5165\u5927\u91cf\u8cc7\u6599\u6642\uff0c\u51fa\u73fe\u4e86 Fatal error: Allowed memory size \u7684\u932f\u8aa4\uff0c\u8acb\u4f7f\u7528 ajax \u6280\u8853\u4f86\u7522\u51fa\u6a94\u6848\uff1aXMLHttpRequest - \u975e\u540c\u6b65\u4e0a\u50b3\u6a94\u6848\u53ca\u4e0b\u8f09<\/a><\/p>\n--<\/p>\n
\u6307\u5b9a\u6b04\u4f4d\u683c\u5f0f<\/h2>\n\n- Correct format for strings \/ numbers beginning with zero?<\/a><\/li>\n<\/ul>\n
$objActSheet->setCellValueExplicit('A'.$i, $row['Name'], \\PHPExcel_Cell_DataType::TYPE_STRING);<\/pre>\n\u8981\u6ce8\u610f\u00a0setCellValue \u4fee\u6539\u6210\u00a0setCellValueExplicit<\/p>\n
--<\/p>\n
Fatal error: Class 'XMLWriter' not found<\/h2>\n
\u88dc\u4e00\u500b php-xml \u5c31\u597d\u4e86<\/p>\n
yum install php-xml<\/pre>\n--<\/p>\n
\u8b80\u53d6\u7bc4\u4f8b<\/h2>\n<?php\r\nrequire_once __DIR__ . '\/3rdParty\/PHPExcel-1.8.1\/Classes\/PHPExcel\/IOFactory.php';\r\n$objPHPExcel = @\\PHPExcel_IOFactory::load('\/tmp\/aaaa.xlsx');\r\n$sheetData = $objPHPExcel->getSheet(0)->toArray();\r\n\/\/ $sheetData[0][0]<\/pre>\n$sheetData \u5c31\u662f\u7b2c\u4e00\u500b\u5de5\u4f5c\u8868\u7684\u8cc7\u6599\u9663\u5217<\/p>\n
--<\/p>\n
\u7d19\u5f35\u8a2d\u5b9a<\/h2>\n\n- [\u6559\u5b78\u6587\u7ae0] phpExcel\u5e38\u7528\u65b9\u6cd5\u8a73\u89e3<\/a><\/li>\n<\/ul>\n
A3, \u6a6b<\/p>\n
$objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);\r\n$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3);<\/pre>\n--<\/p>\n
\u8de8\u9801\u91cd\u8907\u6a19\u984c<\/h2>\n\n- Set rows to repeat at top when printing - PHPExcel<\/a><\/li>\n<\/ul>\n
$objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1,1);<\/pre>\n--<\/p>\n
\u81ea\u52d5\u6b04\u5bec<\/h2>\n\n- PHPExcel auto size column width<\/a><\/li>\n
- PHPExcel 1.8<\/a><\/li>\n<\/ul>\n
$sheet = $objPHPExcel->getActiveSheet();\r\n$sheet->getColumnDimension('A')->setAutoSize(true);\r\n$sheet->getColumnDimension('B')->setAutoSize(true);\r\n$sheet->getColumnDimension('C')->setAutoSize(true);<\/pre>\n\u8ff4\u5708<\/p>\n
foreach(range('A','C') as $columnID) {\r\n $objPHPExcel->getActiveSheet()->getColumnDimension($columnID)\r\n ->setAutoSize(true);\r\n}<\/pre>\n--<\/p>\n
\u8a2d\u5b9a\u5b57\u9ad4\u5927\u5c0f\u3001\u5217\u9ad8<\/h2>\n\n- PHPExcel: Setting font size?<\/a><\/li>\n
- PHPExcel How to apply styles and set cell width and cell height to cell generated dynamically<\/a><\/li>\n<\/ul>\n
$objPHPExcel->getActiveSheet()->setCellValue('A1', '\u6284\u8868\u7d00\u9304');\r\n$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(16);\r\n$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(24);<\/pre>\n--<\/p>\n
\u9801\u78bc<\/h2>\n