<p>我正在用熊猫阅读excel阅读一个文件</p>
<pre><code>df0 = pd.read_excel(cfname,'Calendari', index_col=0, parse_cols='A:R',
converters={'Categoria':str,'Fase':str, 'Grupo':str, 'Jornada':str,
'Partido':str, 'IdPartido':str,'Leido':str})
df0.head()
</code></pre>
<p>输出为:</p>
^{pr2}$
<p>我用openpyxl写了一个新的日期:在第6行我写了2017-10-01</p>
<pre><code>from openpyxl import load_workbook
wb = load_workbook(filename = cfname, keep_vba=True)
ws = wb.get_sheet_by_name('Calendari')
cell = ws['I6']
cell.value = datetime.strptime('01/10/2017', "%d/%m/%Y")
cell.number_format = 'dd/mm/yyyy'
wb.save(filename = cfname)
</code></pre>
<p>在Excel中,日期似乎保存得很好,采用了日期格式。但当我尝试用pandas read_excel再次读取文件时,数据已发生更改<br/>
但这一部分的价值观</p>
<pre><code>Linea Categoria Fase Grupo Jornada Partido IdPartido Leido Data Hora
2 CCM 1 1 NaN NaN NaN No Jornada 1 NaN
3 CCM 1 1 NaN NaN NaN No Data Hora
4 CCM 1 1 NaN NaN NaN No 2017-09-30 00:00:00 19:30:00
5 CCM 1 1 NaN NaN NaN No 2017-09-30 00:00:00 17:45:00
6 CCM 1 1 NaN NaN NaN No 2017-10-01 00:00:00 18:00:00
</code></pre>
<p>我不知道为什么。我尝试使用转换器,没有转换器,不同的日期格式,<br/>
拜托,有人能帮我吗?在</p>