Excel 2003 Professional Edition - Exporting XML Data - optional elements

J

Jason

I have optional elements in my schema. Presently, if the cells mapped to the attributes of the optional elements are left blank, the elements are written with "0" as the attribute (see example below). However, I want the optional elements ("Element1" and "Element2" in the example below) to be omitted from the exported XML file.

For example I get ...
<Properties>

<Element1 a="0" b="0"/>

<Element2 c="0" d="0" e="0" f="0"/>

</Properties>

But, what I want is ...

<Properties>

</Properties>



Can this be done? If so, what's the trick?



tia,



Jason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export to XML 5
xml import in Excel grouping repeating elements by value 0
Preserve XML whitespace in Excel 2003 0
Problems using XML in Excel 2003 4
XML schema validation fails 0
An XML mapping cannot be exported 1
Excel 2007 - import/export XML (Developer tab) 0
Trying to understand pivot tables in XLSX 3

Top