python更改csv分隔符,python csv列表分隔符基于区域设置

how to detect list separator in users machine with Python?

CSV file needs to be created on users machine and the list separator must be detected automatically (so that excel can read the CSV file).

I've found out that Excel takes CSV elements separator from "Regional Options -> Numbers -> List separator". locale module in Python is used to detect cultural settings, but it (locale.localeconv) does not contain list separator. Opening CSV writer with dialect='excel' does not help. Any idea how to get the correct separator?

EDIT

The following code seems to work (but can't accept any upvotes as the solution is not mine)

import locale

langlocale = locale.getdefaultlocale()[0]

locale.setlocale(locale.LC_ALL, langlocale)

dp = locale.localeconv()['decimal_point']

delimiter = ','

if dp == ',':

delimiter = ';'

解决方案

Write an XLS file with xlwt.

Take 2: Use the locale module and some heuristics:

>>> import locale

>>> locale.setlocale(locale.LC_ALL, '') # set to user's locale, not "C"

'English_Australia.1252'

>>> dec_pt_chr = locale.localeconv()['decimal_point']

>>> if dec_pt_chr == ",":

... list_delimiter = ";"

... else:

... list_delimiter = ","

...

>>> print repr(dec_pt_chr), repr(list_delimiter)

'.' ','

>>> locale.setlocale(locale.LC_ALL, 'French_France.1252')

'French_France.1252'

>>> dec_pt_chr = locale.localeconv()['decimal_point']

>>> if dec_pt_chr == ",":

... list_delimiter = ";"

... else:

... list_delimiter = ","

...

>>> print repr(dec_pt_chr), repr(list_delimiter)

',' ';'

>>>