<\/p>\n
<?php \r\n\/** Include PHPExcel_IOFactory *\/\r\nrequire_once (JPATH_COMPONENT_ADMINISTRATOR.DS.'helpers\/PHPExcel\/Classes\/PHPExcel\/IOFactory.php');\r\n\r\n\/\/ Read XLS file\r\n$objPHPExcel = PHPExcel_IOFactory::load($filepath);\t\t\r\n$rows = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);\r\n\r\n\/\/ Read CSV file\r\n$inputFileType = 'CSV';\r\n$inputFileName = $filepath;\r\n$objReader = PHPExcel_IOFactory::createReader($inputFileType);\r\n$objPHPExcel = $objReader->load($inputFileName);\r\n\r\n$worksheet = $objPHPExcel->getActiveSheet();\r\nforeach ($worksheet->getRowIterator() as $row) {\r\n\techo 'Row number: ' . $row->getRowIndex() . \"\\r\\n\";\r\n\r\n $cellIterator = $row->getCellIterator();\r\n\t$cellIterator->setIterateOnlyExistingCells(false); \/\/ Loop all cells, even if it is not set\r\n\tforeach ($cellIterator as $cell) {\r\n\t\tif (!is_null($cell)) {\r\n\t\t\techo 'Cell: ' . $cell->getCoordinate() . ' - ' . $cell->getValue() . \"\\r\\n\";\r\n\t\t}\r\n\t}\r\n}\r\n\r\nOR\r\n\r\n$objWorksheet = $objPHPExcel->getActiveSheet();\r\n$highestRow = $objWorksheet->getHighestRow();\r\n$highestColumn = $objWorksheet->getHighestColumn();\r\n$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);\r\n\r\n\/\/read from file\r\n$rows = array();\r\nfor ($row = 1; $row <= $highestRow; ++$row)\r\n{\r\n\t$file_data = array();\r\n\tfor ($col = 0; $col < $highestColumnIndex; ++$col) \t{ \t\t$value=$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();\r\n\t\t$file_data[$col]=trim($value);\r\n\t}\r\n\t$rows[] = $file_data;\r\n}\r\n?><\/pre>\n","protected":false},"excerpt":{"rendered":" <?php \/** Include PHPExcel_IOFactory *\/ require_once (JPATH_COMPONENT_ADMINISTRATOR.DS.’helpers\/PHPExcel\/Classes\/PHPExcel\/IOFactory.php’); \/\/ Read XLS file $objPHPExcel = PHPExcel_IOFactory::load($filepath); $rows = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true); \/\/ Read CSV file $inputFileType = ‘CSV’; $inputFileName = $filepath; $objReader = PHPExcel_IOFactory::createReader($inputFileType); $objPHPExcel = $objReader->load($inputFileName); $worksheet = $objPHPExcel->getActiveSheet(); foreach ($worksheet->getRowIterator() as $row) { echo ‘Row number: ‘ . $row->getRowIndex() . “\\r\\n”; $cellIterator = $row->getCellIterator(); $cellIterator->setIterateOnlyExistingCells(false); \/\/ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-41","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/ronniee.net\/index.php?rest_route=\/wp\/v2\/posts\/41","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ronniee.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ronniee.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ronniee.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ronniee.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=41"}],"version-history":[{"count":5,"href":"https:\/\/ronniee.net\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions"}],"predecessor-version":[{"id":43,"href":"https:\/\/ronniee.net\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions\/43"}],"wp:attachment":[{"href":"https:\/\/ronniee.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ronniee.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ronniee.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}