Converting Excel file to XML

**J.Lipiec** · 05-13-2009, 08:57 AM

Hi All,

I was wondering if you could help with this Excel query, converting an Excel Spreadsheet to XML.

I need the tag headings to go down the rows rather than across the columns, if that makes sense. The sheer number of tags I need means that I would need more than the maximum allocation of columns available on Excel.

Is there any way to do this? I am unsure whether Excel is flexible enough to do this, or if it is down to the XML schema to define how the data is presented in Excel? The blue map area with the star seems to only want to create new data going down.

I attach the file I have been using. Screenshots are here:

*** Warning *** Linked page has dubious adverts that may be considered inappropriate

http://www.mypicx.com/05132009/Excel_Screenshots/

The first is the actual spreadsheet and the second is the desired layout.

The XML Schema is currently as follows:

------

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"><xsd:element nillable="true" name="CLSDetails"><xsd:complexType><xsd:sequence minOccurs="0"><xsd:element minOccurs="0" maxOccurs="unbounded" nillable="true" name="CustDetails" form="unqualified"><xsd:complexType><xsd:sequence minOccurs="0">

<xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="CustID" form="qualified"></xsd:element>

<xsd:element minOccurs="0" nillable="true" type="xsd:string" name="FirstName" form="unqualified"></xsd:element>

<xsd:element minOccurs="0" nillable="true" type="xsd:string" name="LastName" form="unqualified"></xsd:element>

<xsd:element minOccurs="0" nillable="true" type="xsd:string" name="***" form="unqualified"></xsd:element>

<xsd:element minOccurs="0" nillable="true" type="xsd:integer" name="Age" form="unqualified"></xsd:element>

<xsd:element minOccurs="0" nillable="true" type="xsd:string" name="Address1" form="unqualified"></xsd:element>

<xsd:element minOccurs="0" nillable="true" type="xsd:string" name="Address2" form="unqualified"></xsd:element>

<xsd:element minOccurs="0" nillable="true" type="xsd:string" name="Address3" form="unqualified"></xsd:element>

</xsd:sequence></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:schema>

------

Many Thanks.

**Andy Pope** · 05-13-2009, 10:47 AM

J.Lipiec, I realise you have no control over the hosting sites advertising choice so the warning is for other members rather than aim at you personally.