Save excel as xml: null elements are missing

S

sweetpotatop

Hi,

I am saving a xls file to xml data format, I use a xsd for the
mapping. For some reasons the following happened:

1. On the output, the first line on the XML it says says <xml ...
‘standalone = “yes”>. Is there anything I can set in xls, so that can
be removed?

2. Some of the elements on the output is not shown when the Excel's
cells is empty (not even the element's tag name) . I need those
elements to appear even the cell is empty.

Thanks in advance. Your help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save as word to xml is splitting place holders ex: $abc.xyz$ 0
Help Creating XML File from Spreadsheet 1
XML Mapping: Creating a "non-repeating schema element" in VS2005 0
Opening XML - saving as Excel 0
Importing multiple XML files 0
OWC11 pivot table export to excel fail: missing tag row (seems to 0
Using meta-info or is it possible to extend the OneNote XML Schema 0
Setting xsi in Excel XML output... 0

Top