PhpSpreadsheet Calculations Examples

PhpSpreadsheet Calculation Function Examples

PhpSpreadsheet Reader Examples

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

PhpSpreadsheet Reading WorkBook Data Examples

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