Reputation: 43
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
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