I'm using Microsoft Open XML SDK 2 and I'm having a really hard time inserting a date into a cell. I can insert numbers without a problem by setting Cell.DataType = CellValues.Number
, but when I do the same with a date (Cell.DataType = CellValues.Date
) Excel 2010 crashes (2007 too).
I tried setting the Cell.Text
value to many date formats as well as Excel's date/numeric format to no avail. I also tried to use styles, removing the type attribute, plus many other pizzas I threw at the wall…
Can anyone point me to an example inserting a date to a worksheet?
Best Answer
I used the code provided by Andrew J, but the
DataType
CellValues.Date
produced a corrupted xlsx-file for me.The
DataType
CellValues.Number
worked fine for me (Don't forget to setNumberFormatId
):My whole code:
My CellFormat for this cell in the Stylesheet looks like:
If you'd like to format your date another way, here is a list of all default Excel
NumberFormatId
'sSource of list: https://github.com/ClosedXML/ClosedXML/wiki/NumberFormatId-Lookup-Table
I know this list is from ClosedXML, but it's the same in OpenXML.