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


In reply to Re^2: Excel in Perl by roboticus
in thread Excel in Perl by chuck_norris

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":