PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.19k forks source link

cannot read data from xlsx #1213

Open boooch opened 7 years ago

boooch commented 7 years ago
<?php

include_once ('PHPExcel.php');
$result=Array();
$file="LookupData_1.xlsx";
$result['ID']  = PHPExcel_IOFactory::identify($file);
$objReader = PHPExcel_IOFactory::createReader($result['ID'] );

$objReader->setLoadAllSheets();
$objPHPExcel = $objReader->load($file);

$result['sheetCount'] = $objPHPExcel->getSheetCount();
$result['sheetNames']  = $objPHPExcel->getSheetNames();

print_r($result);

?>

Result:

Array
(
    [ID] => Excel2007
    [sheetCount] => 1
    [sheetNames] => Array
        (
            [0] => Worksheet
        )

)

But in file several sheets with different names. image LookupData_1.xlsx