0

I've been spinning in circles trying to get XML data loaded into an Excel worksheet.

I started with transforming the XML into a List of Objects and then iterating that List, outputting each individual row. I discovered some posts that said this was inefficient, however, and abandoned the idea.

I then attempted the XmlImportXml method, but having quite gotten this to work yet. (See Generate XML Schema From XML String)

Are there any other alternatives to loading XML data into an Excel worksheet?

Is there a preferred way to do this?

Community
  • 1
  • 1
vincentvanjoe
  • 767
  • 1
  • 12
  • 23
  • I have edited your title. Please see, "[Should questions include “tags” in their titles?](http://meta.stackoverflow.com/questions/19190/)", where the consensus is "no, they should not". – John Saunders May 27 '14 at 21:10
  • 2
    After some research, I went with the following: http://stackoverflow.com/questions/536636/write-array-to-excel-range – vincentvanjoe May 27 '14 at 22:59

0 Answers0