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