Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Excel in Perl

by halley (Prior)
on Jan 30, 2008 at 14:57 UTC ( #665138=note: print w/replies, xml ) Need Help??


in reply to Excel in Perl

If you're not interested in pretty formatting, just consider a CSV format instead. It's plain text, it can be generated and parsed very simply in Perl. See Text::CSV among other modules. Also, you can see it and edit it in Notepad or Emacs or whatever. Excel reads and writes CSV files just fine.

--
[ e d @ h a l l e y . c c ]

Replies are listed 'Best First'.
Re^2: Excel in Perl
by roboticus (Chancellor) on Jan 31, 2008 at 09:48 UTC
    One problem with using .CSV files and Excel is long digit strings (such as account numbers). I've not found a way in a .CSV file to get them to appear correctly in a spreadsheet. I'm always forced to add a prefix to turn it into a string, and the sheet shows the annoying prefix.

    So unless I'm missing something, there are a few cases (in addition to pretty formatting) where creating a spreadsheet is preferable to a .CSV file.

    Example:

    1234567890123456,"1234567890123456","'1234567890123456",'1234567890123 +456 1234567890123456,"1234567890123456","'1234567890123456",'1234567890123 +456 1234567890123456,"1234567890123456","'1234567890123456",'1234567890123 +456 1234567890123456,"1234567890123456","'1234567890123456",'1234567890123 +456 1234567890123456,"1234567890123456","'1234567890123456",'1234567890123 +456 1234567890123456,"1234567890123456","'1234567890123456",'1234567890123 +456 1234567890123456,"1234567890123456","'1234567890123456",'1234567890123 +456 1234567890123456,"1234567890123456","'1234567890123456",'1234567890123 +456
    Someone ... anyone ... please prove me wrong!

    ...roboticus

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://665138]
help
Chatterbox?
[Corion]: Cosmic37: Ah, see perlfaq4, about How do I compute the intersection of two arrays
[Cosmic37]: I am out of practice; I use Perl for scientific programming for number crunching
[Corion]: Cosmic37: Basically, you read one file into a hash, keyed by your key, and then match the lines from the second file to that hash
[Cosmic37]: note that the two files only have datetimes which may match whereas other data per line is different format in file1 and file2 - is that really intersection?
[jedikaiti]: Hi Monks
[Corion]: Cosmic37: Well, if you want to use only parts of a line for the key, see split or whatever other mechanism to extract the key from the line
[Corion]: Hi jedikaiti!
[Cosmic37]: is there a webpage for full CB for this chat rather than side panel chat?
[Cosmic37]: thank you for advice
[Cosmic37]: peach greets jedi

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (9)
As of 2017-06-29 16:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (672 votes). Check out past polls.