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 formats like Excel and LibreOffice Calc. Create, edit, and export workbooks (XLSX, XLS, ODS, CSV, etc.) with a rich API for cells, formulas, styles, and more.

View on GitHub
Deep Wiki
Context7
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.
hexters/coinpayment
rjcodes/rjcms
act-training/laravel-permissions-manager
alimarchal/laravel-chart-of-accounts
babenkoivan/elastic-scout-driver
mkwebdesign/filament-watchdog-v5
renatomarinho/laravel-page-speed
zedmagdy/filament-business-hours
renatovdemoura/blade-elements-ui
devgeek/beacon-admin
benjamin-rqt/data-watcher-bundle
atriumphp/atrium
sandermuller/package-boost-laravel
sandermuller/boost-skills
redaxo/core
yusufgenc/filament-api-forge
l3aro/rating-star-for-filament
leek/filament-subtenant-scope
anil/file-picker
broqit/fields-ai