Hi

I am using excel-2007.

I have a xml schema file ( no data in it ), I want to import this schema in the excel and provide values for the "required tags" and
generate the xml file ( with data in it ).

I am able to do the following :

1) Import xsd in excel
2) Provide values for the required tags in excel
3) Export xml ( with provided input )

However, I face the following problem :

The tags which donot have values in it are also getting exported in the xml file, which I dont want to.
I did the following, made all elements in xsd as optional by providing minoccur as zero, but still no luck.

How can I export only those xml tags which has values in it from excel 2007.