Save excel as xml: null elements are missing

sweetpotatop@yahoo.com

Guest

Posts: n/a

8th Jul 2008

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.

« Save excel as xml: null elements are missing | Copy formulas to next month »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Failed to save table attributes of (null) into (null).	Luca Brasi	Microsoft Excel Misc	2	4th Feb 2009 05:30 PM
Save excel as xml: null elements are missing	sweetpotatop@yahoo.com	Microsoft Excel Discussion	0	8th Jul 2008 06:02 PM
Difference between returning null and array with zero elements	Sek	Microsoft C# .NET	10	14th Apr 2006 03:52 PM
Toolbar elements missing	=?Utf-8?B?UGF1bCBUcmVudGVy?=	Microsoft Word Document Management	2	5th Sep 2005 06:03 PM
Null elements don't appear in XMLTextWriter results	AFN	Microsoft Dot NET Framework	6	18th Jun 2004 09:07 PM