in reply to Opening bad Excel files

Code from synopsis section of Spreadsheet::ParseXLSX (which itself further refers to Spreadsheet::ParseExcel) works OK with your file.

As to Spreadsheet::XLSX, there's strong opinion about it here:

Spreadsheet::XLSX

This module is dead and deprecated. It is buggy and unmaintained. Please use Spreadsheet::ParseXLSX instead.