+-
我正在尝试使用公式将日期值从单元格复制到另一个单元格.但是尝试将日期格式添加到worksheet.write_formula()会导致excel显示以下警报
这是我正在使用的示例代码：
import xlsxwriter
from datetime import date
workbook = xlsxwriter.Workbook("testFile.xlsx")
worksheet = workbook.add_worksheet()
dateFmt = workbook.add_format({'num_format': 'mm/dd/yyyy'})
worksheet.write(0, 0, date(2018, 12, 26),dateFmt)
worksheet.write_formula('B1','=A1', dateFmt, date(2018, 12, 26))
workbook.close()
最佳答案
@Chof是正确的,不接受date()值作为公式值.
相反,您可以使用XlsxWriter datetime_to_excel_datetime()实用程序函数将其转换为Excel日期,即数字：
import xlsxwriter
from datetime import date
from xlsxwriter.utility import datetime_to_excel_datetime
workbook = xlsxwriter.Workbook("testFile.xlsx")
worksheet = workbook.add_worksheet()
dateFmt = workbook.add_format({'num_format': 'mm/dd/yyyy'})
worksheet.write(0, 0, date(2018, 12, 26), dateFmt)
excel_date = datetime_to_excel_datetime(date(2018, 12, 26), False, False)
worksheet.write_formula('B1','=A1', dateFmt, excel_date)
workbook.close()
点击查看更多相关文章
转载注明原文：python – 带日期的XlsxWriter write_formula - 乐贴网
