Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
An XML mapping cannot be exported
How to you resolve this,
An XML mapping cannot be exported if the mapped elements 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. I am using Excel 2003 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
An XML mapping cannot be exported
Hello, Sorry, no XML but will HTML help? WebCreator_Simple.xls 3 December 2005 Excel XP Create your own web pages for Excel Worksheets. This is not XML! I have only used basic HTML. Cell data is put into a Table (options for borders available). 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... Should work with Excel2003 http://www.geocities.com/excelmarksway - -Mark "Sol" wrote: How to you resolve this, An XML mapping cannot be exported if the mapped elements 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. I am using Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting not applied to data exported from Access | Excel Worksheet Functions | |||
XML Mapping Issues | Excel Discussion (Misc queries) | |||
Mapping one table based on another table range | Excel Worksheet Functions | |||
Exported Data to excel appearing wrong in Columns | Excel Discussion (Misc queries) | |||
Formating exported data | Excel Worksheet Functions |