Re: CSV module and Mac excel format problem

2005-10-13 Thread David Pratt
Many thanks Andrew for this excellent piece of knowledge :-). 4 characters of code and everything is great! Regards, David On Friday, October 14, 2005, at 12:11 AM, Andrew McNamara wrote: >> Hi. I have had good success with CSV module but recently came across >> problem with reading excel from

Re: CSV module and Mac excel format problem

2005-10-13 Thread Andrew McNamara
>Hi. I have had good success with CSV module but recently came across >problem with reading excel from Mac Office. The trouble is with line >endings. Instead of \r\n you have just \r and the file as a whole >appears as a single line. CSV coughs and provides this exception: > >_csv.Error: newli

CSV module and Mac excel format problem

2005-10-13 Thread David Pratt
Hi. I have had good success with CSV module but recently came across problem with reading excel from Mac Office. The trouble is with line endings. Instead of \r\n you have just \r and the file as a whole appears as a single line. CSV coughs and provides this exception: _csv.Error: newline ins