Writing list of dictionaries to CSV
Tim Chase
python.list at tim.thechases.com
Wed May 6 14:22:55 EDT 2015
On 2015-05-06 19:08, MRAB wrote:
> You could tell it to quote any value that's not a number:
>
> w = csv.DictWriter(f, pol_keys,
> quoting=csv.QUOTE_NONNUMERIC)
>
> It looks like all of the values you have are strings, so they'll
> all be quoted.
>
> I would hope that Excel will then treat it as a string; it would be
> stupid if it didn't! :-)
Sadly, Excel *is* that stupid based on the tests I tried just now. :-(
Regardless of whether "Mar 2015" is quoted or unquoted in the source
CSV file, Excel tries to outwit you and mangles the presentation.
-tkc
More information about the Python-list
mailing list