I hope this is the right forum..

I am trying to create a schema file that will take the column name of an excel document, and make it an attribute, whose value is that of the cell that the column contains. To make this more clear, see the following code I have:

Schema File:
<?xml version="1.0" encoding="UTF-8" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="DataItems">
	<xs:complexType>
		<xs:sequence>
			<xs:element name="record" minOccurs="0" maxOccurs="unbounded">
				<xs:complexType>
					<xs:sequence>
						<xs:element name="columnA">
							<xs:complexType>
								<xs:attribute name="something1" type="xs:string" use="required"/>
							</xs:complexType>
						</xs:element>
						<xs:element name="columnB">
							<xs:complexType>
								<xs:attribute name="something1" type="xs:string" use="required"/>
							</xs:complexType>
						</xs:element>
						<xs:element name="columnC">
							<xs:complexType>
								<xs:attribute name="something1" type="xs:string" use="required"/>
							</xs:complexType>
						</xs:element>
					</xs:sequence>
					<xs:attribute name="id" type="xs:string" use="required"/>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
	</xs:complexType>
</xs:element>

</xs:schema>
Desire XML Output:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<DataItems>
	<record id="1">
		<columnA name="something1">1</columnA>
		<columnB name="something2">2</columnB>
		<columnC name="something3">3</columnC>
	</record>
	<record id="2">
		<columnA name="something1">4</columnA>
		<columnB name="something2">5</columnB>
		<columnC name="something3">6</columnC>
	</record>
</DataItems>
Based on this table:
id something1 something2 something3
1 1 2 3
2 4 5 6

The actual output (which is wrong):
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<DataItems>
	<record id="1">
		<columnA something1="1"/>
		<columnB something2="2"/>
		<columnC something3="3"/>
	</record>
	<record id="2">
		<columnA something1="4"/>
		<columnB something2="5"/>
		<columnC something3="6"/>
	</record>
</DataItems>