Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re^9: Create CSV file from xlsx file

by Anonymous Monk
on Oct 25, 2013 at 07:15 UTC ( [id://1059601]=note: print w/replies, xml ) Need Help??


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

FWIW -S has to come before scriptname :)

Replies are listed 'Best First'.
Re^10: Create CSV file from xlsx file
by marto (Cardinal) on Oct 25, 2013 at 07:55 UTC

    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]

        :) Hopefully a sensible response to these questions will allow me to fix that for them.

[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://1059601]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2024-04-24 08:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found