in reply to Spreadsheet::Read Open File from Variable?

When you were running this im willing to bet your current working directory was not c:/scripts/modular_collector/collections. Did you notice that the filename said "22948850_Config_(10.5).xlsx". Spreadsheet::Read->new tried to read this file from the current directory because it had no path info.

$book = Spreadsheet::Read->new("c:/scripts/modular_collector/collectio +ns/".$_, parser => "xlsx");

Replies are listed 'Best First'.
Re^2: Spreadsheet::Read Open File from Variable?
by CJ2012SXT (Novice) on Aug 22, 2017 at 08:17 UTC
    Well spotted. I added the path info for Spreadsheet::Read and it is working perfectly now. Thanks!