in reply to Failing with ReadData from Spreadsheet::Read and need to find a way to debug

Yes, the error from ReadData should hold some clues.

I've had a case where certain strings were confusing an excel parser, so also check if this works with a super simple spreadsheet.
(Something with just a single word in a single cell to start.)

Luck!
  • Comment on Re: Failing with ReadData from Spreadsheet::Read and need to find a way to debug
  • Download Code

Replies are listed 'Best First'.
Re^2: Failing with ReadData from Spreadsheet::Read and need to find a way to debug
by SergioQ (Scribe) on Jun 19, 2024 at 02:43 UTC

    This reply is for all replies to my OP:

    This is sort of my fault, in that I program on the other side of linux machines, so I only have a basic knowledge of perl, and even though I've used $@ before, that thinking doesn't come automatically for that.

    So now that you all reminded me of $@, the error makes sense, "No parser for XLSX found."

    Am trying hard to install all the parsers, with CPAN. but I keep getting errors that I am missing a prerequisite, and eventually I get bad tests when installing modules from CPAN.

    i.e.
    Test Summary Report ------------------- t/prng_rc4.t (Wstat: 132 Tests: 0 Failed: 0) Non-zero wait status: 132 Parse errors: Bad plan. You planned 19 tests but ran 0. Files=137, Tests=18549, 49 wallclock secs ( 4.46 usr 0.76 sys + 36.90 cusr 3.93 csys = 46.05 CPU) Result: FAIL Failed 1/137 test programs. 0/18549 subtests failed. make: *** Makefile:1780: test_dynamic Error 255 MIK/CryptX-0.080.tar.gz make test -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports MIK/CryptX-0.080.tar.gz

    I'm guessing this is a question for another forum, like Stack Overflow, but isn't there a simple way to instal a perl module, and any dependents it requires?

    Thanks for the original replies, at least I have a clue now

[reply]
      I'm guessing this is a question for another forum, like Stack Overflow

      Why? Because we here at Perlmonks led you to look at the error in $@, and now we're not qualified enough? Please note that the most intelligent Perl Hackers are found here on Perlmonks ;)

      but isn't there a simple way to instal a perl module, and any dependents it requires?

      Yes, there is. My fellow Monks have shared their thoughts on that. (Hint cpanm).

[reply]
[d/l]
[select]
        Why? Because we here at Perlmonks led you to look at the error in $@, and now we're not qualified enough?

        Wouldn't want to post off-topic unknowingly

        Yes, there is. My fellow Monks have shared their thoughts on that. (Hint cpanm)

        I could have sworn I had the same issue with cpanm. But as I was posting this, and fighting trying to get all the parser files installed, obviously my err. That's my inexperience showing its colors.

[reply]
      The doc for Spreadsheet::Read says "For Microsoft Excel this module uses Spreadsheet::ParseExcel". I would install that module.
[reply]

        Everytime I try to install one module, I get "missing prerequisite module" errors.

        As I keep going up the error tree I get more and more error. it's like a recursive loop with no end in site.

[reply]

In Section Seekers of Perl Wisdom