Re: Spreadsheet::Read Open File from Variable?

[soonix]

In addition to what huck said, you should replace the line

print $_ . "\n";

by

print ">>$_<<\n";

just in case the 22948850_Config_(10.5).xlsx in c:/scripts/modular_collector/collections has some invisible character in its name, different from the "same" file in the current directory…

Update: "line 59" seems to be way after the call to Spreadsheet::Read->new, also note that the error message talks about method "read" (lower case "r"). Perhaps you copied an old version of that file into your development directory?

[CJ2012SXT]

Line 59 is the correct line number where it calls Spreadsheet::Read->new. I'm on Win32 and do all of my scripting in Notepad++.

[soonix]

But line 59 of the code you posted is

        $cell = "C" . $rowCnt;

Any difference between the code you use and the code you post(ed) may impede our ability to help. Problems with copy+paste do exist, yes, but usually they are smaller than those that stem from manually typing and thereby changing the code.

[CJ2012SXT]

I'll keep that in mind. I copy pasted the code right out of Notepad++.