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 » Conerting Excel to XML
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + API to retrieve 'Adapter URL' ... (2)
-> + How do I move my Stylus Studio... (6)
-> + API to retrieve 'Adapter URL' ... (2)
-> + InterPage Linking Problem in .... (2)
-> + xsl - header only once in fore... (7)
-> + StylusDiff.exe crashes when co... (5)
-> + Validation against schemas wan... (5)
-> - Conerting Excel to XML (5)
-> ->Conerting Excel to XML
-> ->Converting Excel to XML
-> ->Converting Excel to XML
-> ->Converting Excel to XML
-> + count the number of 1 appearin... (10)
-> + Import validation errors (2)
-> + Custom Validation Saxon (4)
-> + How Can i Check if else condit... (2)
-> + Stylus Studio 2009 Ent still b... (2)
-> + cannot download SS2009 (2)
-> + Use of import-schema wants sch... (4)
-> + Replacement Install Media/Bits (3)
-> + XML to Flat File (5)
-> + Select one of multiple attribu... (13)
-> + Web Service - SOAP Error (3)
-> + I find a BUG in stylus studio ... (8)
-- Previous [901-920] [921-940] [941-960] 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
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
(Deleted User) Subject: Conerting Excel to XML
Author: (Deleted User)
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
(Deleted User) Subject: Converting Excel to XML
Author: (Deleted User)
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.
   
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.