News

We are glad to announce the release of phpxlsx 5.

This release comes with powerful new features to help you create stunning, fully customized spreadsheets faster and easier than ever. Save time, reduce effort, and supercharge your workflow.

Just go to Pricing to get the license that best suits your project requirements.

Users with a valid License Update Service (LUS) may get this new version at no cost, by going to MY PHPXLSX and selecting the licence(s) they want to update.

Users with previous versions can also upgrade to the new one in the same place.

Also, we encourage you to get LUS, if you don't already have it, in order to get the next releases for free, plus other benefits, for a whole year.

The latest version of phpdocx Bureau version includes phpxlsx 5.

The complete list features of phpxlsx 5 is the following:

• HTML Extended and CSS Extended (Premium licenses):
  • Call phpxlsx methods from custom HTML tags.
  • Apply phpxlsx styles from custom CSS.
• JavaScript API (Premium licenses):
  • Work with XLSX spreadsheets using nodejs and web browsers.
  • Included bundles: CommonJS (cjs), ESM (mjs) and IIFE (iife.js).
  • TypeScript type information.
  • Available features:
    • Contents: breaks, cells, functions, images, links, sheets.
    • Styles: texts.
    • Layouts: active sheet, cell positions, RTL.
    • Settings: properties, column, row, sheet, workbook.
    • Templates: get template variables, remove variable, image, remove variable text, replace variable image, replace variable text, set template symbols.
    • Handle transitional and strict XLSX variants.
    • Extra utilities: convert units (emu, half-point, pt, px, twip).
    • MS Excel default styles.
• XlsxPath (Premium licenses):
  • Move elements.
  • Get elements: sheet, workbook.
  • Remove elements: sheet.
• Merge cells (Advanced and Premium licenses).
• PHP 8.5 support.
• Indexer (Advanced and Premium licenses):
  • Merge cells.
• New preprocessed option in CreateXlsxFromTemplate and setTemplateSymbol.
• Conversion plugin based on LibreOffice (Advanced and Premium licenses):
  • XLSX to CSV.
  • XLS to CSV.
  • ODS to CSV.
  • conversionExtraOptions option.
• New empty type in addCell to add empty cells.
• New styles in addSheet and setSheetSettings: defaultColWidth, defaultRowHeight.
• HTML to XLSX:
  • Improved adding alpha color styles.
  • Supported #rgba format to apply colors.
• Added BASE function as xlfn.
• Supported autodetection of MS Excel 2024 functions when adding functions.
• Improved working with legacy drawing contents.
• Removed PHP Warnings when images to be added do not exist.
• Extra check in addBreak to handle valid col and row tag orders, even if some are missing.
• Extra check when applying a color with setSheetSettings to avoid duplicated color tags.