vincent_w
11-07-2011, 10:37 PM
<root>
<a>111

Name. 

Student Number.

sex 

address. 

</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 
 newline will be remain unparsed, what I want about the text like below :
unparsed:
111

Name. 

Student Number.

sex 

address. 

instead of parsed :
111
Name.
Student Number.
sex 

address.
<a>111

Name. 

Student Number.

sex 

address. 

</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 
 newline will be remain unparsed, what I want about the text like below :
unparsed:
111

Name. 

Student Number.

sex 

address. 

instead of parsed :
111
Name.
Student Number.
sex 

address.