Solved

Need helping exporting XML file from Excel - getting error re: "List of Lists"

Posted on 2010-08-30
2
1,951 Views
Last Modified: 2013-11-19
I have added an XML schema file (XSD) to a spreadsheet to use as an XML source.

I've mapped 1 cell in the spreadsheet to an XML data element but when I try to export the XML from Excel I get the following error:

Data_Map is not exportable because it contains the following:
List of Lists

The schema also contains required elements which have not been mapped into the spreadsheet.


I think I understand the 2nd part about the required elements but I can't figure out how to fix the list of lists error?

If I map the XML element to a cell at the top of a column it highlights the whole column so I mapped it to the cell at the bottom of the column to test and it only highlighted the cell, yet I got the same errror.


Thanks!!

 - bobby
0
Comment
Question by:ob1_
2 Comments
 
LVL 12

Accepted Solution

by:
FDiskWizard earned 500 total points
ID: 33560563
0
 
LVL 6

Author Closing Comment

by:ob1_
ID: 33589961
thanks
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question