更新时间:2023-11-07 12:03:34
您必须使用函数ToOADate
将DateTime
转换为double
,即:
You have to convert DateTime
to double
using function ToOADate
i.e.:
DateTime dtValue = DateTime.Now;
string strValue = dtValue.ToOADate().ToString(CultureInfo.InvariantCulture);
然后将其设置为CellValue
Cell cell;
cell.DataType = new EnumValue<CellValues>(CellValues.Date);
cell.CellValue = new CellValue(strValue);
请记住要使用DateTime
格式设置单元格的格式,否则您将看到double
值,而不是日期.
Remember to format cell using DateTime
formatting, otherwise you will see double
value, not date.