SSDN - Conerting Excel to XML

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

Doug Arnn

Subject: 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.

finalcustomer.xml
Customer file

FinalCustomer.xlsx
Customer file in excel

(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

Doug Arnn

Subject: Converting Excel to XML
Author: Doug Arnn
Date: 18 Dec 2008 10:16 AM

ok, I have included a single zipped file.

FinalCustomer.zip

(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

finalcustomer.xsl
The stylesheet generated by mapper

Doug Arnn

Subject: 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

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.