Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re^6: Create CSV file from xlsx file

by Tux (Abbot)
on Oct 24, 2013 at 14:34 UTC ( #1059483=note: print w/replies, xml ) Need Help??

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

FYI I uploaded Spreadsheet::Read version 0.50 today which adds the command xlsgrep and supports column names like -C D,F-H,Y,AH. I just checked MetaCPAN, which already shows this new release.

The documentation includes a new TOOLS section.

I'm always open to improvement suggestions.

Enjoy, Have FUN! H.Merijn

Replies are listed 'Best First'.
Re^7: Create CSV file from xlsx file
by viji234 (Initiate) on Oct 25, 2013 at 06:00 UTC
    thank you .. Again i installed Spreadsheet::Read as mentioned by you and mart. when i ran the command its giving the same error.
    error: 'xlscat' is not recognized as an internal or external command,operable + program or batch file.
    xlscat -S 1 -C 9-11,21 -c sample.xlsx >file1.csv

      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

      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

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

        FWIW -S has to come before scriptname :)

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1059483]
[Happy-the-monk]: Discipulus: why are you looking for a Danish monk?
[1nickt]: choroba really you did not like it hm?
[choroba]: no, just trying to judge a book in the same way

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (10)
As of 2017-11-17 21:32 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (272 votes). Check out past polls.