prabha
prabha

Reputation: 43

read data from xlsx file using PHPExcel

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

Upvotes: 0

Views: 1805

Answers (1)

Mauricio Florez
Mauricio Florez

Reputation: 1132

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');

}

Upvotes: 1

Related Questions