GHSA-r8w8-74ww-j4wh
PhpSpreadsheet HTML writer is vulnerable to Cross-Site Scripting via JavaScript hyperlinks
Quick fix
GHSA-r8w8-74ww-j4wh — phpoffice/phpspreadsheet: upgrade to the fixed version with the command below.
composer require phpoffice/phpspreadsheet:^2.3.0Details
### Summary `\PhpOffice\PhpSpreadsheet\Writer\Html` does not sanitize "javascript:" URLs from hyperlink `href` attributes, resulting in a Cross-Site Scripting vulnerability.
### PoC
Example target script:
``` <?php
require 'vendor/autoload.php';
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader("Xlsx"); $spreadsheet = $reader->load(__DIR__ . '/book.xlsx');
$writer = new \PhpOffice\PhpSpreadsheet\Writer\Html($spreadsheet); print($writer->generateHTMLAll()); ```
Save this file in the same directory: [book.xlsx](https://github.com/PHPOffice/PhpSpreadsheet/files/15099763/book.xlsx)
Open index.php in a web browser and click on both links. The first demonstrates the vulnerability in a regular hyperlink and the second in a HYPERLINK() formula.
Are you affected?
Enter the version of the package you're using.
Affected packages
2.2.0Fixed in: 2.3.0composer require phpoffice/phpspreadsheet:^2.3.00Fixed in: 1.29.2composer require phpoffice/phpspreadsheet:^1.29.22.0.0Fixed in: 2.1.1composer require phpoffice/phpspreadsheet:^2.1.10No fixed version published yet for phpoffice/phpexcel (composer). Pin to a known-safe version or switch to an alternative.
References
- https://github.com/PHPOffice/PhpSpreadsheet/security/advisories/GHSA-r8w8-74ww-j4wh[WEB]
- https://nvd.nist.gov/vuln/detail/CVE-2024-45292[ADVISORY]
- https://github.com/PHPOffice/PhpSpreadsheet/commit/392dd08c5569b623060784e1333454d64df1f03d[WEB]
- https://github.com/PHPOffice/PhpSpreadsheet/commit/8b9b378ecdc603234a34aab3b293d2cdc8e9210e[WEB]
- https://github.com/PHPOffice/PhpSpreadsheet/commit/f0b70ed1086348904b27772b264e1605ba6c1d6d[WEB]
- https://github.com/PHPOffice/PhpSpreadsheet[PACKAGE]