Solved

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

Posted on 2010-08-30
2
2,016 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 500 total points
ID: 33560563
0
 
LVL 6

Author Closing Comment

by:ob1_
ID: 33589961
thanks
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Array problem 6 49
Calculate number of months in Excel 13 28
Compare data between two sheets in Excel 6 33
How to always round a decimal up 5 21
Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

749 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