Tech Off Post

Single Post Permalink

View Thread: Excel 2003 and save as XML Spreadsheet
  • User profile image

    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.