\u4ee5\u4e0b\u662fPHPExcel\u5e38\u7528\u65b9\u6cd5\u7684\u7e3d\u6574\u7406:<\/p>\n
\u64cd\u4f5cexcel\u3001\u5bebexcel\u3001\u8b80excel\u3001\u8b80\u5bebcsv\u3001\u5bebhtml\u3001\u5bebpdf<\/p>\n
<\/p>\n
\u64cd\u4f5cexcel<\/strong><\/p>\n 1.header<\/p>\n header(\u201cContent-Type:application\/vnd.ms-excel”); 2.PHPExcel<\/p>\n http:\/\/www.codeplex.com\/PHPExcel<\/a> \u958b\u767c\u5305Tests\u76ee\u9304\u6709\u8a73\u7d30\u4f7f\u7528\u5be6\u4f8b \u5bebexcel<\/strong><\/p>\n \/\/Include class \/\/Set properties \u8a2d\u7f6e\u6587\u4ef6\u5c6c\u6027 \/\/Add some data \u6dfb\u52a0\u6578\u64da \/\/Add comment \u6dfb\u52a0\u8a3b\u91cb \/\/Add rich-text string \u6dfb\u52a0\u6587\u5b57 \u53ef\u8a2d\u7f6e\u6a23\u5f0f \/\/Merge cells \u5408\u4f75\u5206\u96e2\u55ae\u5143\u683c \/\/Protect cells \u4fdd\u8b77\u55ae\u5143\u683c \/\/Set cell number formats \u6578\u5b57\u683c\u5f0f\u5316 \/\/Set column widths \u8a2d\u7f6e\u5217\u5bec\u5ea6 \/\/Set fonts \u8a2d\u7f6e\u5b57\u9ad4 \/\/Set alignments \u8a2d\u7f6e\u5c0d\u9f4a \/\/Set column borders \u8a2d\u7f6e\u5217\u908a\u6846 \/\/Set border colors \u8a2d\u7f6e\u908a\u6846\u984f\u8272 \/\/Set fills \u8a2d\u7f6e\u586b\u5145 \/\/Add a hyperlink to the sheet \u6dfb\u52a0\u93c8\u63a5 \/\/Add a drawing to the worksheet \u6dfb\u52a0\u5716\u7247 \/\/Play around with inserting and removing rows and columns \/\/Add conditional formatting \/\/Set autofilter \u81ea\u52d5\u904e\u6ffe \/\/Hide \u201cPhone” and \u201cfax” column \u96b1\u85cf\u5217 \/\/Set document security \u8a2d\u7f6e\u6587\u6a94\u5b89\u5168 \/\/Set sheet security \u8a2d\u7f6e\u5de5\u4f5c\u8868\u5b89\u5168 \/\/Calculated data \u8a08\u7b97 \/\/Set\u00a0outline levels \/\/Freeze panes \/\/Rows to repeat at top \/\/Set data validation \u9a57\u8b49\u8f38\u5165\u503c \/\/Create a new worksheet, after the default sheet \u5275\u5efa\u65b0\u7684\u5de5\u4f5c\u6a19\u7c64 \/\/Set header and footer. When no different headers for odd\/even are used, odd header is assumed. \u9801\u7709\u9801\u8173 \/\/Set page orientation and size \u65b9\u5411\u5927\u5c0f \/\/Rename sheet \u91cd\u547d\u540d\u5de5\u4f5c\u8868\u6a19\u7c64 \/\/Set active sheet index to the first sheet, so Excel opens this as the first sheet \/\/Save Excel 2007 file \u4fdd\u5b58 \/\/Save Excel 5 file \u4fdd\u5b58 \/\/1.6.2\u65b0\u7248\u4fdd\u5b58 \u8b80excel<\/strong> $objPHPExcel = $objReader->load(\u201c05featuredemo.xlsx”);<\/p>\n \u8b80\u5bebcsv<\/strong><\/p>\n require_once(\u201c05featuredemo.inc.php”); \/\/Write to CSV format \u5beb \/\/Read from CSV format \u8b80 \/\/Write to Excel2007 format \u5bebhtml<\/strong><\/p>\n require_once(\u201c05featuredemo.inc.php”); \/\/Write to HTML format \u5bebpdf<\/strong><\/p>\n require_once(\u201c05featuredemo.inc.php”); \/\/Write to PDF format \u4ee5\u4e0b\u662fPHPExcel\u5e38\u7528\u65b9\u6cd5\u7684\u7e3d\u6574\u7406: \u64cd\u4f5cexcel\u3001\u5bebexcel\u3001\u8b80excel\u3001\u8b80\u5bebcsv\u3001\u5bebhtml\u3001 … \u95b1\u8b80\u5168\u6587\u3008[PHP]PHPExcel\u5e38\u7528\u65b9\u6cd5\u8a73\u89e3\u3009<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2256"}],"collection":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2256"}],"version-history":[{"count":1,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2256\/revisions"}],"predecessor-version":[{"id":2257,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2256\/revisions\/2257"}],"wp:attachment":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nheader(\u201cContent-Disposition:attachment;filename=product.xls”);
\nheader(\u201cPragma:no-cache”);
\nheader(\u201cExpires:0\u2033);<\/p>\n
\nhttp:\/\/www.phpexcel.net<\/a><\/p>\n
\n\u652f\u6301\u4e2d\u6587,\u6ce8\u610f\u6587\u4ef6\u7de8\u78bc,\u6587\u4ef6\u4fdd\u5b58\u70bautf-8<\/p>\n
\nrequire_once(\u2018Classes\/PHPExcel.php\u2019);
\nrequire_once(\u2018Classes\/PHPExcel\/Writer\/Excel2007.php\u2019);
\n$objPHPExcel = new PHPExcel();<\/p>\n
\n$objPHPExcel->getProperties()->setCreator(\u201cMaarten Balliauw”);
\n$objPHPExcel->getProperties()->setLastModifiedBy(\u201cMaarten Balliauw”);
\n$objPHPExcel->getProperties()->setTitle(\u201cOffice 2007 XLSX Test Document”);
\n$objPHPExcel->getProperties()->setSubject(\u201cOffice 2007 XLSX Test Document”);
\n$objPHPExcel->getProperties()->setDescription(\u201cTest document\u00a0for\u00a0Office 2007 XLSX, generated using PHP classes.”);
\n$objPHPExcel->getProperties()->setKeywords(\u201coffice 2007 openxml php”);
\n$objPHPExcel->getProperties()->setCategory(\u201cTest result file”);<\/p>\n
\n$objPHPExcel->setActiveSheetIndex(0);
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018A1\u2032, \u2018Hello\u2019);\/\/\u53ef\u4ee5\u6307\u5b9a\u4f4d\u7f6e
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018A2\u2032, true);
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018A3\u2032, false);
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018B2\u2032, \u2018world!\u2019);
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018B3\u2032, 2);
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018C1\u2032, \u2018Hello\u2019);
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018D2\u2032, \u2018world!\u2019);
\n\/\/\u5faa\u74b0
\nfor($i = 1;$i<200;$i++) {
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018A\u2019 . $i, $i);
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018B\u2019 . $i, \u2018Test value\u2019);
\n}
\n\/\/\u65e5\u671f\u683c\u5f0f\u5316
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018D1\u2032, time());
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018D1\u2032)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getComment(\u2018E11\u2032)->setAuthor(\u2018PHPExcel\u2019);
\n$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment(\u2018E11\u2032)->getText()->createTextRun(\u2018PHPExcel:\u2019);
\n$objCommentRichText->getFont()->setBold(true);
\n$objPHPExcel->getActiveSheet()->getComment(\u2018E11\u2032)->getText()->createTextRun(\u201c\\r\\n”);
\n$objPHPExcel->getActiveSheet()->getComment(\u2018E11\u2032)->getText()->createTextRun(\u2018Total amount on\u00a0the\u00a0current invoice, excluding VAT.\u2019);<\/p>\n
\n$objRichText = new PHPExcel_RichText( $objPHPExcel->getActiveSheet()->getCell(\u2018A18\u2032) );
\n$objRichText->createText(\u2018This invoice is \u2018);
\n$objPayable = $objRichText->createTextRun(\u2018payable within thirty days after the end of the month\u2019);
\n$objPayable->getFont()->setBold(true);
\n$objPayable->getFont()->setItalic(true);
\n$objPayable->getFont()->setColor( new PHPExcel_Style_Color( PHPExcel_Style_Color::COLOR_DARKGREEN ) );
\n$objRichText->createText(\u2018, unless specified otherwise on the invoice.\u2019);<\/p>\n
\n$objPHPExcel->getActiveSheet()->mergeCells(\u2018A18:E22\u2032);
\n$objPHPExcel->getActiveSheet()->unmergeCells(\u2018A18:E22\u2032);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);\/\/Needs to be set to true in\u00a0order\u00a0to enable any worksheet protection!
\n$objPHPExcel->getActiveSheet()->protectCells(\u2018A3:E13\u2032, \u2018PHPExcel\u2019);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018E4\u2032)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE);
\n$objPHPExcel->getActiveSheet()->duplicateStyle( $objPHPExcel->getActiveSheet()->getStyle(\u2018E4\u2032), \u2018E5:E13\u2032 );<\/p>\n
\n$objPHPExcel->getActiveSheet()->getColumnDimension(\u2018B\u2019)->setAutoSize(true);
\n$objPHPExcel->getActiveSheet()->getColumnDimension(\u2018D\u2019)->setWidth(12);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018B1\u2032)->getFont()->setName(\u2018Candara\u2019);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018B1\u2032)->getFont()->setSize(20);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018B1\u2032)->getFont()->setBold(true);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018B1\u2032)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018B1\u2032)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018D11\u2032)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018A18\u2032)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018A18\u2032)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018A3\u2032)->getAlignment()->setWrapText(true);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018A4\u2032)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018A10\u2032)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018E10\u2032)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018D13\u2032)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018E13\u2032)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018D13\u2032)->getBorders()->getLeft()->getColor()->setARGB(\u2018FF993300\u2032);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018D13\u2032)->getBorders()->getTop()->getColor()->setARGB(\u2018FF993300\u2032);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018D13\u2032)->getBorders()->getBottom()->getColor()->setARGB(\u2018FF993300\u2032);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018E13\u2032)->getBorders()->getRight()->getColor()->setARGB(\u2018FF993300\u2032);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018A1\u2032)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018A1\u2032)->getFill()->getStartColor()->setARGB(\u2018FF808080\u2032);<\/p>\n
\n$objPHPExcel->getActiveSheet()->setCellValue(\u2018E26\u2032, \u2018www.phpexcel.net\u2019);
\n$objPHPExcel->getActiveSheet()->getCell(\u2018E26\u2032)->getHyperlink()->setUrl(\u2018http:\/\/www.phpexcel.net\u2019);
\n$objPHPExcel->getActiveSheet()->getCell(\u2018E26\u2032)->getHyperlink()->setTooltip(\u2018Navigate to website\u2019);
\n$objPHPExcel->getActiveSheet()->getStyle(\u2018E26\u2032)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);<\/p>\n
\n$objDrawing = new PHPExcel_Worksheet_Drawing();
\n$objDrawing->setName(\u2018Logo\u2019);
\n$objDrawing->setDescription(\u2018Logo\u2019);
\n$objDrawing->setPath(\u2018.\/images\/officelogo.jpg\u2019);
\n$objDrawing->setHeight(36);
\n$objDrawing->setCoordinates(\u2018B15\u2032);
\n$objDrawing->setOffsetX(110);
\n$objDrawing->setRotation(25);
\n$objDrawing->getShadow()->setVisible(true);
\n$objDrawing->getShadow()->setDirection(45);
\n$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());<\/p>\n
\n$objPHPExcel->getActiveSheet()->insertNewRowBefore(6, 10);
\n$objPHPExcel->getActiveSheet()->removeRow(6, 10);
\n$objPHPExcel->getActiveSheet()->insertNewColumnBefore(\u2018E\u2019, 5);
\n$objPHPExcel->getActiveSheet()->removeColumn(\u2018E\u2019, 5);<\/p>\n
\n$objConditional1 = new PHPExcel_Style_Conditional();
\n$objConditional1->setConditionType(PHPExcel_Style_Conditional::CONDITION_CELLIS);
\n$objConditional1->setOperatorType(PHPExcel_Style_Conditional::OPERATOR_LESSTHAN);
\n$objConditional1->setCondition(\u20190\u2032);
\n$objConditional1->getStyle()->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);
\n$objConditional1->getStyle()->getFont()->setBold(true);<\/p>\n
\n$objPHPExcel->getActiveSheet()->setAutoFilter(\u2018A1:C9\u2032);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getColumnDimension(\u2018C\u2019)->setVisible(false);
\n$objPHPExcel->getActiveSheet()->getColumnDimension(\u2018D\u2019)->setVisible(false);<\/p>\n
\n$objPHPExcel->getSecurity()->setLockWindows(true);
\n$objPHPExcel->getSecurity()->setLockStructure(true);
\n$objPHPExcel->getSecurity()->setWorkbookPassword(\u201cPHPExcel”);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getProtection()->setPassword(\u2018PHPExcel\u2019);
\n$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);\/\/ This should be enabled in order to enable any of the following!
\n$objPHPExcel->getActiveSheet()->getProtection()->setSort(true);
\n$objPHPExcel->getActiveSheet()->getProtection()->setInsertRows(true);
\n$objPHPExcel->getActiveSheet()->getProtection()->setFormatCells(true);<\/p>\n
\necho \u2018Value of B14 [=COUNT(B2:B12)]: \u2018 . $objPHPExcel->getActiveSheet()->getCell(\u2018B14\u2032)->getCalculatedValue() . \u201c\\r\\n”;<\/p>\n
\n$objPHPExcel->getActiveSheet()->getColumnDimension(\u2018E\u2019)->setOutlineLevel(1);
\n$objPHPExcel->getActiveSheet()->getColumnDimension(\u2018E\u2019)->setVisible(false);
\n$objPHPExcel->getActiveSheet()->getColumnDimension(\u2018E\u2019)->setCollapsed(true);<\/p>\n
\n$objPHPExcel->getActiveSheet()->freezePane(\u2018A2\u2032);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1, 1);<\/p>\n
\n$objValidation = $objPHPExcel->getActiveSheet()->getCell(\u2018B3\u2032)->getDataValidation();
\n$objValidation->setType( PHPExcel_Cell_DataValidation::TYPE_WHOLE );
\n$objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_STOP );
\n$objValidation->setAllowBlank(true);
\n$objValidation->setShowInputMessage(true);
\n$objValidation->setShowErrorMessage(true);
\n$objValidation->setErrorTitle(\u2018Input error\u2019);
\n$objValidation->setError(\u2018Number is not allowed!\u2019);
\n$objValidation->setPromptTitle(\u2018Allowed input\u2019);
\n$objValidation->setPrompt(\u2018Only numbers between 10 and 20 are allowed.\u2019);
\n$objValidation->setFormula1(10);
\n$objValidation->setFormula2(20);
\n$objPHPExcel->getActiveSheet()->getCell(\u2018B3\u2032)->setDataValidation($objValidation);<\/p>\n
\n$objPHPExcel->createSheet();
\n$objPHPExcel->setActiveSheetIndex(1);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader(\u2018&C&HPlease treat this document as confidential!\u2019);
\n$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter(\u2018&L&B\u2019 . $objPHPExcel->getProperties()->getTitle() . \u2018&RPage &P of &N\u2019);<\/p>\n
\n$objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
\n$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);<\/p>\n
\n$objPHPExcel->getActiveSheet()->setTitle(\u2018Simple\u2019);<\/p>\n
\n$objPHPExcel->setActiveSheetIndex(0);<\/p>\n
\n$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
\n$objWriter->save(str_replace(\u2018.php\u2019, \u2018.xlsx\u2019, __FILE__));<\/p>\n
\nrequire_once(\u2018Classes\/PHPExcel\/Writer\/Excel5.php\u2019);
\n$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
\n$objWriter->save(str_replace(\u2018.php\u2019, \u2018.xls\u2019, __FILE__));<\/p>\n
\nrequire_once(\u2018Classes\/PHPExcel\/IOFactory.php\u2019);
\n$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, \u2018Excel2007\u2032);
\n$objWriter->save(str_replace(\u2018.php\u2019, \u2018.xls\u2019, __FILE__));<\/p>\n
\n\/\/Include class
\nrequire_once(\u2018Classes\/PHPExcel\/Reader\/Excel2007.php\u2019);
\n$objReader = new PHPExcel_Reader_Excel2007;<\/p>\n
\nrequire_once(\u2018Classes\/PHPExcel\/Writer\/CSV.php\u2019);
\nrequire_once(\u2018Classes\/PHPExcel\/Reader\/CSV.php\u2019);
\nrequire_once(\u2018Classes\/PHPExcel\/Writer\/Excel2007.php\u2019);<\/p>\n
\n$objWriter = new PHPExcel_Writer_CSV($objPHPExcel);
\n$objWriter->setDelimiter(\u2018;\u2019);
\n$objWriter->setEnclosure(\u201c);
\n$objWriter->setLineEnding(\u201c\\r\\n”);
\n$objWriter->setSheetIndex(0);
\n$objWriter->save(str_replace(\u2018.php\u2019, \u2018.csv\u2019, __FILE__));<\/p>\n
\n$objReader = new PHPExcel_Reader_CSV();
\n$objReader->setDelimiter(\u2018;\u2019);
\n$objReader->setEnclosure(\u201c);
\n$objReader->setLineEnding(\u201c\\r\\n”);
\n$objReader->setSheetIndex(0);
\n$objPHPExcelFromCSV = $objReader->load(str_replace(\u2018.php\u2019, \u2018.csv\u2019, __FILE__));<\/p>\n
\n$objWriter2007 = new PHPExcel_Writer_Excel2007($objPHPExcelFromCSV);
\n$objWriter2007->save(str_replace(\u2018.php\u2019, \u2018.xlsx\u2019, __FILE__));<\/p>\n
\nrequire_once(\u2018Classes\/PHPExcel\/Writer\/HTML.php\u2019);<\/p>\n
\n$objWriter = new PHPExcel_Writer_HTML($objPHPExcel);
\n$objWriter->setSheetIndex(0);
\n$objWriter->save(str_replace(\u2018.php\u2019, \u2018.htm\u2019, __FILE__));<\/p>\n
\nrequire_once(\u2018Classes\/PHPExcel\/IOFactory.php\u2019);<\/p>\n
\n$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, \u2018PDF\u2019);
\n$objWriter->setSheetIndex(0);
\n$objWriter->save(str_replace(\u2018.php\u2019, \u2018.pdf\u2019, __FILE__));
\n\/\/Echo memory peak usage
\necho date(\u2018H:i:s\u2019) . ” Peak memory usage: ” . (memory_get_peak_usage(true) \/ 1024 \/ 1024) . ” MB\\r\\n”;<\/p>\n","protected":false},"excerpt":{"rendered":"