in reply to Re^7: Create CSV file from xlsx file
in thread Create CSV file from xlsx file

If you installed the module and answered yes to installing these tools then something is wrong with your setup. Perhaps your path is wrong in that it's missing. I'll come back to this. These tools are perl scripts, you can download them and run them as you would any other perl script. Save this link as xlscat, given that I suspect that your setup may be messed up run the commands in the same location as you saved the file above:

perl xlscat -S 1 -C 9-11,21  -c sample.xlsx >file1.csv

[download]

Which version of Perl do you have installed? The output of the following would be helpful in further diagnosing the issue above:

c:\path

c:\perl -V

[download]

If you paste the output of these commands into a reply here (remember the code tags please) we can work towards resolving the problem.

Replies are listed 'Best First'.
Re^9: Create CSV file from xlsx file
by Anonymous Monk on Oct 25, 2013 at 07:15 UTC
    FWIW -S has to come before scriptname :)
[reply]

      Works for me with a text spreadsheet, 1 row, 22 cols:

      D:\>perl xlscat.pl -S 1 -C 9-11,21 -c sample.xlsx >file1.csv

D:\>type file1.csv
9,10,11,21

      [download]
[reply]
[d/l]
        Awww, got tricked, I thought perl -S xslcat .... cause his xslcat.bat wasn't in path :)
[reply]
[d/l]

In Section Seekers of Perl Wisdom