Toggle navigation
PHPSpreadsheet
Autofilter
10 Autofilter
10 Autofilter selection 1
10 Autofilter selection 2
10 Autofilter selection display
Basic
01 Simple
01 Simple download ods
01 Simple download pdf
01 Simple download xls
01 Simple download xlsx
02 Types
03 Formulas
04 Printing
05 Feature demo
06 Largescale
07 Reader
08 Conditional formatting
08 Conditional formatting 2
09 Pagebreaks
11 Documentsecurity
12 CellProtection
13 Calculation
13 CalculationCyclicFormulae
14 Xls
15 Datavalidation
16 Csv
17 Html
17a Html
17b Html
18 Extendedcalculation
19 Namedrange
20 Read Excel2003XML
20 Read Gnumeric
20 Read Ods
20 Read Sylk
20 Read Xls
22 Heavily formatted
23 Sharedstyles
24 Readfilter
25 In memory image
26 Utf8
27 Images Xls
28 Iterator
29 Advanced value binder
30 Template
30 Templatebiff5
31 Document properties write
31 Document properties write xls
37 Page layout view
38 Clone worksheet
39 Dropdown
40 Duplicate style
41 Password
42 RichText
43 Merge workbooks
44 Worksheet info
45 Quadratic equation solver
46 ReadHtml
Calculations/Database
DAVERAGE
DCOUNT
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DVAR
DVARP
Calculations/DateTime
DATE
DATEVALUE
TIME
TIMEVALUE
Chart
32 Chart read write
32 Chart read write HTML
32 Chart read write PDF
33 Chart create area
33 Chart create bar
33 Chart create bar stacked
33 Chart create column
33 Chart create column 2
33 Chart create composite
33 Chart create line
33 Chart create multiple charts
33 Chart create pie
33 Chart create pie custom colors
33 Chart create radar
33 Chart create scatter
33 Chart create stock
34 Chart update
35 Chart render
DefinedNames
AbsoluteNamedRange
CrossWorksheetNamedFormula
NamedFormulaeAndRanges
RelativeNamedRange
RelativeNamedRange2
RelativeNamedRangeAsFunction
ScopedNamedRange
ScopedNamedRange2
SimpleNamedFormula
SimpleNamedRange
Pdf
21 Pdf Domdf
21 Pdf TCPDF
21 Pdf mPDF
21a Pdf
21b Pdf
Reader
01 Simple file reader using IOFactory
02 Simple file reader using a specified reader
03 Simple file reader using the IOFactory to return a reader
04 Simple file reader using the IOFactory to identify a reader to use
05 Simple file reader using the read data only option
06 Simple file reader loading all worksheets
07 Simple file reader loading a single named worksheet
08 Simple file reader loading several named worksheets
09 Simple file reader using a read filter
10 Simple file reader using a configurable read filter
11 Reading a workbook in chunks using a configurable read filter (version 1)
12 Reading a workbook in chunks using a configurable read filter (version 2)
13 Simple file reader for multiple CSV files
14 Reading a large CSV file in chunks to split across multiple worksheets
15 Simple file reader for tab separated value file using the Advanced Value Binder
16 Handling loader exceptions using TryCatch
17 Simple file reader loading several named worksheets
18 Reading list of worksheets without loading entire file
19 Reading worksheet information without loading entire file
20 Reader worksheet hyperlink image
21 Reader CSV Long Integers with String Value Binder
Reading workbook data
Custom properties
Custom property names
Properties
Worksheet count and names
37 Page layout view
11:47:49 Create new Spreadsheet object
11:47:49 Set document properties
11:47:49 Add some data
11:47:49 Write Xlsx format to
/tmp/phpspreadsheet/37_Page_layout_view.xlsx
in 0.0051 seconds