Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

xlsx to csv ssconvert

by perlUser345 (Acolyte)
on Jun 22, 2016 at 16:37 UTC ( [id://1166279]=perlquestion: print w/replies, xml ) Need Help??

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
      Thank you!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1166279]
Approved by Mr. Muskrat
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (7)
As of 2024-04-19 16:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found