slight csv misbehavior under Windows

Skip Montanaro skip at pobox.com
Mon Aug 18 11:24:10 EDT 2003


    Thomas> produces lines ending 0d0d0a, and when you load this into Excel
    Thomas> 97 the data appears double-spaced.

    Thomas> Opening the file with 'wb' solves the problem, but it would be
    Thomas> lovely were this either fixed or documented; it's rather
    Thomas> unintuitive that a file opened with 'wb' still ends lines with
    Thomas> 0d0a.

It is documented.  You have to open CSV files in binary mode.  In the csv
module docs it states the following for both the reader and writer factory
functions:

    If csvfile is a file object, it must be opened with the 'b' flag on
    platforms where that makes a difference.

It makes a difference on Windows, so you need to use 'b'.  

Skip





More information about the Python-list mailing list