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

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
LVL 6
ob1_Asked:
Who is Participating?
 
Richard QuadlingConnect With a Mentor Senior Software DeveloperCommented:
In Excel, you File|Save As  and choose XML as the file type.

0
 
Richard QuadlingSenior Software DeveloperCommented:
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
 
ob1_Author Commented:
ok - how would I do this?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
ob1_Author Commented:
how would that save the XML file in the format of the sample XML file that I have?
0
 
ob1_Author Commented:
thanks
0
 
Richard QuadlingSenior Software DeveloperCommented:
The XML format saved by Excel is Microsoft's format. You would use a tool to translate that to whatever format you wanted.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.