Use PhpExcel to read files in Excel

? Phpini_set (display_errors, 1); ini_set (include_path, ini_get (include_path).; F: sourcesPHPExcel_1.7.8-with_documentation-msoffice_formatClasses); set this page to contain paths includePHPExcel. php; includePHPExcelIOFactory. php; defin

? Phpini_set ("display_errors", 1); ini_set ('include _ path', ini_get ('include _ path '). '; F: // sources // PHPExcel_1.7.8-with_documentation-msoffice_format // Classes //'); // set this page to include the path 'phpexcel. php'; include 'phpexcel/IOFactory. php'; defin

 Load ($ fileName); $ worksheet = $ PHPExcel-> getActiveSheet (); $ imageInfo = extractImageFromWorksheet ($ worksheet, "f: //"); print_r ($ imageInfo ); function getExtendFileName ($ file_name) {$ extend = pathinfo ($ file_name); $ extend = strtolower ($ extend ["extension"]); return $ extend ;} function extractImageFromWorksheet ($ worksheet, $ basePath) {$ result = array (); $ imageFileName = ""; foreach ($ worksheet-> getDrawingCollection () as $ drawing) {$ xy = $ drawing-> getCoordinates (); $ path = $ basePath; // for xlsxif ($ drawing instanceof PHPExcel_Worksheet_Drawing) {$ filename = $ drawing-> getPath (); $ imageFileName = $ drawing-> getIndexedFilename (); $ path = $ path. $ drawing-> getIndexedFilename (); copy ($ filename, $ path); $ result [$ xy] = $ path; // for xls} else if ($ drawing instanceof PHPExcel_Worksheet_MemoryDrawing) {$ image = $ drawing-> getImageResource (); $ renderingFunction = $ drawing-> getRenderingFunction (); switch ($ renderingFunction) {case PHPExcel_Worksheet_MemoryDrawing: RENDERING_JPEG: $ imageFileName = $ drawing-> getIndexedFilename (); $ path = $ path. $ drawing-> getIndexedFilename (); imagejpeg ($ image, $ path); break; case PHPExcel_Worksheet_MemoryDrawing: RENDERING_GIF: $ imageFileName = $ drawing-> getIndexedFilename (); $ path = $ path. $ drawing-> getIndexedFilename (); imagegif ($ image, $ path); break; case PHPExcel_Worksheet_MemoryDrawing: RENDERING_PNG: $ imageFileName = $ drawing-> getIndexedFilename (); $ path = $ path. $ drawing-> getIndexedFilename (); imagegif ($ image, $ path); break; case PHPExcel_Worksheet_MemoryDrawing: RENDERING_DEFAULT: $ imageFileName = $ drawing-> getIndexedFilename (); $ path = $ path. $ drawing-> getIndexedFilename (); imagegif ($ image, $ path); break;} $ result [$ xy] = $ imageFileName;} return $ result ;}

Original article address: Use PhpExcel to read files in Excel and thank the original author for sharing them.