SSDN - convert

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

alea zhao

Subject: convert
Author: alea zhao
Date: 04 Dec 2006 09:34 AM

Hello, I am wondering if stylus can convert an excel file to xml format according to specific schema.

Thanks

Ivan Pedruzzi

Subject: convert
Author: Ivan Pedruzzi
Date: 04 Dec 2006 10:04 AM

Hi Alea,

You should start saving the Excel spreadsheet as XML Spreadsheet (*.xml). One you have it in XML format then you can use XSLT to reshape the document to the desired output using the XML to XML mapping tool.

Ivan Pedruzzi
Stylus Studio Team

alea zhao

Subject: convert
Author: alea zhao
Date: 04 Dec 2006 02:11 PM

Thank you quick reply. I am not familiar with Stylus Studio. would you please give me details about it. I have attached my schema and sample excel. I need to convert excel file to xml format using the schema.

Thanks

IndustryStandard.xsd

DefaultTypes.xsd

DefaultEvents.xsd

UploadTemplate4forSignOff1.xls

Ivan Pedruzzi

Subject: convert
Author: Ivan Pedruzzi
Date: 04 Dec 2006 10:45 PM

Please have a look to video tutorial on XML to XML mapping at

http://www.stylusstudio.com/videos/xsltedit1/xsltedit1.html
http://www.stylusstudio.com/xslt_mapper.html

Online documentation
http://www.stylusstudio.com/docs/v2007/d_start29.html#wp440738

Ivan Pedruzzi
Stylus Studio Team

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.