Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

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

Strat,

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 excelPerl.pl -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?


Comment on Re: excelPerl V0.12 released
Download Code
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.8.8.32.11.32"

      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?

      lupey

        Please try V0.13; there it should work.

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

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (9)
As of 2014-12-27 13:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (177 votes), past polls