Adding Date to Excel using Open XML

Posted by Ant on Stack Overflow See other posts from Stack Overflow or by Ant
Published on 2010-04-25T17:35:42Z Indexed on 2010/04/25 17:43 UTC
Read the original article Hit count: 190

Filed under:

open

|

Xml

|

excel

Hi, I would like to insert Date value to excel file using Open XML.

Here is my code sample.

cell.CellValue = new CellValue(value.ToString());   
cell.DataType = new EnumValue<CellValues>(CellValues.Date);

© Stack Overflow or respective owner

Related posts about open

How open is open core and is that open enough

as seen on Internet.com - Search for 'Internet.com'
<b>ZDNet:</b> "The idea is that you make the center of your product open source, but put the rest under a paid license. This is supposed to make your venture capital backers happy. You gain the benefits of open source but customers aren’t “stealing” the… >>> More
Microsoft Management Console stops working when I add snap-in to it

as seen on Super User - Search for 'Super User'
I have Windows 7 Ultimate OS. I'm opening mmc.exe as administrator and trying add Certificates or any other snap-in, then while loading that snap-in MMC breaks and displays following message and after that it closes automatically once I click on close button on that message. What could be the problem… >>> More
Introducing Java/Open Source Daily, All the Java/Open Source Information You Need in One Newsletter

as seen on Internet.com - Search for 'Internet.com'
Internet.com launches a new daily newsletter to provide one-stop coverage of all the Java and Open Source information that matters to you. >>> More
Introducing Java/Open Source Daily, All the Java/Open Source Information You Need in One Newsletter

as seen on Internet.com - Search for 'Internet.com'
Internet.com launches a new daily newsletter to provide one-stop coverage of all the Java and Open Source information that matters to you. >>> More
The Open Source Open Source Conference

as seen on Internet.com - Search for 'Internet.com'
Portland, OR open source advocates took the loss of OSCON in stride: They launched their own open source conference. How did it stack up against the heavyweight, top-down competition? >>> More

Related posts about Xml

Store XML,update record in XML,retrive a specific record in XML stored on BB device

as seen on Stack Overflow - Search for 'Stack Overflow'
I am writing a blackberry application where i want to store the data returned by a web service in my BB device.Earlier i was going to use SQLite for storing the data in mobile but as i googled and also did programming using SQLite and found that some BB devices dont support SQLite library and fail… >>> More
gwt+xml- can i read through incomplete XML using the GWT XML Parser

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a requirement where a user is typing in XML in a text area, and I want to show the various nodes in a tree...But as the user is typing in the xml, it wont be a complete xml (since he is still typing in the XML)... How do I read an incomplete XML and correctly generate the tree? I understand… >>> More
perl xml parser get xml content within xml

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I use XMLParser to get the item-@url, item-@replace and item-"value inside" for the content as a string of the node where item-@cone="one"? <cstep> <item cone="one" url="http://google.com/{ccc}/cthree" replace="{ccc}"> <itemsub conesub="conesub"> … >>> More
Reading php generated XML in flash?

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is part 1 of our problem (Loading a dynamically generated XML file as PHP in Flash). Now we were able to get Flash to read the XML file, but we can only see the Flash render correctly when tested(test movie) from the actual Flash program. However, when we upload our files online to preview the… >>> More
Announcing RSS feeds of Microsoft All-In-One Code Framework code samples

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Today, we are not only announcing Sample Browser v2 CTP, but we are also excited to announce the availability of RSS feeds of All-In-One Code Framework code samples. By using these feeds, you can easily track and download the new code samples. English RSS feeds All code samples: http://support… >>> More