Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2010-08-30
2
Medium Priority
?
2,597 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_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

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

Author Closing Comment

by:ob1_
ID: 33589961
thanks
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
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 will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

618 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