Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
gilour
/
vendor
/
phpoffice
/
phpspreadsheet
/
samples
/
Reader
:
06_Simple_file_reader_loading_all_worksheets.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php use PhpOffice\PhpSpreadsheet\IOFactory; require __DIR__ . '/../Header.php'; $inputFileType = 'Xls'; $inputFileName = __DIR__ . '/sampleData/example1.xls'; $helper->log('Loading file ' . pathinfo($inputFileName, PATHINFO_BASENAME) . ' using IOFactory with a defined reader type of ' . $inputFileType); $reader = IOFactory::createReader($inputFileType); $helper->log('Loading all WorkSheets'); $reader->setLoadAllSheets(); $spreadsheet = $reader->load($inputFileName); $helper->log($spreadsheet->getSheetCount() . ' worksheet' . (($spreadsheet->getSheetCount() == 1) ? '' : 's') . ' loaded'); $loadedSheetNames = $spreadsheet->getSheetNames(); foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) { $helper->log($sheetIndex . ' -> ' . $loadedSheetName); }