XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
alea zhaoSubject: 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

Postnext
Ivan PedruzziSubject: 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

Postnext
alea zhaoSubject: 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


UnknownIndustryStandard.xsd


UnknownDefaultTypes.xsd


UnknownDefaultEvents.xsd


UnknownUploadTemplate4forSignOff1.xls

Posttop
Ivan PedruzziSubject: 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 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.