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

[download]
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.8.8.32.11.32"

[reply]

      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 ";  ="

      [download]

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

      lupey

[reply]
[d/l]
[select]

        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"

[reply]

In Section Cool Uses for Perl