We have excel 2003 and are trying to save out a "xml spreadsheet". The mess of a file is created (sorry but why is it so diffiuclt for MS to save out clean proper tags like everyone else) but i notice rows which are completely blank or contain blank fields will have the particular XML tag completely removed. The problem with this is Im expecting 7 columns when sometimes the column can be 5 or 3 or 7. Is there any way to force excel to NOT remove blank fields from the XML file this way everyone contains the 7 tags to correspond with the 7 column fields in the excel file.
Not that I am aware of.
I would go off some heading naming semantic. This way you can see if the mapping you need for what you need in order to do some data exporting.