spiral has asked for the wisdom of the Perl Monks concerning the following question:

Because of group policy I cannot install anything that needs a dll. I need to parse an xlsx file, but

use Spreadsheet::ParseXLSX;

results in

Can't locate Crypt/Mode/CBC.pm in @INC (you may need to install the Crypt::Mode::CBC module)

Is there a way to do without this module and still be able to parse the xlsx file?

Replies are listed 'Best First'.
Re: Parser XLSX without Crypt
by ysth (Canon) on Jul 15, 2025 at 15:16 UTC
    I think it only truly needs that for password protected files. You'd have to try it out to see.

    Make a directory like 'missing_modules' somewhere and in your code do use lib 'path_to_it/missing_modules' before use Spreadsheet::ParseXLSX, and in that directory make a Crypt/Mode/CBC.pm that just contains 1. Then run your code and see what other modules you might need to pretend exist, and see if it dies trying to call any nonexisting subs or methods.
      Great . It only needed to add EBC.pm to that directory and it worked! Thanks!