Open XML – OLE Automation Date Issues
If you are exporting a date from C# to Excel using 2007, you probably will use the following:
Math.Round(DateTime.Now.ToOADate(), 12).ToString()
This exports the date as a OLE Automation date recognized by Excel 2007. How ever, in Excel 2010 this was causing issues, every time I exported to Excel 2010, it said that it has to repair my document and it never displayed the values correctly as dates.
Because I was using Open XML to generate the markup, Excel 2010 has been support for Open XML. I got around the problem of using:
DateTime.Now.ToString("yyyy-MM-dd'T'HH:mm:ss.fffffffzzz");
This exports the date as a XML Date format.
Hope this helps anyone who has the same problem!
1 Comment
Leave a Reply
You must be logged in to post a comment.
-
-
-
CodeLab Twitter- codelabnz: @possiblyb9 I now have blackberry for breakfast February 7, 2012
- codelabnz: I have now joined most ppl in indonesia and got myself a blackberry February 7, 2012
- codelabnz: From a bb February 6, 2012
- codelabnz: @bartekmarnane some info on micro orms http://t.co/UDfv5ML7 February 5, 2012
- codelabnz: @bartekmarnane depends on the project, but i found u have 2 be very careful with EF and the type of SQL it generates February 5, 2012
- codelabnz: @bartekmarnane I have been using EF for awhile, good for building apps quickly, but found it performs bad on higher traffic web applications February 5, 2012
- codelabnz: stuff it, I give up on Entity Framework, going to a micro ORM, back to writing SQL queries! I would rather do this than have a slow app! February 5, 2012
- codelabnz: Been too busy for tweeting lately January 21, 2012
- codelabnz: Blog Post: Setting the screen position when visiting previous page with jQuery http://t.co/evuKxVv0 January 17, 2012
- codelabnz: is anyone using Godaddy Cloud hosting? can someone provide their website so I could do a speed test? January 9, 2012
[...] This post was mentioned on Twitter by Ken Eldridge, Tim Brown. Tim Brown said: Blog Post: Open XML – OLE Automation Date Issues http://blog.codelab.co.nz/2010/07/26/open-xml-ole-automation-date-issues/ [...]