Re: Date formats in XML for Excel Spreadsheet download?

Vicki - I might be able to help if I have a little more detail.

Are you talking about the 2003 Spreadsheet XML format for Excel?

Are you using CGIDEV2 or some similar tool to write the XML?

Or are you doing something different? Like does Excel read the XML directly?

Anyhow, Excel stores dates and times as numbers, known as serial numbers, the dates are the number of days after (or since?) Jan 1, 1900 (or 1904, if you set it up that way).

Hope I'm anywhere on the same planet as you are!! Glad to help if I can. I've been doing a lot work with Excel lately, so may actually know something.

Vern

On 3/11/2015 6:45 PM, Vicki Wilson wrote:

Hi all,

Having trouble find the right XML format for downloading data to an excel spreadsheet.

The user would like the date in "short date" or "long date" format.
I'm starting with a 6 digit number. I can get it converted to iso no problem.

But I'll be darned if I can find the right xml to excel format.

I've tried various combinations including the latest:
This is in the header:
<Style ss:ID="s21">
<NumberFormat ss:Format="MM/DD/YY"/>
</Style>

This is the detail:
<Cell ss:StyleId="s21"><Data ss:Type="Date">2013-09-16</Data></Cell>

I'm googling and finding lots of specific examples - particularly one's that include a full date timestamp - but nothing with just the date. And nothing that really explains the mapping.

Thanks.
Vicki Wilson