Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: What is the best module for parsing Excel documents

by strat (Canon)
on Oct 22, 2007 at 08:50 UTC ( #646383=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

  1. or download this
    perl -begin "use Text::CSV_XS; $csv = Text::CSV_XS->new( 
    +{ binary => 1 } )" -ane "$csv->combine(@F); print $csv->string, $/" -
    +f test.xls > outfile.csv
  2. or download this
    perl -begin "use Text::CSV_XS; $csv = Text::CSV_XS->new( 
    +{ binary => 1 } )" -ane "$csv->combine( map { $_->{FormulaLocal} } @C
    +); print $csv->string, $/" -f test.xls > outfile.csv

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://646383]
[karlgoethebier]: shmem: yes. my first ride tomorrow is questionable because of lumbago. shit
[shmem]: But! the bloke wasn't me, at least.
[shmem]: karlgoethebier: isn't bike riding a way of fixing lumbago?
[karlgoethebier]: shmem: scheiss technik
[karlgoethebier]: shmem: yes - i f you manage it to get on the bike. and pray if you must stop...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (9)
As of 2017-06-25 20:03 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (570 votes). Check out past polls.