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

Replies are listed 'Best First'.
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]