Member Avatar for vt10000

Hi. In short I have an excel sheet with data in format similar to below:

Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8
ABC ASDF $255 5500 220 1499 $222 1200

what is needed for the final output file is something with hierarchy such as this:

<top>
<secondLevel>
<Column1>ABC
<Column2>ASDF
<Column3>$255</Column3>
<Column4>5500</Column4>
<Column5>220</Column5>
<Column6>1499</Column6>
<Column7>$222</Column7>
<Column8>1200</Column8>
</Column2>
</Column1>
</secondLevel>
</top>

Any idea how can I create/define the necessary XSD that would automate this type of export without complaining and keeping the hierarchy described above?

TIA

Alex

  • 2 Contributors
  • 1 Reply
  • 125 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by tgreer
Member Avatar for tgreer

Excel isn't XML.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.