PDA

View Full Version : Import xml to Excel without parsing text or format string in text



vincent_w
11-07-2011, 10:37 PM
<root>
<a>111&#xA;
Name. &#xA;
Student Number.&#xA;
sex &#xA;
address. &#xA;
</a>
<b>333</b>
<c>444</c>
</root>

with this example , I want to import this xml into excel , generally , we make a MSXML2.DOMDocument object will parse everything in the xml , but I want to remain the text format unparsed , I mean all whitespace and &#xA; newline will be remain unparsed, what I want about the text like below :
unparsed:

111&#xA;
Name. &#xA;
Student Number.&#xA;
sex &#xA;
address. &#xA;

instead of parsed :
111

Name.

Student Number.

sex &#xA;

address.

Jan Karel Pieterse
11-08-2011, 12:15 AM
It helps if you show the code...