How to insert a date to an Open XML worksheet?
Posted
by Manuel
on Stack Overflow
See other posts from Stack Overflow
or by Manuel
Published on 2010-05-07T23:50:07Z
Indexed on
2010/05/07
23:58 UTC
Read the original article
Hit count: 837
openxml-sdk
|excel-2007
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?
Thanks,
© Stack Overflow or respective owner