P
ParkerV
Question regarding XML mapping in Excel.
XML Mapping in Excel allows you to map "non-repeating schema elements" to an
individual cell while "repeating schema elements" automatically get handled
as an Excel "list".
I want a table(XML/XSD) exported from a VS2005 dataset to be CELL mappable
rather than LIST mappable.
Is there a way to make Excel interpret the native dataset XML/XSD as
non-repeating?
Said differently, what makes a schema element "repeating" versus
"non-repeating"? Is it a unique XPATH statement?
If my underlying table has a unique primary key, can I manually define/alter
the XSD schema in VS2005 to define a unique xpath statement for each schema
item (some combination of primary key + fieldname)?
What defines "repeating" vs. "non-repeating"?
Many thanks,
PV
XML Mapping in Excel allows you to map "non-repeating schema elements" to an
individual cell while "repeating schema elements" automatically get handled
as an Excel "list".
I want a table(XML/XSD) exported from a VS2005 dataset to be CELL mappable
rather than LIST mappable.
Is there a way to make Excel interpret the native dataset XML/XSD as
non-repeating?
Said differently, what makes a schema element "repeating" versus
"non-repeating"? Is it a unique XPATH statement?
If my underlying table has a unique primary key, can I manually define/alter
the XSD schema in VS2005 to define a unique xpath statement for each schema
item (some combination of primary key + fieldname)?
What defines "repeating" vs. "non-repeating"?
Many thanks,
PV