Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re^2: Can't Find my way in Excel

by ExReg (Priest)
on Sep 17, 2019 at 17:20 UTC ( #11106306=note: print w/replies, xml ) Need Help??

in reply to Re: Can't Find my way in Excel
in thread Can't Find my way in Excel

I have tried that. It errors with "Undefined subroutine &main...". $Sheets, $Sheets->UsedRange, and $Sheets->UsedRange->Cells all return Win32 hashes, but I can't get that last step with Find.

Replies are listed 'Best First'.
Re^3: Can't Find my way in Excel
by Corion (Pope) on Sep 17, 2019 at 17:23 UTC

    Please tell us the exact and complete error message. Otherwise, we can't know what exactly goes wrong with your script.

      Sorry, "Undefined subroutine &main:: called at (eval 14)D:/software/Perl/lib/ line 2, <$lh> line 7." This is the error I see in perl's debugger as I try each variation. If I try just running it without debug, I get "Can't use string ("") as a subroutine while "strict refs" in use at line 100, <$lh> line 7." That is true if the curlies are around the whole expression inside the parens or not. Without "use strict" I get the Undefined subroutine error.

        Can't use string ("") as a subroutine while "strict refs" in use at se line 100

        The example code you show doesn't have 100 lines.

        Please reduce the code you run until it has below 20 lines. Then post that reduced code together with the error message that corresponds to the reduced code.

        It's hard for us to interpret an error message for code we're not seeing.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11106306]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (3)
As of 2021-10-26 17:44 GMT
Find Nodes?
    Voting Booth?
    My first memorable Perl project was:

    Results (90 votes). Check out past polls.