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
Doug ArnnSubject: Conerting Excel to XML
Author: Doug Arnn
Date: 17 Dec 2008 10:54 AM
Hello, I am new to Stylus Studio, so please bear with me on this.
I am trying to convert a Excel spreadsheet, with contains two record types within a single line, to XML. for example. Excel with a row for Customer, name, would be part of <header> and then the Address, would be part of the <Address> tags. I have included the same XML I will need.


Unknownfinalcustomer.xml
Customer file

UnknownFinalCustomer.xlsx
Customer file in excel

Postnext
Alberto MassariSubject: Conerting Excel to XML
Author: Alberto Massari
Date: 18 Dec 2008 05:55 AM
Hi Doug,
can you post the files as a single .zip? The web board software doesn't handle files with the .xslx extension.

Thanks,
Alberto

Postnext
Doug ArnnSubject: Converting Excel to XML
Author: Doug Arnn
Date: 18 Dec 2008 10:16 AM
ok, I have included a single zipped file.


UnknownFinalCustomer.zip

Postnext
Alberto MassariSubject: Converting Excel to XML
Author: Alberto Massari
Date: 19 Dec 2008 10:08 AM
Hi Doug,
the zip file contains a CSV file, not an XSLX; I guess you decided to export the table in this format, so I designed an XSLT using mapper where the source schema is the output of the CSV flat file converter, and the target is the sample XML you provided.
I had to guess what needed to be moved to the Address section, but I think you can get the idea about how Mapper can work in these scenarios.

Alberto


Unknownfinalcustomer.xsl
The stylesheet generated by mapper

Posttop
Doug ArnnSubject: Converting Excel to XML
Author: Doug Arnn
Date: 19 Dec 2008 10:15 AM
Great, thanks, I appreciate your help.

 
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.