Solved

How do I create an XML file from an XLS spreadsheet?

Posted on 2010-08-27
6
498 Views
Last Modified: 2013-11-19
I have an XSD schema file that I have used XMLSpy to generate a sample XML file with.

I have a spreadsheet with data in it and I would like to put the data into an XML file that fits the format of the sample I have generated from the schema.

Would I use Altova Mapforce for this? If so would I use my sample XML as my source or target? Do I point the arrows from the XLS into the XML or the other way around in the mapping or is there another way to do it?


Thanks,
Bobby
0
Comment
Question by:ob1_
  • 3
  • 3
6 Comments
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 33549612
You can save a spreadsheet as an XML file. The XML file will be to a specific standard which you should be able to use with any good mapping tool.
0
 
LVL 6

Author Comment

by:ob1_
ID: 33554658
ok - how would I do this?
0
 
LVL 40

Accepted Solution

by:
Richard Quadling earned 500 total points
ID: 33556940
In Excel, you File|Save As  and choose XML as the file type.

0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 
LVL 6

Author Comment

by:ob1_
ID: 33558323
how would that save the XML file in the format of the sample XML file that I have?
0
 
LVL 6

Author Closing Comment

by:ob1_
ID: 33560226
thanks
0
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 33565521
The XML format saved by Excel is Microsoft's format. You would use a tool to translate that to whatever format you wanted.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to read XML file attributes... 17 71
XSLT: Is it possible to assign number format from a variable? 5 48
Convert Oracle data into XML document 2 69
tutorial for ebay api 3 56
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 …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

820 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