Results 1 to 2 of 2

Thread: XML mapping is not exported properly in Microsoft Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    64

    XML mapping is not exported properly in Microsoft Excel

    How to you resolve this.

    "An XML mapping cannot be exported if the mapped elemental relationship with other elements cannot be preserved. This relationship may not be preserved for the following reasons:
    The schema definition of a mapped element is contained within a sequence with the following attributes:
    The maxoccurs attribute is not equal to 1.
    The sequence has more than one direct child element defined, or has another compositor as a direct child.
    Non-repeating sibling elements with the same repeating parent element are mapped to different XML lists.
    Multiple repeating elements are mapped to the same XML list, and the repetition not defined by an ancestor element.
    Child elements from different parents are mapped to the same XML list.

    Additionally, the XML mapping cannot be exported if it contains one of the following XML schema constructs:
    List of lists one list of items contains a second list of items.
    Denormalized data An XML list contains an element that has been defined in the schema to occur once (the maxoccurs attribute is set to 1).
    When you add such an element to an XML list, Excel fills the list column with multiple instances of the element. Choice A mapped element is part of a <choice> schema construct."

  2. #2
    Join Date
    Nov 2010
    Posts
    422

    Re: XML mapping is not exported properly in Microsoft Excel

    Objects such as Clipart, WordArt, Charts, onSheet Form Controls etc are saved in GIF Format into the activeworkbook Path. Any objects that have a space in their names will have that space replaced with an underscore. You can Name the web sheet, add Meta Keywords, Put in a Title. Objects are optional and you can decide from the list of current objects which to include into the web sheet or none.

Similar Threads

  1. Replies: 2
    Last Post: 31-12-2013, 04:49 PM
  2. Replies: 4
    Last Post: 26-02-2012, 01:08 PM
  3. Replies: 2
    Last Post: 14-01-2012, 03:29 PM
  4. Replies: 4
    Last Post: 17-05-2011, 10:01 PM
  5. S-curve exported to excel
    By Lima Jaric in forum Microsoft Project
    Replies: 2
    Last Post: 23-09-2010, 04:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,749,882,428.86827 seconds with 17 queries