Re: Spreadsheet::Read Open File from Variable?

[huck]

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");

[CJ2012SXT]

Well spotted. I added the path info for Spreadsheet::Read and it is working perfectly now. Thanks!