XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » convert
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + DB to XML convertion (6)
-> + Converting: How to handle data... (2)
-> + Toss Character Exception (2)
-> + EDI conversion COM segment (5)
-> - SS passing invalid CALS table ... (1)
-> + Carrier Related EDI SAP questi... (2)
-> + How to generate 1 output XML f... (2)
-> + Urgent Eval: How2 w/ Possibly ... (4)
-> + Preview Problems (7)
-> + Mapping to EDIFACT ORDERS UNT0... (8)
-> + Deploying Conversion XML to ED... (2)
-> + Use EDI Adapter within Sap BC (3)
-> + Uninstall->instal entepr. 2007 (2)
-> - xml data to sql 2000 table (1)
-> - Convert from Oracle DB to XML ... (1)
-> + NTFShardlink broken (5)
-> + Can't get catalog to work (3)
-> + Only One of each EDI segment g... (3)
-> + convert (2)
-> - convert (4)
-> ->convert
-> ->convert
-> ->convert
-- Previous [1861-1880] [1881-1900] [1901-1920] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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
   
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.