Solved

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

Posted on 2010-08-30
2
1,749 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
Comment Utility
0
 
LVL 6

Author Closing Comment

by:ob1_
Comment Utility
thanks
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction Knockoutjs (Knockout) is a JavaScript framework (Model View ViewModel or MVVM framework).   The main ideology behind Knockout is to control from JavaScript how a page looks whilst creating an engaging user experience in the least …
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 …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now