Python生成的CSV文件日期无法直接显示的原因及解决方法

问题描述 #

我编写了一段Python爬虫代码，用于爬取网页内容并导出为CSV文件。代码运行成功生成了CSV，但出现一个问题：文件中第一列的日期无法直接在表格单元格中显示，必须点击单元格才能看到完整的日期文本。

爬虫代码 #

#IMPORT LIBRARIES
from bs4 import BeautifulSoup
import requests
import csv

#OPEN A NEW CSV FILE. IT CAN BE CALLED ANYTHING
file = open('csv_py.csv', 'w')

#CREATE A VARIABLE FOR WRITING TO THE CSV
writer = csv.writer(file)

#CREATE THE HEADER ROW OF THE CSV
writer.writerow(['Date', 'Content'])

#REQUEST WEBPAGE AND STORE IT AS A VARIABLE
page_to_scrape = requests.get("https://www.liechi.org/en/")
print(page_to_scrape)

#USE BEAUTIFULSOUP TO PARSE THE HTML AND STORE IT AS A VARIABLE
soup = BeautifulSoup(page_to_scrape.text, 'html.parser')

#FIND ALL THE ITEMS IN THE PAGE WITH A CLASS ATTRIBUTE OF 'archive-item-link'
#AND STORE THE LIST AS A VARIABLE
contents= soup.findAll('a', attrs={'class':'archive-item-link'})

#FIND ALL THE ITEMS IN THE PAGE WITH A CLASS ATTRIBUTE OF 'archive-item-date'
#AND STORE THE LIST AS A VARIABLE
dates = soup.findAll('span', attrs={'class':'archive-item-date'})

#LOOP THROUGH BOTH LISTS USING THE 'ZIP' FUNCTION
#AND PRINT AND FORMAT THE RESULTS
for date, content in zip(dates, contents):
    print(date.text + "(" + content.text + ")")

    #WRITE EACH ITEM AS A NEW ROW IN THE CSV
    writer.writerow([date.text, content.text])

#CLOSE THE CSV FILE
file.close()

问题详情 #

在表格软件中打开生成的csv_py.csv，第一列的日期单元格看起来是空的，只有点击单元格时，编辑栏里才会显示对应的日期内容。

请问这个问题的原因是什么？该如何修改代码来解决这个问题？

内容的提问来源于stack exchange，提问作者Pai