http://www.perlmonks.org?node_id=997775

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

Hi, I am new to perl. I wish to convert XLSX to CSV format. When i try using the below perl script, i am getting error like, Please someone help me to resolve the issue. (Note: I installed perl module SpreadSheet::XLSX).

perl -MSpreadsheet::XLSX -e ' $\ = "\n"; $, = ";"; my $workbook = Spreadsheet::XLSX->new()->parse($ARGV[0]); my $worksheet = ($workbook->worksheets())[0]; my ($row_min, $row_max) = $worksheet->row_range(); my ($col_min, $col_max) = $worksheet->col_range(); for my $row ($row_min..$row_max) { print map {$worksheet->get_cell($row,$ +_)->value()} ($col_min..$col_max); } ' orangecart.xlsx >filename.csv
Can't locate OLE/Storage_Lite.pm in @INC (@INC contains: /opt/perl_32/ +lib/5.8.8/PA-RISC1.1-thread-multi /opt/perl_32/lib/5.8.8 /opt/ perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi /opt/perl_32/lib/s +ite_perl/5.8.8 /opt/perl_32/lib/site_perl /opt/perl_32/lib/ven dor_perl/5.8.8/PA-RISC1.1-thread-multi /opt/perl_32/lib/vendor_perl/5. +8.8 /opt/perl_32/lib/vendor_perl .) at /opt/perl_32/lib/site_p erl/5.8.8/Spreadsheet/ParseExcel.pm line 18. BEGIN failed--compilation aborted at /opt/perl_32/lib/site_perl/5.8.8/ +Spreadsheet/ParseExcel.pm line 18. Compilation failed in require at /opt/perl_32/lib/site_perl/5.8.8/Spre +adsheet/XLSX.pm line 14. BEGIN failed--compilation aborted at /opt/perl_32/lib/site_perl/5.8.8/ +Spreadsheet/XLSX.pm line 14. Compilation failed in require. BEGIN failed--compilation aborted.