Weave Code
Weaver
Helps Laravel developers discover, compare, and choose open-source packages. See popularity, security, maintainers, and scores at a glance to make better decisions.
Feedback
Share your thoughts, report bugs, or suggest improvements.
Subject
Message
Log in Register
Home
Packages
Phpspreadsheet
Release Notes

Phpspreadsheet Laravel Package

phpoffice/phpspreadsheet

PhpSpreadsheet is a pure PHP library for reading and writing spreadsheet files such as Excel and LibreOffice Calc. It provides a rich set of classes for working with workbooks, worksheets, formulas, and styling, making spreadsheet import, export, and manipulation straightforward in PHP applications.

View on GitHub
Deep Wiki
Context7
5.10.0

Added

  • XLSX password-to-open encryption and decryption using Office Agile encryption. Issue #3878 PR #4975 PR #4988
  • Support for Excel sparklines (line, column, and win/loss) in Xlsx reader and writer. Issue #4941
  • Read-only object model for Pivot Tables. Existing pivot tables in an Xlsx file are now parsed into Worksheet\PivotTable\PivotTable objects (name, location, source cache definition, and row/column/page/data field layout), accessible via Worksheet::getPivotTableCollection() / getPivotTableByName(). Pivot tables (their tables, caches and records) are now also preserved through an Xlsx load/save round-trip instead of being silently dropped. Issue #4534

Changed

  • Performance: avoid Worksheet::getStyle() on every Cell::setValueExplicit() unless quote-prefix must change. On a dense 40k-cell populate+save microbenchmark this cut wall time by ~5%. PR #4958
  • Infrastructure changes for documentation. PR #4973

Fixed

  • Security patches.
  • Xls Writer now creates conformant CFB/DIFAT metadata at FAT-sector boundaries. Issue #4811 PR #4983
  • Ods Reader/Writer Drawings. Issue #4809 PR #4956
  • Ods Writer no longer converts cell references or commas inside string literals, so ="THIS IS E1" is written unchanged instead of as ="THIS IS [.E1]". Issue #4454 PR #4962
  • Ods Reader/Writer slight improvement for Date styles. PR #4960
  • BETAINV/BETA.INV no longer abandons its search when the Beta CDF underflows to zero (wrong results for alpha above about 1080). PR #4954
  • GAMMA.INV, the GAMMA.DIST/CHISQ.DIST/F.DIST densities, and GAMMALN no longer fail or return wrong results for large shape parameters / degrees of freedom. PR #4953
  • GAMMAINV/GAMMA.INV no longer clamps upper-tail quantiles beyond alphabeta5. PR #4946
  • Correct incomplete gamma convergence for GAMMA.DIST/CHISQ.DIST family (wrong once the series argument reached ~32). PR #4945
  • Fix problem with VLOOKUP and whole-column ranges. Issue #4969 PR #4967
  • Problem with Xlsx Writer and header-row table. PR #4968
  • Throw when Ods Reader encounters invalid Xml. PR #4986
  • Update Sheetname in Charts when Sheetname changes. Issue #744 PR #4984
5.9.0

Removed

Added

Changed

  • Restructure parsing logic in Reader/Xlsx. PR #4830

Fixed

5.8.1

Last version with support for Php 8.1.

Added

Changed

  • Restructure parsing logic in Reader/Xlsx. PR #4830

Fixed

1.30.6

Fixed

  • Security patches.
3.10.7

Fixed

  • Security patches.
2.4.7

Fixed

  • Security patches.
2.1.18

Fixed

  • Security patches.
5.8.0

This will probably be the last release on the master branch that supports Php8.1.

