XPath.SetValue question

I’m using the following code to map elements to a list:

Please Login or Register  to view this content.

This is the schema:

Please Login or Register  to view this content.

my code works fine for the first element: type="xsd:string" but for the second element: type="xsd:integer" I get a warning:

The data you are attempting to map contains formatting that is incompatible with the format specified in the worksheet.
(with three choices) "Use existing formatting," "Match element data type," or "Cancel."

I’m starting with a new blank sheet that is formatted by default to “General”.

If I map the integer element to the first column and the string element to the second column it works fine.

can someone tell me what causes the warning and how to fix it.

Using Excel 2007

I did some experimenting and found that formatting the header row first fixed the problem.

Please Login or Register  to view this content.