擅长:python、mysql、java
<p>我会尝试这样的方法:</p>
<pre><code>import os
import datetime
filenames = os.listdir()
for filename in filenames:
if filename.endswith('.xlsx'): # only grab Excel files
date_object = datetime.datetime.strptime(my_filename, "activity_%Y_%m_%d_%I_%M_%S.xlsx")
print(date_object)
</code></pre>
<p>这里解释了解析时间的重要部分<a href="https://docs.python.org/2/library/datetime.html#strftime-and-strptime-behavior" rel="nofollow noreferrer">here</a></p>
<p>也许更清楚的例子是:</p>
<pre><code>my_filename = "activity_2019_05_13_11_21_30.xlsx"
date_object = datetime.datetime.strptime(my_filename, "activity_%Y_%m_%d_%I_%M_%S.xlsx")
print(date_object)
</code></pre>
<p>结果</p>
<blockquote>
<p>2019-05-13 11:21:30</p>
</blockquote>