Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Parsing CSV table

by Tux (Canon)
on Sep 06, 2010 at 13:31 UTC ( [id://859054]=note: print w/replies, xml ) Need Help??


in reply to Parsing CSV table

That message indicates that you are using a very old Spreadsheet::Read, as ReadData () accepts (multiple) options since at least 2007 (that is how far my git repo goes back).

$ cat test.csv foo;bar;dog 1;2;Bull $ perl -MData::Peek -MSpreadsheet::Read -wle'my $ref = ReadData ("test +.csv", sep => ";",quote => q{"});DDumper $ref' [ { parser => 'Text::CSV_XS', quote => '"', sepchar => ';', sheet => { 'test.csv' => 1 }, sheets => 1, type => 'csv', version => '0.73' }, { A1 => 'foo', A2 => 1, B1 => 'bar', B2 => 2, C1 => 'dog', C2 => 'Bull', attr => [], cell => [ [], [ undef, 'foo', 1 ], [ undef, 'bar', 2 ], [ undef, 'dog', 'Bull' ] ], label => 'test.csv', maxcol => 3, maxrow => 2 } ] $

Enjoy, Have FUN! H.Merijn

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (7)
As of 2024-04-23 19:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found