read data from xlsx file using PHPExcel

1.7k views Asked by At

enter image description here

This is My test.xlsx sheet, I want to take only B table data from this Xlsx Sheet Using PHPExcel. (Or any other way).

Please Give Some Suggestion about My Problem.

Thank You

1

There are 1 answers

0
Mauricio Florez On

Pass the cells to be reading

require 'PHPExcel/PHPExcel.php';

$excelFile = 'files/excel1.xlsx';
if (file_exists($excelFile))
{
    $objPHPExcel = PHPExcel_IOFactory::load($excelFile);
    $excelData = $objPHPExcel->setActiveSheetIndex(0)->rangeToArray('H8:K16');

}