1ãé¦å æåå¤äºä¸ä¸ªexcelææ¡£ï¼å¨ç¬¬ä¸ä¸ªå·¥ä½è¡¨çA1åå æ ¼éæä¸ä¸ª2020-11-7
2ã使ç¨ä»¥ä¸ä»£ç 读å该åå æ ¼çå¼å¹¶è½¬æ¢ä¸ºç¸åºçæ ¼å¼ï¼
# coding=gbk
import datetime
import openpyxl
# æå¼ææ¡£ï¼ä½¿ç¨openpyxlåªè½æä½xlsx
wb = openpyxl.load_workbook("示ä¾ææ¡£.xlsx")
# å¾å°å·¥ä½è¡¨
ws = wb["Sheet1"]
# å¾å°åå
æ ¼çå¼
cell_value = ws.cell(row=1,column=1).value
# 转æ¢ä¸ºç¸åºæ ¼å¼çæ¥æ
result = datetime.datetime.strftime(cell_value,"'%Y-%m-%d'")
print(result)
æåæ¾ç¤ºä¸ºï¼'2020-11-07'