<div>
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.
</div>


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.

<div>
how would that save the XML file in the format of the sample XML file that I have? 
</div>


how would that save the XML file in the format of the sample XML file that I have?

<div>
The XML format saved by Excel is Microsoft's format. You would use a tool to translate that to whatever format you wanted.
</div>


The XML format saved by Excel is Microsoft's format. You would use a tool to translate that to whatever format you wanted.

<div>
<div class="content wysiwyg-content">
I have an XSD schema file that I have used XMLSpy to generate a sample XML file with. <br />
<br />
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. <br />
<br />
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? <br />
<br />
<br />
Thanks, <br />
Bobby<br />

</div>
</div>


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


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

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.

Web Languages and Standards

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).