PHPExcel Calculations Examples

PHPExcel Calculation Function Examples

PHPExcel Reader Examples

PHPExcel Reader Example #01
Simple File Reader using \PhpOffice\PhpSpreadsheet\IOFactory::load()
PHPExcel Reader Example #02
Simple File Reader using a Specified Reader
PHPExcel Reader Example #03
Simple File Reader using the \PhpOffice\PhpSpreadsheet\IOFactory to Return a Reader
PHPExcel Reader Example #04
Simple File Reader using the \PhpOffice\PhpSpreadsheet\IOFactory to Identify a Reader to Use
PHPExcel Reader Example #05
Simple File Reader using the "Read Data Only" Option
PHPExcel Reader Example #06
Simple File Reader Loading All WorkSheets
PHPExcel Reader Example #07
Simple File Reader Loading a Single Named WorkSheet
PHPExcel Reader Example #08
Simple File Reader Loading Several Named WorkSheets
PHPExcel Reader Example #09
Simple File Reader Using a Read Filter
PHPExcel Reader Example #10
Simple File Reader Using a Configurable Read Filter
PHPExcel Reader Example #11
Reading a Workbook in "Chunks" Using a Configurable Read Filter (Version 1)
PHPExcel Reader Example #12
Reading a Workbook in "Chunks" Using a Configurable Read Filter (Version 2)
PHPExcel Reader Example #13
Simple File Reader for Multiple CSV Files
PHPExcel Reader Example #14
Reading a Large CSV file in "Chunks" to split across multiple Worksheets
PHPExcel Reader Example #15
Simple File Reader for Tab-Separated Value File using the Advanced Value Binder
PHPExcel Reader Example #16
Handling Loader Exceptions using Try/Catch
PHPExcel Reader Example #17
Simple File Reader Loading Several Named WorkSheets
PHPExcel Reader Example #18
Reading list of WorkSheets without loading entire file
PHPExcel Reader Example #19
Reading WorkSheet information without loading entire file

PHPExcel Reading WorkBook Data Examples

PHPExcel Reading WorkBook Data Example #01
Read the WorkBook Properties
PHPExcel Reading WorkBook Data Example #02
Read a list of Custom Properties for a WorkBook
PHPExcel Reading WorkBook Data Example #03
Read Custom Property Values for a WorkBook
PHPExcel Reading WorkBook Data Example #04
Get a List of the Worksheets in a WorkBook