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

The doc for Spreadsheet::Read says "For Microsoft Excel this module uses Spreadsheet::ParseExcel". I would install that module.
  • Comment on Re^3: Failing with ReadData from Spreadsheet::Read and need to find a way to debug

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

      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).

      > 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

      👁️🍾👍🦟
      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.