Security Note

  • File::prohibitWrappers and Drawing::setPath now reject phar paths with extra leading slashes (e.g. phar:///…) that escaped the prior parse_url-based filter. No security exploit was possible even with the extra slashes. PR #4876

Added

  • Optional method to increase Calculation Engine's parsing speed. PR #4829
  • Html Writer/Reader new data attributes. PR #4858
  • IReader2 interface extending IReader with listWorksheetInfo/Names. Issue #4883 PR #4886

Changed

  • Helper/Handler is now internal and final. PR #4896

Fixed

  • Html Writer handle text colors a bit better. PR #4855
  • Html Writer apply rotation to images. Issue #4875 PR #4877
  • Work around Php8.6 deprecation in mpdf/mpdf. PR #4878
  • Ability to reuse disconnected spreadsheet. PR #4880
  • Allow int parameter for getChartIndex. PR #4896
3.10.6

Security Note

  • File::prohibitWrappers and Drawing::setPath now reject phar paths with extra leading slashes (e.g. phar:///…) that escaped the prior parse_url-based filter. No security exploit was possible even with the extra slashes. Backport of PR #4876

Fixed

  • Third-party security patches.
  • Php 8.6 deprecation in Mpdf. Backport of PR #4878
  • Ability to reuse disconnected spreadsheet. Backport of PR #4880
2.4.6

Security Note

  • File::prohibitWrappers and Drawing::setPath now reject phar paths with extra leading slashes (e.g. phar:///…) that escaped the prior parse_url-based filter. No security exploit was possible even with the extra slashes. Backport of PR #4876

Fixed

  • Third-party security patches.
  • Php 8.6 deprecation in Mpdf. Backport of PR #4878
  • Ability to reuse disconnected spreadsheet. Backport of PR #4880
2.1.17

Security Note

  • File::prohibitWrappers and Drawing::setPath now reject phar paths with extra leading slashes (e.g. phar:///…) that escaped the prior parse_url-based filter. No security exploit was possible even with the extra slashes. Backport of PR #4876

Fixed

  • Security patches.
1.30.5

Security Note

  • File::prohibitWrappers and Drawing::setPath now reject phar paths with extra leading slashes (e.g. phar:///…) that escaped the prior parse_url-based filter.

Fixed

  • Third-party security patches.
5.7.0

Fixed

  • Security patches.
1.30.4

Fixed

  • Security patches.
3.10.5

Fixed

  • Security patches.
2.4.5

Fixed

  • Security patches.
2.1.16

Fixed

  • Security patches.
5.6.0

Added

  • Make Reader/Csv Extendable, add new preferred Reader/CsvNoEscape class. Issue #4836 PR #4837 PR #4845
  • XLOOKUP function. Issue #1453 PR #4844
  • Introduction of a benchmark test suite, independent of the default unit test suite. Users can use it as a template for experimenting and making decisions concerning performance. PR #4824

Deprecated

  • Collection/Cells::MAX_COLUMN_ID - use Cell/AddressRange::MAX_COLUMN_INT.
  • Writer/Xls/Worksheet constants MAX_XLS_COLUMN, MAX_XLS_COLUMN_STRING, MAX_XLS_ROW - use Cell/AddressRange MAX_COLUMN_INT_XLS, MAX_COLUMN_XLS, MAX_ROW_XLS

Fixed

1.30.3

Fixed

  • Security patches.
  • Option to whitelist external images. Security-related backport of PR #4793
3.10.4

Fixed

  • Security patches.
  • Option to whitelist external images. Security-related backport of PR #4793
2.4.4

Fixed

  • Security patches.
  • Option to whitelist external images. Security-related backport of PR #4793
2.1.15

Fixed

  • Security patches.
  • Option to whitelist external images. Security-related backport of PR #4793
5.5.0

Added

  • Much improved handling of Styles by Ods Reader. The relevant changes are listed at the end of the "Fixed" section below.
  • Option to use OldCalculatedValue in ToArray and Relatives. Issue #1810 PR #4787
  • Add checkbox style (Xlsx and Html). PR #4781
  • Option to whitelist external images. PR #4793
  • Writer/Html add ability to set line ending. PR #4779
  • Writer/Html optionally save formulas as data attributes. PR #4783
  • User-supplied headers and footers in PDF. Issue #3159 PR #4789

Deprecated

  • Writer/Html constant BODY_LINE no longer makes sense with a configurable line ending. No replacement.
  • Calculation classes FormulaParser and FormulaToken are unused. No replacement.
  • Writer/Xls/Worksheet methods insertBitMap, positionImage, writeObjPicture, processBitmapGd, and processBitmap are unused. No replacement.

Fixed

5.4.0

Added

Changed

  • Evaluation of WEBSERVICE no longer requires external client, but will use oldCalculatedValue unless the request is for a domain in a user-supplied whitelist. PR #4751

Moved

  • Code to merge cell base style with table and conditional styles moved from Html Writer to its own class. Issue #1058 PR #4763

Deprecated

  • Settings methods setHttpClient, unsetHttpClient, getHttpClient, and getRequestFactory are no longer used. No replacement.
  • Reader/Html protected property dataArray, described as used only for testing, is not used for testing. No replacement.

Fixed

3.10.3

Changed

  • Evaluation of WEBSERVICE no longer requires external client, but will use oldCalculatedValue unless the request is for a domain in a user-supplied whitelist. Security-related backport of PR #4751

Deprecated

  • Settings methods setHttpClient, unsetHttpClient, getHttpClient, and getRequestFactory are no longer used. No replacement.

Fixed

  • Changes to WEBSERVICE. Backport of PR #4751
2.4.3

Changed

  • Evaluation of WEBSERVICE no longer requires external client, but will use oldCalculatedValue unless the request is for a domain in a user-supplied whitelist. Security-related backport of PR #4751

Deprecated

  • Settings methods setHttpClient, unsetHttpClient, getHttpClient, and getRequestFactory are no longer used. No replacement.

Fixed

  • Changes to WEBSERVICE. Backport of PR #4751
2.1.14

Changed

  • Evaluation of WEBSERVICE no longer requires external client, but will use oldCalculatedValue unless the request is for a domain in a user-supplied whitelist. Security-related backport of PR #4751

Deprecated

  • Settings methods setHttpClient, unsetHttpClient, getHttpClient, and getRequestFactory are no longer used. No replacement.

Fixed

  • Changes to WEBSERVICE. Backport of PR #4751
1.30.2

Changed

  • Evaluation of WEBSERVICE no longer requires external client, but will use oldCalculatedValue unless the request is for a domain in a user-supplied whitelist. Security-related backport of PR #4751

Deprecated

  • Settings methods setHttpClient, unsetHttpClient, getHttpClient, and getRequestFactory are no longer used. No replacement.

Fixed

  • Changes to WEBSERVICE. Backport of PR #4751
5.3.0

Added

  • Formal support for Php8.5.
  • Limited Printarea support for Html/Pdf. Issue #3941 PR #4711
  • Implement missing INFO function. PR #4709
  • Implement missing BAHTTEXT function. PR #4715

Deprecated

  • $dataType, the second parameter of Cell::setValueExplicit, is currently optional. Omitting it is deprecated, and it will be required in a future release.

Fixed

3.10.2

Added

  • Formal support for Php8.5.

Fixed

2.4.2

Added

  • Formal support for Php8.5. This is the last version of Php which can be used with this branch.

Fixed

  • Php8.5 deprecates use of null as array index. PR #4635
5.2.0

Added

  • This release should be usable with Php8.5 Release Candidates without deprecation messages.
  • Option to display numbers with less precision. Issue #4626 PR #4640
  • Offer Tcpdf Interface which throws exception rather than die. PR #4666
  • Xls Reader ListWorksheetDimensions method. PR #4689

Deprecated

  • Worksheet::getHashInt serves no useful purpose. No replacement.
  • Spreadsheet::getId serves no useful purpose. No replacement.

Fixed

2.1.13

Functionally Frozen

  • Except for security changes, no further maintenance will be applied to this branch. You are encouraged to upgrade to a maintained branch as soon as possible. Maintained branches are master (preferred - version is 5.2.0 as of the date when this is being written), release390 (current version is 3.10.1), and release222 (2.4.1).
  • Of particular note is that this branch should not run under Php 8.5+, and will not be updated to avoid deprecation notices introduced with Php 8.5.
1.30.1

Functionally Frozen

  • Except for security changes, no further maintenance will be applied to this branch. You are encouraged to upgrade to a maintained branch as soon as possible. Maintained branches are master (preferred - version is 5.2.0 as of the date when this is being written), release390 (current version is 3.10.1), and release222 (2.4.1).
  • Of particular note is that this branch should not run under Php 8.5+, and will not be updated to avoid deprecation notices introduced with Php 8.5.
5.1.0

Added

Fixed

3.10.1

Added

  • Option for Readers to create a new blank sheet if none match LoadSheetsOnly list. PR #4623 Backport of PR #4618.
  • Remove imagedestroy from MemoryDrawing. Backport of PR #4625.

Fixed

2.4.1

Added

  • Option for Readers to create a new blank sheet if none match LoadSheetsOnly list. PR #4622 Backport of PR #4618.
  • Remove imagedestroy from MemoryDrawing. Backport of PR #4625.

Fixed

5.0.0

Breaking Changes

  • Images will be loaded from an external source (e.g. http://example.com/img.png) only if the reader is explicitly set to allow it via $reader->setAllowExternalImages(true). We do not believe that loading of external images is a widely used feature.
  • Deletion of items deprecated in Release 4. See "removed" below.
  • Move some properties from Base Reader to Html Reader. PR #4551
  • DefaultValueBinder will treat integers with more than 15 digits as strings. Issue #4522 PR #4527

Removed

  • Theme public constants COLOR_SCHEME_2013_PLUS_NAME (use COLOR_SCHEME_2013_2022_NAME) and COLOR_SCHEME_2013_PLUS (use COLOR_SCHEME_2013_2022).

Fixed

3.10.0

Breaking Changes

  • Images will be loaded from an external source (e.g. http://example.com/img.png) only if the reader is explicitly set to allow it via $reader->setAllowExternalImages(true). We do not believe that loading of external images is a widely used feature. This is a necessary change for security purposes. It unfortunately breaks Semantic Versioning for reasons described above; there is no way to start a new major version for this branch.
2.4.0

Breaking Changes

  • Images will be loaded from an external source (e.g. http://example.com/img.png) only if the reader is explicitly set to allow it via $reader->setAllowExternalImages(true). We do not believe that loading of external images is a widely used feature. This is a necessary change for security purposes. It unfortunately breaks Semantic Versioning for reasons described above; there is no way to start a new major version for this branch.
2.1.12

Breaking Changes

  • Images will be loaded from an external source (e.g. http://example.com/img.png) only if the reader is explicitly set to allow it via $reader->setAllowExternalImages(true). We do not believe that loading of external images is a widely used feature. This is a necessary change for security purposes. It unfortunately breaks Semantic Versioning for reasons described above; there is no way to start a new major version for this branch.
1.30.0

Breaking Changes

  • Images will be loaded from an external source (e.g. http://example.com/img.png) only if the reader is explicitly set to allow it via $reader->setAllowExternalImages(true). We do not believe that loading of external images is a widely used feature. This is a necessary change for security purposes. It unfortunately breaks Semantic Versioning for reasons described above; there is no way to start a new major version for this branch.
4.5.0

Added

  • Add to all readers the option to allow or forbid fetching external images. This is unconditionally allowed now. The default will be set to "allow", so no code changes are necessary. However, we are giving consideration to changing the default. PR #4543
  • Address Excel Inappropriate Number Format Substitution. PR #4532

Fixed

3.9.3

Added

  • Add to all readers the option to allow or forbid fetching external images. This is unconditionally allowed now. The default will be set to "allow", so no code changes are necessary. However, we are giving consideration to changing the default. PR #4548
2.3.10

Added

  • Add to all readers the option to allow or forbid fetching external images. This is unconditionally allowed now. The default will be set to "allow", so no code changes are necessary. However, we are giving consideration to changing the default. PR #4547
2.1.11

Added

  • Add to all readers the option to allow or forbid fetching external images. This is unconditionally allowed now. The default will be set to "allow", so no code changes are necessary. However, we are giving consideration to changing the default. PR #4546
1.29.12

Added

  • Add to all readers the option to allow or forbid fetching external images. This is unconditionally allowed now. The default will be set to "allow", so no code changes are necessary. However, we are giving consideration to changing the default.PR #4545
4.4.0

Added

Deprecated

  • Theme constants COLOR_SCHEME_2013_PLUS_NAME (use COLOR_SCHEME_2013_2022_NAME) and COLOR_SCHEME_2013_PLUS (use COLOR_SCHEME_2013_2022).

Fixed

3.9.2

Changed

  • Allow php-cs-fixer to Handle Implicit Backslashes.

Added

  • Allow spreadsheet to be serialized. PR #4408

Fixed

2.3.9

Changed

  • Allow php-cs-fixer to Handle Implicit Backslashes.

Added

  • Allow spreadsheet to be serialized. PR #4407

Fixed

2.1.10

Changed

  • Allow php-cs-fixer to Handle Implicit Backslashes.

Added

  • Allow spreadsheet to be serialized. PR #4406

Fixed

1.29.11

Changed

  • Allow php-cs-fixer to Handle Implicit Backslashes.

Added

  • Allow spreadsheet to be serialized. PR #4405

Fixed

Weaver

How can I help you explore Laravel packages today?

Conversation history is not saved when not logged in.
Prompt
Add packages to context
No packages found.
socialdept/atp-orm
cboxdk/laravel-assistant-client
socialdept/atp-resolver
socialdept/tenant-domains
tautvydasr/blade-class-names
socialdept/color-scales
maherelgamil/controller
coleus/widgets
coleus/table
coleus/users
coleus/music
coleus/health
coleus/calendar
coleus/notes
coleus/support
coleus/settings
coleus/apps
seampact/laravel
emmyconceptng/laravel-ng-postcode
jjsquady/round-robin