Recognising a date format in an worksheet.xml
I am currently trying to read an excel spreedsheet into an xml model that we have created. I am reading the worksheet.xml fine and I can determine when the value in the cell is in a boolean or string format. I cannot easily however find a programatic way to distinguish between whether a value is a serialized date or a number.
My firstthoughts was that you could do this through the style.xml page and that it has something to do with the field 'numFmtId' in the node 'cellXfs'. If so is there a standard list of all the available numFmtId allowed? Can anyone please help.
Thanks
Steve

