Make Excel allow numeric fields as text - XML SOAP

> I am generating XML spreadsheets to be opened with Excel. In one cell there
> is an employee ID number that is often, but not always, wholly numeric. I
> am coding it as
>
> <Cell><Data ss:Type="String">01234567</Data></Cell>
>
> and Excel complains that a number is represented as text.
>
> I know the Excel user can turn off this error check, but is there a way I
> can handle it at the XML level?
>
>
> Many thanks!
>
>
>

for numeric types set ss:Type on Data = "Number"

for datetimes set ss:Type = "DateTime" but the format of the text has to be like "2007-12-31T18:45:32.000".

you may need to look at ss:Style attribute (also on the Data node) for presentation.

since documentation on this seems sparce it usually helps if you can do what ever you want to see in a spreadsheet, then save it as XML Spreadsheet. If you open that XML in Note pad, you can usually figure out what you need to do in your XML.



BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities