?
Solved

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

Posted on 2010-08-27
6
Medium Priority
?
503 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 1500 total points
ID: 33556940
In Excel, you File|Save As  and choose XML as the file type.

0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
JavaScript has plenty of pieces of code people often just copy/paste from somewhere but never quite fully understand. Self-Executing functions are just one good example that I'll try to demystify here.
The viewer will learn how to dynamically set the form action using jQuery.
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…
Suggested Courses

850 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