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

Hey monks!
I'm trying to convert an xlsx file to csv. So far I've been able to use ssconvert just fine, however I'm having some problems with one particular xlsx file. This file has a drop down menu for a few entries and ssconvert gives a segmentation fault.
I cannot use Spreadsheet::ParseExcel because I can't install anything on my machine (not admin). I tried the python xlsx2csv.py with no luck.
Any idea on how to make this work with ssconvert?
Thanks!

Replies are listed 'Best First'.
Re: xlsx to csv ssconvert
by Tux (Canon) on Jun 22, 2016 at 17:19 UTC

    Not being an admin is not reason not to be able to use useful modules. Looking arounf here (use search) will popup a wealth of links describing how even you can use the wonders of CPAN without being a superuser.

    For parsing xlsx, you will need Spreadsheet::ParseXLSX and not Spreadsheet::ParseExcel. The API is much alike.

    The ssconvert program is so outdated, it doesn't know about xlsx. I could not find a version available for OpenSUSE to test with (and I'm not going to dig for sources and build from scratch).

    For dumping xls, xlsx, ods, and csv to CSV, I'd suggest installing Spreadhseet::Read, which supports all underlying parsers and comes with the xls2csv script, which has a lot of options.


    Enjoy, Have FUN! H.Merijn
[reply]
      Thank you!
[reply]

Back to Seekers of Perl Wisdom