Read a list of nodes from xml file

Jan 4 2011 3:38 AM
Hi any please help,

I have a xml file. this look like
<pre lang="xml">&lt;Worksheet ss:Name=&quot;Combined Account Statement&quot;&gt;
-
&lt;Table ss:ExpandedColumnCount=&quot;15&quot; ss:ExpandedRowCount=&quot;96&quot; x:FullColumns=&quot;1&quot; x:FullRows=&quot;1&quot;&gt;</pre>&lt;/Table&gt;&lt;/Workbook&gt;

I want to read the list of nodes from the xml file. I cant find the nodelist. Because of each xml tag have applied styles.

<pre lang="sql">if (xmlDoc.DocumentElement.SelectNodes(&quot;Workbook/Worksheet[ss:Name=&#39;Combined Account Statement&#39;]&quot;).Count &gt; 0)
                  MainNodeList = xmlDoc.DocumentElement.SelectNodes(&quot;Workbook/Worksheet[ss:Name=&#39;Combined Account Statement&#39;]&quot;);</pre>

How can i read the list of nodes form xml files.

Answers (1)