\u4ee5\u4e0b\u4ee3\u7801\u4e3a\u8bfb\u53d6excle\u6587\u4ef6\u7684\u4fe1\u606f\uff0c\u5e76\u5c06\u5185\u5bb9\u8bfb\u51fa\u4ee5\u4f9b\u5904\u7406\u7684\u4f8b\u5b50<\/p>\n
\r\n\r\n<?php\r\nerror_reporting(E_ALL);\r\nset_time_limit(0);\r\n?>\r\n<html>\r\n<head>\r\n<meta http-equiv="Content-Type" content="text\/html; charset=UTF-8" \/>\r\n<title>\u8bfb\u53d6excle\u6d4b\u8bd5<\/title>\r\n<\/head>\r\n<body>\r\n<h1>\u8bfb\u53d6excle\u7684\u5185\u5bb9\u6d4b\u8bd5<\/h1>\r\n<?php\r\n\/** Include path **\/\r\nset_include_path(get_include_path() . PATH_SEPARATOR . 'Classes\/');\r\n\/** PHPExcel_IOFactory *\/\r\ninclude 'PHPExcel\/IOFactory.php';\r\n$inputFileType = 'Excel5';\r\n$inputFileName = 'test.xls';\r\n\r\n\/** Create a new Reader of the type defined in $inputFileType **\/\r\n$objReader = PHPExcel_IOFactory::createReader($inputFileType);\r\n\/** Load $inputFileName to a PHPExcel Object **\/\r\n$objPHPExcel = $objReader->load($inputFileName);\r\n\/** Read the document's creator property **\/\r\n$creator = $objPHPExcel->getProperties()->getCreator();\r\necho '<b>\u6587\u6863\u521b\u5efa\u8005: <\/b>',$creator,'<br \/>';\r\n\/** Read the Date when the workbook was created (as a PHP timestamp value) **\/\r\n$creationDatestamp = $objPHPExcel->getProperties()->getCreated();\r\n\/** Format the date and time using the standard PHP date() function **\/\r\n$creationDate = date('l, d<\\s\\up>S<\/\\s\\up> F Y',$creationDatestamp);\r\n$creationTime = date('g:i A',$creationDatestamp);\r\necho '<b>\u521b\u5efa\u65f6\u95f4: <\/b>',$creationDate,' at ',$creationTime,'<br \/>';\r\n\/** Read the name of the last person to modify this workbook **\/\r\n$modifiedBy = $objPHPExcel->getProperties()->getLastModifiedBy();\r\necho '<b>\u6700\u540e\u4fee\u6539\u8005: <\/b>',$modifiedBy,'<br \/>';\r\n\/** Read the Date when the workbook was last modified (as a PHP timestamp value) **\/\r\n$modifiedDatestamp = $objPHPExcel->getProperties()->getModified();\r\n\/** Format the date and time using the standard PHP date() function **\/\r\n$modifiedDate = date('l, d<\\s\\up>S<\/\\s\\up> F Y',$modifiedDatestamp);\r\n$modifiedTime = date('g:i A',$modifiedDatestamp);\r\necho '<b>\u6700\u540e\u4fee\u6539\u65f6\u95f4: <\/b>',$modifiedDate,' at ',$modifiedTime,'<br \/>';\r\n\/** Read the workbook title property **\/\r\n$workbookTitle = $objPHPExcel->getProperties()->getTitle();\r\necho '<b>\u6807\u9898: <\/b>',$workbookTitle,'<br \/>';\r\n\/** Read the workbook description property **\/\r\n$description = $objPHPExcel->getProperties()->getDescription();\r\necho '<b>\u63cf\u8ff0: <\/b>',$description,'<br \/>';\r\n\/** Read the workbook subject property **\/\r\n$subject = $objPHPExcel->getProperties()->getSubject();\r\necho '<b>\u4e3b\u9898: <\/b>',$subject,'<br \/>';\r\n\/** Read the workbook keywords property **\/\r\n$keywords = $objPHPExcel->getProperties()->getKeywords();\r\necho '<b>\u5173\u952e\u5b57: <\/b>',$keywords,'<br \/>';\r\n\/** Read the workbook category property **\/\r\n$category = $objPHPExcel->getProperties()->getCategory();\r\necho '<b>\u7c7b\u522b: <\/b>',$category,'<br \/>';\r\n\/** Read the workbook company property **\/\r\n$company = $objPHPExcel->getProperties()->getCompany();\r\necho '<b>\u516c\u53f8: <\/b>',$company,'<br \/>';\r\n\/** Read the workbook manager property **\/\r\n$manager = $objPHPExcel->getProperties()->getManager();\r\necho '<b>\u7ba1\u7406\u8005: <\/b>',$manager,'<br \/>';\r\necho '<hr \/>';\r\necho '\u6587\u4ef6\u5185\u5de5\u4f5c\u8868\u7684\u6570\u91cf:';\r\n\/** Use the PHPExcel object's getSheetCount() method to get a count of the number of WorkSheets in the WorkBook *\/\r\n$sheetCount = $objPHPExcel->getSheetCount();\r\necho $sheetCount.'<br \/>';\r\necho '\u5de5\u4f5c\u8868\u7684\u5185\u5bb9\uff1a<br \/>';\r\n\/** Use the PHPExcel object's getSheetNames() method to get an array listing the names\/titles of the WorkSheets in the WorkBook *\/\r\n$sheetNames = $objPHPExcel->getSheetNames();\r\nforeach($sheetNames as $sheetIndex => $sheetName) {\r\necho $sheetIndex,'#\u5de5\u4f5c\u8868\u7684\u540d\u79f0\u4e3a "',$sheetName,'"<br \/>';\r\n$objPHPExcel->setActiveSheetIndex($sheetIndex);\/\/\u8bbe\u7f6e\u6d3b\u52a8\u8868\u683c\r\n\/\/$sheet = $objPHPExcel->getSheet($sheetIndex);\r\n$sheet = $objPHPExcel->getActiveSheet();\r\n$highestRow = $sheet->getHighestRow(); \/\/\u53d6\u5f97\u603b\u884c\u6570\r\n$highestColumn = $sheet->getHighestColumn(); \/\/\u53d6\u5f97\u603b\u5217\u6570\r\necho '\u8be5\u5de5\u4f5c\u8868\u5171\u6709',$highestRow.'\u884c\uff0c\u6700\u5927\u7684\u5217\u53f7\u662f'.$highestColumn.'<\/br>';\r\necho '<table border="1" cellspacing="0">';\r\nfor($Row=2;$Row<=$highestRow;$Row++) \/\/\u4ece\u7b2c\u4e8c\u884c\u5f00\u59cb\u8bfb\u53d6\u6570\u636e\r\n{\r\necho '<tr>';\r\nfor($Col='A';$Col<=$highestColumn;$Col++) \/\/\u4eceA\u5217\u8bfb\u53d6\u6570\u636e\r\n{\r\n\/\/\u8bfb\u53d6\u5355\u5143\u683c\r\n\/\/echo '<th>'.$objPHPExcel->getSheet($sheetIndex)->getCell("$Col$Row")->getValue()."<\/th>";\r\necho '<th>'.$objPHPExcel->getActiveSheet()->getCell("$Col$Row")->getValue()."<\/th>";\r\n}\r\necho '<\/tr>';\r\n}\r\necho '<\/table><\/br>';\r\n}\r\n?>\r\n<body>\r\n<\/html>\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"\u4ee5\u4e0b\u4ee3\u7801\u4e3a\u8bfb\u53d6excle\u6587\u4ef6\u7684\u4fe1\u606f\uff0c\u5e76\u5c06\u5185\u5bb9\u8bfb\u51fa\u4ee5\u4f9b\u5904\u7406\u7684\u4f8b\u5b50 <?php … \u7ee7\u7eed\u9605\u8bfb