Re^2: Failing with ReadData from Spreadsheet::Read and need to find a way to debug

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

Comment on Re^2: Failing with ReadData from Spreadsheet::Read and need to find a way to debug

Replies are listed 'Best First'.
Re^3: Failing with ReadData from Spreadsheet::Read and need to find a way to debug by stevieb (Canon) on Jun 19, 2024 at 09:08 UTC
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]
Re^4: Failing with ReadData from Spreadsheet::Read and need to find a way to debug by SergioQ (Scribe) on Jun 19, 2024 at 22:22 UTC
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]
Re^3: Failing with ReadData from Spreadsheet::Read and need to find a way to debug by Marshall (Canon) on Jun 19, 2024 at 02:52 UTC
The doc for Spreadsheet::Read says "For Microsoft Excel this module uses Spreadsheet::ParseExcel". I would install that module.	[reply]
Re^4: Failing with ReadData from Spreadsheet::Read and need to find a way to debug by SergioQ (Scribe) on Jun 19, 2024 at 03:07 UTC
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]
Re^5: Failing with ReadData from Spreadsheet::Read and need to find a way to debug by swl (Prior) on Jun 19, 2024 at 04:55 UTC
Are you installing modules using something like App::Cpan, cpanm or cpm? Those will resolve and install the dependencies for you (with options to skip or override testing where appropriate).	[reply]
Re^5: Failing with ReadData from Spreadsheet::Read and need to find a way to debug by eyepopslikeamosquito (Archbishop) on Jun 19, 2024 at 09:20 UTC
> Every time I try to install one module, I get "missing prerequisite module" errors. What platform are you running Perl on? Further to swl's and stevieb's excellent replies recommending `cpanm`, you can see a detailed example of building `perl` securely from scratch on Linux using the App::cpanminus `cpanm` command here; the excerpt below should give you a feel for how this works in practice (note the `==> Found dependencies` line below): $ cpanm --from https://www.cpan.org/ Module::Signature --> Working on Module::Signature Fetching https://www.cpan.org/authors/id/A/AU/AUDREYT/Module-Signature +-0.88.tar.gz ... OK Configuring Module-Signature-0.87 ... OK ==> Found dependencies: IPC::Run --> Working on IPC::Run Fetching https://www.cpan.org/authors/id/T/TO/TODDR/IPC-Run-20220807.0 +.tar.gz ... OK Configuring IPC-Run-20220807.0 ... OK Building and testing IPC-Run-20220807.0 ... OK Successfully installed IPC-Run-20220807.0 Building and testing Module-Signature-0.87 ... OK Successfully installed Module-Signature-0.87 2 distributions installed [download] 👁️🍾👍🦟	[reply] [d/l] [select]
Re^5: Failing with ReadData from Spreadsheet::Read and need to find a way to debug by Danny (Chaplain) on Jun 19, 2024 at 19:21 UTC
For what it's worth I just installed Spreadsheet::Read and Spreadsheet::ParseXLSX using cpanm on a windows/cygwin system. For me it tried to install the following additional dependency modules: Test::NoWarnings Crypt::Mode::ECB, Spreadsheet::ParseExcel::Cell, Archive::Zip, OLE::Storage_Lite, Spreadsheet::ParseExcel, Spreadsheet::ParseExcel::Utility, Crypt::Mode::CBC, Spreadsheet::ParseExcel::Worksheet, Graphics::ColorUtils `cpanm Spreadsheet::ParseXLSX` failed to install Archive-Zip because t/27_symlinks.t failed. However, I was able to install Archive-Zip from the cygwin distribution. A simple script to convert excel to tab delimited seemed to work.	[reply] [d/l]