PHPExcel
Classes
Documentation
Examples
assets
markdown
CalculationEngine
Features
Functions
Overview
ReadingSpreadsheetFiles
01-File-Formats.md
02-Security.md
03-Loading-a-Spreadsheet.md
04-Loading-with-a-Reader.md
05-Reader-Options.md
06-Error-Handling.md
07-Helper-Methods.md
FunctionListByCategory.txt
FunctionListByName.txt
Functionality Cross-Reference.xls
PHPExcel AutoFilter Reference developer documentation.doc
PHPExcel Function Reference developer documentation.doc
PHPExcel User Documentation - Reading Spreadsheet Files.doc
PHPExcel developer documentation.doc
Examples
.gitattributes
.gitignore
.travis.yml
changelog.txt
composer.json
install.txt
license.md
chart
classes
config
datepicker
html2pdf_v4.03
language
lib
overlib
progress
templates
templates_c
admin_bearbeiten.php
config.inc.php
detail_prof.php
detail_prof_pdf.php
erf_besausg.php
erf_besschnitt.php
erf_deltas.php
erf_grundgehalt.php
erf_lb_bz.php
erf_lb_einmal.php
erf_lb_fz.php
erf_lz.php
erf_vza.php
func_LB_BZ.php
func_LB_BZ_fiktiv.php
func_LB_FZ.php
func_LB_FZ_alt.php
func_LB_LZ.php
func_LB_einmal.php
func_LB_obergrenze.php
func_LB_obergrenze_Limit.php
func_LB_obergrenze_Limit_stufe1.php
func_LB_obergrenze_Limit_stufe2.php
func_agent.php
func_besschnitt.php
func_doz_nachbes.php
func_doz_synopse.php
func_genUser.php
func_gesamtberechnung.php
func_grundgehalt.php
func_rollenrechte.php
func_zusammenstellung.php
funktionen_bearbeiten.php
graph_einzeljahr.php
graph_jahre.php
hauptframe.php
index.php
indexframe.php
jahrgang.php
korr_verg.php
load.php
login_log.php
logout.php
lzb_excel.php
menuframe.php
parameter.php
pdf_jahr.php
prof_anlegen.php
prof_bearbeiten.php
prof_bearbeiten.php_20180314
prognose.sql
rollen.php
topframe.php
ubersicht_jahr.php
ubersicht_jahr.php_20180829
user_anlegen.php
user_bearbeiten.php
useronline.php
48 lines
1.6 KiB
Markdown
Executable File
48 lines
1.6 KiB
Markdown
Executable File
# PHPExcel User Documentation – Reading Spreadsheet Files
|
||
|
||
|
||
## Helper Methods
|
||
|
||
You can retrieve a list of worksheet names contained in a file without loading the whole file by using the Reader’s `listWorksheetNames()` method; similarly, a `listWorksheetInfo()` method will retrieve the dimensions of worksheet in a file without needing to load and parse the whole file.
|
||
|
||
### listWorksheetNames
|
||
|
||
The `listWorksheetNames()` method returns a simple array listing each worksheet name within the workbook:
|
||
|
||
```php
|
||
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
|
||
|
||
$worksheetNames = $objReader->listWorksheetNames($inputFileName);
|
||
|
||
echo '<h3>Worksheet Names</h3>';
|
||
echo '<ol>';
|
||
foreach ($worksheetNames as $worksheetName) {
|
||
echo '<li>', $worksheetName, '</li>';
|
||
}
|
||
echo '</ol>';
|
||
```
|
||
> See Examples/Reader/exampleReader18.php for a working example of this code.
|
||
|
||
### listWorksheetInfo
|
||
|
||
The `listWorksheetInfo()` method returns a nested array, with each entry listing the name and dimensions for a worksheet:
|
||
|
||
```php
|
||
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
|
||
|
||
$worksheetData = $objReader->listWorksheetInfo($inputFileName);
|
||
|
||
echo '<h3>Worksheet Information</h3>';
|
||
echo '<ol>';
|
||
foreach ($worksheetData as $worksheet) {
|
||
echo '<li>', $worksheet['worksheetName'], '<br />';
|
||
echo 'Rows: ', $worksheet['totalRows'],
|
||
' Columns: ', $worksheet['totalColumns'], '<br />';
|
||
echo 'Cell Range: A1:',
|
||
$worksheet['lastColumnLetter'], $worksheet['totalRows'];
|
||
echo '</li>';
|
||
}
|
||
echo '</ol>';
|
||
```
|
||
> See Examples/Reader/exampleReader19.php for a working example of this code.
|