CODEWITHSUNDEEP
xmlxsdexcel-2007
Rob
Rob

Reputation: 1255

Excel not picking up the XML element

I have the following XML

  <flow>
      <material><mattext fontface="Arial"><p style="white-space: pre-wrap"><font size="11">This is my text content</font></p></mattext>
</material>
    </flow>

When I open it in Excel it picks up 

fontface="Arial"
style="white-space: pre-wrap"
font size="11"

As attributes which I can generate a spreadsheet from

But is dosnt pick up "This is my text content" - which is the important bit

Can I generate some XSD file to deal with this or better yet get excel to render the html code as formatting

Upvotes: 0

Views: 274

Answers (1)

Kasun Gajasinghe
Kasun Gajasinghe

Reputation: 2776

In Excel 2007 (you use this according to the tag), when you open a XML file, it pops up a dialog box asking what to do with the xml file. There's three options. First option is "As an XML table". Choose it. It will say something about schema, just press OK.

It picked up the said content for me. It had four columns which contained,

| Arial | white-space: pre-wrap | This is my text content | 11 |

This should solve your problem. If not, please elaborate the question.

Upvotes: 1

Related Questions