Solved

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

Posted on 2010-08-27
6
497 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
AngularJS directive issue 6 70
Convert Oracle data into XML document 2 65
How can I assign SimpleXMLElements to variables? 5 61
Powershell XML in variable 4 19
Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
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…

786 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