News

We are glad to announce that phpxlsx has reached a new version. The latest release includes a set of powerful new methods and characteristics, which are detailed below.

Get phpxlsx 4.5 in the Pricing section of its website. The library is offered in three different licenses, so you can get the one that best suits your project needs.

Users with a valid License Update Service (LUS) may download this version for free. Just go to the MY PHPXLSX section of its web and choose the license you want to update. Users with previous versions of the library can upgrade to the new one the same way.

Users without LUS are encouraged to get it, as it grants free updates plus other benefits for a whole year.

The complete list of phpxlsx 4.5 features is the following:

• XlsxPath (Advanced and Premium licenses):
  • Get elements.
  • Remove elements.
• New getTemplateVariablesType method to return template variables and their types (Advanced and Premium licenses).
• Indexer (Advanced and Premium licenses):
  • Supported XLSM, XLTX and XLST files.
  • Styles: fonts, fills, borders.
• Supported XLTX and XLSM files as templates.
• getCell returns cell styles.
• Theme charts:
  • Set custom title layout.
  • Apply font styles to series and values labels (Premium licenses).
  • New valueDataLabels option to customize labels by position (Premium licenses).
• Conversion plugin based on LibreOffice (Advanced and Premium licenses):
  • Added "--norestore" to all conversions.
  • New documentation in the macros-libreoffice folder to enable and use lossless compression without adding a macro.
  • New path option in transform to set the path to libreoffice.
  • New escapeshellarg option.
• split allows setting a custom path for the target documents distinct than the script folder (Advanced and Premium licenses).
• Improved applying cell styles to cell contents with addTable.
• Removed ~E_STRICT from the default logger error levels when using PHP 8.0 or newer.
• Corrections in the internal phpdoc documentation.