Tech Off Post

Single Post Permalink

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

    quantass0 wrote:
    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


    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.