XLDateAmbiguous 解决方法

问：

将 Excel 文件读入 Python 通常意味着要被 Excel 闰年问题绊倒。这在许多帖子中都有描述，但没有一个提供方便的解决方案。这就是我在这里要问的。使用以下代码：

import xlrd
from pandas import *

xlfile = 'test.xlsx'
wb = xlrd.open_workbook(xlfile)

sn = wb.sheet_names()
dfs = [read_excel(xlfile, x) for x in sn]

如何避免由此产生的问题*：

---------------------------------------------------------------------------
XLDateAmbiguous                           Traceback (most recent call last)
<ipython-input-8-1db99305e2ac> in <module>()
      1 sn = wb.sheet_names()
      2 
----> 3 dfs = [read_excel(xlfile, x) for x in sn]

/R/.virtualenv/pydata/lib/python2.7/site-packages/pandas/io/excel.pyc in read_excel(path_or_buf, sheetname, kind, **kwds)
     50     """
     51     return ExcelFile(path_or_buf,kind=kind).parse(sheetname=sheetname,
---> 52                                                   kind=kind, **kwds)
     53 
     54 class ExcelFile(object):

/R/.virtualenv/pydata/lib/python2.7/site-packages/pandas/io/excel.pyc in parse(self, sheetname, header, skiprows, skip_footer, index_col, parse_cols, parse_dates, date_parser, na_values, thousands, chunksize, **kwds)
    138                                      chunksize=chunksize,
    139                                      skip_footer=skip_footer,
--> 140                                      **kwds)
    141 
    142     def _should_parse(self, i, parse_cols):

/R/.virtualenv/pydata/lib/python2.7/site-packages/pandas/io/excel.pyc in _parse_excel(self, sheetname, header, skiprows, skip_footer, index_col, has_index_names, parse_cols, parse_dates, date_parser, na_values, thousands, chunksize, **kwds)
    194                 if parse_cols is None or should_parse[j]:
    195                     if typ == XL_CELL_DATE:
--> 196                         dt = xldate_as_tuple(value, datemode)
    197                         # how to produce this first case?
    198                         if dt[0] < datetime.MINYEAR:  # pragma: no cover

/R/.virtualenv/pydata/lib/python2.7/site-packages/xlrd/xldate.pyc in xldate_as_tuple(xldate, datemode)
     78 
     79     if xldays < 61 and datemode == 0:
---> 80         raise XLDateAmbiguous(xldate)
     81 
     82     jdn = xldays + _JDN_delta[datemode]

XLDateAmbiguous: 1.0

* 除了在输入任何数据或用 NA 搜索/替换 1/1/1900 之前在 Excel 中手动更改日期系统......