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