Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Consider the following XML structure:

<ROOT>
  <Data>
    <Table1>
      <Row>
        <Column1>data1</Column1>
        <Column2>data2</Column2>
        <Column3>data3</Column3>
      </Row>
    </Table1>
    <Table2>
      <Row>
        <Column1>data1</Column1>
        <Column2>data2</Column2>
        <Column3>data3</Column3>
      </Row>
    </Table2>
    <Table3>
      <Row>
        <Column1>data1</Column1>
        <Column2>data2</Column2>
        <Column3>data3</Column3>
      </Row>
    </Table3>
  </Data>
</ROOT>

Is it possible to have the Table1, Table2, and Table3 nodes opened up in their own worksheets inside Excel?

share|improve this question
    
You will need to write a macro to do this. It is possible. –  wbeard52 Aug 1 '12 at 1:24
    
@wbeard52, I was afraid of that. I guess I was just hoping there was a non-macro approach I was missing. Thanks! –  Jason Aug 1 '12 at 16:46
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.