- Autofilter
- Basic
- Basic1
- Basic2
- Basic3
- Basic4
- Bitwise
- Chart
-
Chart33a
- 33 Chart create area
- 33 Chart create area 2
- 33 Chart create bar
- 33 Chart create bar custom colors
- 33 Chart create bar labels lines
- 33 Chart create bar stacked
- 33 Chart create bubble
- 33 Chart create column
- 33 Chart create column 2
- 33 Chart create composite.alternate
- 33 Chart create composite
- 33 Chart create line
- 33 Chart create line dateaxis
-
Chart33b
- 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 scatter2
- 33 Chart create scatter3
- 33 Chart create scatter4
- 33 Chart create scatter5 trendlines
- 33 Chart create scatter6 value xaxis
- 33 Chart create scatter7 blanks
- 33 Chart create stock
- 33 Chart create stock2
- ComplexNumbers1
- ComplexNumbers2
- ComplexNumbers3
- ConditionalFormatting
- Database
- DateTime
- DateTime2
- DefinedNames
- Engineering
- Financial1
- Financial2
- Financial3
- HexEtcConversions
- Html
- LookupRef
-
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)
-
Reader2
- 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
- 22 Reader formscomments
- 22 Reader issue1767
- 23 iterateRowsYield
- Reading workbook data
- Table
- Wizards/NumberFormat
37 Chart dynamic title
string(71) "/home/ihlamberhl/devcnja/samples/Chart/../templates/37dynamictitle.xlsx" string(62) "/home/ihlamberhl/devcnja/samples/templates/37dynamictitle.xlsx" Read Xlsx format from/home/ihlamberhl/devcnja/samples/Chart/../templates/37dynamictitle.xlsx in 0.0202 secondsIterate worksheets looking at the charts
Worksheet: Sheet1
chart1 - "Changed Title"
barChart
Rendered image: /tmp/phpspreadsheet/37_Chart_dynamic_title.png
/tmp/phpspreadsheet/37dynamictitle.xlsx in 0.0050 secondsDownload 37dynamictitle.xlsx
Peak memory usage: 32.00390625MB
Write Html format to
/tmp/phpspreadsheet/37dynamictitle.html in 0.0117 secondsDownload 37dynamictitle.html
Peak memory usage: 32.00390625MB