Avatar of Matt Jones
Matt Jones
Flag for United States of America asked on

Writing an XML file based on raw data from an Excel 2010 worksheet

1. I have an Excel 2010 file with 20+ columns.

2. I need to write an XML (output) file which is based on the data in Excel 2010 (input).

3. The SAME (selected) columns from EACH row provide blocks for the XML file. The XML file is also supposed to comply to an XSD.

4. The FIRST row in the Excel sheet contains the XML tag names.

5. Each subsequent row in Excel 2010 turns into a series of tagged entries in the XML file.

6. Is this even possible in Excel 2010? I did see "XML Maps" in Excel 2010; I have never used XML Maps before, hence this question.

7. Please post high level steps, or pointer to detailed Excel documentation.

8. If you have a sample Excel file that you turned into XML, that is an A grade response :-).
XMLMicrosoft Excel

Avatar of undefined
Last Comment
telyni19

8/22/2022 - Mon
SOLUTION
Ken Butters

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
telyni19

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61