Weave Code
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 to read and write spreadsheet files (Excel, LibreOffice Calc, and more). Create, modify, and export workbooks with rich formatting, formulas, and multiple formats via a well-documented API.

View on GitHub
Deep Wiki
Context7
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.
nexmo/api-specification
capell-app/block-library
axium/identity
cetria/laravel-dummy-models
cetria/reflection-helper
agropredict/sso-auth-bundle
evolvestudio/spam-protection
datacore/hub-sdk
develia/commons
cuci/prototurk-sdk
cuci/prototurk-sdk-symfony
develia/geo-bundle
dreamzy/livewire-charts
touchestate-sdk/php-sdk
ecotone/kafka
22h/doctrine-garbage-collection-bundle
agtp/agtp-php
agtp/mod-php
splash/sonata-admin
splash/metadata