How to format my XML from my Schema (.xsd)

Posted on 2012-09-13
Last Modified: 2012-11-16
Hello Experts,

I have data I've exported from Excel as XML.  Excel will not export as XML unless there is a Schema file to map.

From the attached file, you can see the schema I'm using and the resulted XML that was exported from Excel.

The bottom image shows what I want my XML to look like.

is there a way to setup my Schema (XSD) file to get my XML formatted like the bottom?

Thanks for any help.
Question by:Modifier1000
    LVL 60

    Expert Comment

    by:Geert Bormans
    Make sure that you export the data as XML (second format), not as Spreadsheet XML(first format)

    What version of Excel do you use?
    It has fundamentally changed from 2003 to 2010
    LVL 60

    Accepted Solution

    Second format is called "XML Data" that is what you want and that requires a schema,
    First format is called "XML Spreadsheet 2003" in 2010

    Author Comment

    Using Excel 2007.

    Going to try your response now, will give an update shortly.

    Author Comment

    Thank you!

    Author Closing Comment

    Thank you.
    LVL 60

    Expert Comment

    by:Geert Bormans

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    761 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

    15 Experts available now in Live!

    Get 1:1 Help Now