Excel 2003 and save as XML Spreadsheet

N

NewsBot

1
Joined
Jan 10, 2007
Messages
43,898
Location
In The Machine
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.

Thanks


More...

View All Our Microsoft Related Feeds
 
Back
Top