Solved

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

Posted on 2010-08-27
6
492 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:RQuadling
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:
RQuadling earned 500 total points
ID: 33556940
In Excel, you File|Save As  and choose XML as the file type.

0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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:RQuadling
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

707 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

16 Experts available now in Live!

Get 1:1 Help Now