News

phpxlsx v4 release notes

  • Oct 15, 2024

It is with great pleasure that we announce phpxlsx, the new major version of the library. We have filled it with a bunch of new features, designed to help you make the most amazing, dynamic spreadsheets.

Go to the Pricing section of the library website to get phpxlsx 4. Users with a previous version can upgrade by going to MY PHPXLSX and clicking on “Upgrade to”. Users with a valid License Update Service (LUS) may get the new version at no cost.

Users who enjoy phpxlsx may be interested in phpdocx Bureau and get three Premium licenses to generate DOCX, XLSX and PPTX (phpdocx, phpxlsx, phppptx) for a very special price.

The complete list of phpxlsx features is the following:

  • MS Excel 2024 support.
  • PHP 8.4 support.
  • WebP image format supported.
  • New removeCell method to remove cells.
  • HTML to DOCX:
    • CSS variables.
    • Supported root and only-child selectors.
    • Improved CSS media query handling.
    • CSS 8-digit HEX colors are added as 6-digit HEX colors.
  • New removeVariableImage method to remove image placeholders.
  • Handle XLSX, XLSM, XLTX and XLTM extensions automatically.
  • Supported ofPie as chart type in addChart.
  • replaceVariableImage includes colOffset, colSize, rowOffset and rowSize options to set custom sizes, and descr and alt options.
  • Theme charts supports applying custom colors to lines (Premium licenses).
  • Encrypt XLSX supports files bigger than 6.5MB (Premium licenses).
  • GdImage objects supported when adding images.
  • Included a sample_composer.json file in the plugins folder of the namespaces package (Advanced and Premium licenses).
  • Added removeCalcChain as option in save methods to remove calcChain files from the XLSX.
  • The addCell method cleans calcChain values of the chosen position automatically.
  • PHP GD Extension is checked in phpdocx-cli and check scripts.
  • New enableHugeXmlMode static function in XmlUtilities to parse huge XML contents enabling the XML_PARSE_HUGE flag (LIBXML_PARSEHUGE predefined constant).