I am trying to create a SpreadsheetML-file from a database query and I need to store different kinds of data in the columns, herein numbers, strings and dates. I have no problem creating the first two - but I simply cannot figure out how to make the contents of a cell be formatted as a date.

When I investigate an existing SpreadsheetML-file I can see that the markup looks like this:


So my question is actually two-fold:

1. Where do the s="3" point to exactly?

I have been looking in the spec, and it says that the s-attribute's values is an index into the styles part ... but to what part of it does it refer?

2. Do I have to write the date as a numeric number and not as a ISO-8601-date ... and if so - how do I most easily convert a date to its numeric equivalent?

Thanks,

Jesper

It seems I found the information myself.

1: I stumpled over this article: http://openxmldeveloper.org/forums/thread/597.aspx from this forum

2: http://www.csharphelp.com/board2/read.html?f=1&i=39073&t=39073 (DateTime.Now.ToOADate() )