perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "J. Zobel" <nc-zobe...@netcologne.de>
Subject Re: Perl and Microsoft Excel?
Date Fri, 30 Nov 2001 20:33:21 GMT
On Thu, 2001-11-29 at 23:37, Tom Servo wrote:
> There's probably a far better answer to this than I can give, but if not,
> an interim solution might be having whoever maintains these Excel files
> save them as .csv files.   Excel can do that, and while you lose all the
> fancy formatting, it just dumps them in a comma seperated list, then you
> can split on commas to get the values out of it.

Be careful, MScsv is not as simple as it seems. Fields containing , are
enclosed in "" - thats OK. But those ""-enclosed fields saved from Excel
can also contain linebreaks. 

Hth,
Joachim
 


Mime
View raw message