Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

Re: excelPerl V0.12 released

by lupey (Monk)
on Oct 23, 2007 at 18:28 UTC ( #646735=note: print w/replies, xml ) Need Help??

in reply to excelPerl V0.12 released
in thread excelPerl V0.08


I created a simple xls document with "Hello" in A1 and "World" in B1. I used the following command line that you sent me in a previous post

perl -begin "use Text::CSV_XS; $csv = Text::CSV_XS->new( +{ binary => 1 } )" -ane "$csv->combine(@F); print $csv->string, $/" - +f helloworld.xls > helloworld.csv
But all I got was an output file with CRLF. I'm working with Active State Perl 5.8.8 on WinXP and Text::CSV_XS version 0.3.

Any ideas?

Replies are listed 'Best First'.
Re^2: excelPerl V0.12 released
by strat (Canon) on Oct 24, 2007 at 09:38 UTC

    Any error messages?

    Best regards,
    perl -e "s>>*F>e=>y)\*martinF)stronat)=>print,print v8."

      I don't get any error message with Active State Perl. But when I execute the same command line on cygwin (and commenting out the use Win32; line), I get the following error:

      Error in begin: syntax error at (eval 4) line 2, near "; ="

      Could the same error be happening on Active State but is not outputted to command prompt?


        Please try V0.13; there it should work.

        Best regards,
        perl -e "s>>*F>e=>y)\*martinF)stronat)=>print,print v8."

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://646735]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (5)
As of 2016-10-23 11:03 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (301 votes). Check out past polls.