Removing Blank Cell info when save as xml data

[auhom]

Sorry for posting an excel problem here
I am maintaining an excel sheet using references from other worksheet of a same workbook . I want to save the data as xml data. Problem is when i save is as xml data it counts all the blank cells too.

I have an excel document where some of the cells are empty When i save the excel as xml spreadcheet i get the row with all the data from the cells that have data and and the empty cells. Is there a way to save the excel in xml and have the empty cells disappear instead of saving all the data ? I am running xsl on that xml and need to know the value of a non blank cell. Blank cells data is creating problem at the time of uploading.

But i want them not to appear in the xml data sheet. Please help

[IMGnothumb]https://bytes.com/attachment.php? attachmentid=88 12[/IMGnothumb]

[IMGnothumb]https://bytes.com/attachment.php? attachmentid=88 13[/IMGnothumb]

[zmbd]

1) Please do NOT double post your question. We tend to delete the doubled threads.

2) PLEASE do NOT use IMAGES for script. Copy and paste to the TEXT to the thread, and FORMAT THE SCRIPT using the [CODE/] tool

3) Your XML map is going to be the root cause of this effect and that is by design. If the XML map has an element in it and the assigned ranges do not have data then the element in the resulting XML file will be blank.

4) How are you getting your XML data to begin with and what method are you using to export the file to the XML file.

and finally, I am not very familiar with exporting Excel information to the XML format so it will be at best a learning experience for us both. :)

[ADezii]

Can't you Filter the Data prior to the Save As *.XML?

[zmbd]

The issue I see is the elements in the XSD file are mapped
MS: Overview of XML in Excel
I don't see an easy way to filter in this that would avoid the blank elements in the exported XML