Reading XML outer tables
<p>I have an Xml file as shown below in which if i convert this to Dataset, the dataset will contain 3 tables with talble names Table Name1, Table Name2 and Table Name3 but i want to get this information without converting this to dataset
Basically i want to get all the outer table names out of my excel. Please help me with the piece of code</p>

<pre><code>- &lt;OppFact&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;REVENUE BEFORE REIMBURSEMENTS&lt;/F1&gt; 
  &lt;Level2&gt;Y&lt;/Level2&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transition&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transformation&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Service Delivery&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transition - Nonpayroll/Usage Costs (Capitalised)&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transition - Transfer Costs - PD&amp;S (Capitalised)&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transformation - Payroll (Expensed to P&amp;L)&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transformation - Subcontractors (Expensed to P&amp;L)&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transformation - Nonpayroll/Usage Costs (Expensed to P&amp;L)&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transformation - Transfer Costs - PD&amp;S (Expensed to P&amp;L)&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transformation - Payroll (Capitalised)&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transformation - Subcontractors (Capitalised)&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
  &lt;F1&gt;Transformation - Nonpayroll/Usage Costs (Capitalised)&lt;/F1&gt; 
  &lt;/WK11_x0020_GAAP_x0020_IS_x0020_Detail&gt;
- &lt;Key_x0020_Deal_x0020_Metrics&gt;
  &lt;F1&gt;Cumulative Free Case Flow&lt;/F1&gt; 
  &lt;/Key_x0020_Deal_x0020_Metrics&gt;
- &lt;Key_x0020_Deal_x0020_Metrics&gt;
  &lt;F1&gt;PV of Free Cash Flow&lt;/F1&gt; 
  &lt;/Key_x0020_Deal_x0020_Metrics&gt;
- &lt;Key_x0020_Deal_x0020_Metrics&gt;
  &lt;F1&gt;Cumulative PV of Free Cash Flow&lt;/F1&gt; 
  &lt;/Key_x0020_Deal_x0020_Metrics&gt;
- &lt;Key_x0020_Deal_x0020_Metrics&gt;
  &lt;F1&gt;NPV at 10% Discount Rate&lt;/F1&gt; 
  &lt;/Key_x0020_Deal_x0020_Metrics&gt;
- &lt;Key_x0020_Deal_x0020_Metrics&gt;
  &lt;F1&gt;IRR&lt;/F1&gt; 
  &lt;F3&gt;0.47010270600304682&lt;/F3&gt; 
  &lt;F4&gt;0.60588487732721263&lt;/F4&gt; 
  &lt;/Key_x0020_Deal_x0020_Metrics&gt;
- &lt;Key_x0020_Deal_x0020_Metrics&gt;
  &lt;F1&gt;1st Month of Positive Cumulative Cash Flow&lt;/F1&gt; 
  &lt;/Key_x0020_Deal_x0020_Metrics&gt;
- &lt;Key_x0020_Deal_x0020_Metrics&gt;
  &lt;F1&gt;Peak Negative Cash Flow&lt;/F1&gt; 
  &lt;/Key_x0020_Deal_x0020_Metrics&gt;
- &lt;Direct_x0020_Cash_x0020_Flow&gt;
  &lt;F1&gt;Billings By Phase&lt;/F1&gt; 
  &lt;Level2&gt;Y&lt;/Level2&gt; 
  &lt;/Direct_x0020_Cash_x0020_Flow&gt;
- &lt;Direct_x0020_Cash_x0020_Flow&gt;
  &lt;F1&gt;Transition Billings&lt;/F1&gt; 
  &lt;/Direct_x0020_Cash_x0020_Flow&gt;
- &lt;Direct_x0020_Cash_x0020_Flow&gt;
  &lt;F1&gt;Transformation/Consulting Billings&lt;/F1&gt; 
  &lt;/Direct_x0020_Cash_x0020_Flow&gt;
- &lt;Direct_x0020_Cash_x0020_Flow&gt;
  &lt;F1&gt;Service Delivery Billings&lt;/F1&gt; 
  &lt;/Direct_x0020_Cash_x0020_Flow&gt;
- &lt;Direct_x0020_Cash_x0020_Flow&gt;
  &lt;F1&gt;PMO Billings&lt;/F1&gt; 
  &lt;/Direct_x0020_Cash_x0020_Flow&gt;
- &lt;Direct_x0020_Cash_x0020_Flow&gt;
  &lt;F1&gt;Other Billings&lt;/F1&gt; 
  &lt;/Direct_x0020_Cash_x0020_Flow&gt;
- &lt;WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
  &lt;F1&gt;CURRENT ASSETS&lt;/F1&gt; 
  &lt;Level2&gt;Y&lt;/Level2&gt; 
  &lt;/WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
- &lt;WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
  &lt;F1&gt;Cash and cash equivalents&lt;/F1&gt; 
  &lt;/WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
- &lt;WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
  &lt;F1&gt;Client receivables&lt;/F1&gt; 
  &lt;/WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
- &lt;WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
  &lt;F1&gt;Unbilled services&lt;/F1&gt; 
  &lt;/WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
- &lt;WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
  &lt;F1&gt;Other receivables&lt;/F1&gt; 
  &lt;/WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
- &lt;WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
  &lt;F1&gt;Prepaid &amp; other assets&lt;/F1&gt; 
  &lt;/WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
- &lt;WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
  &lt;F1&gt;TOTAL LIABILITIES / CAPITAL&lt;/F1&gt; 
  &lt;/WK12_x0020_GAAP_x0020_BS_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;NET REVENUES&lt;/F1&gt; 
  &lt;Level2&gt;Y&lt;/Level2&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;Total Revenue Before Reimbursements&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;Total Reimbursements (Pass Through Revenue)&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;Total Reimbursable Expenses (Pass Through Expenses)&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;Total Net Revenues&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;TOTAL COST OF SERVICES&lt;/F1&gt; 
  &lt;Level2&gt;Y&lt;/Level2&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;Payroll&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;Nonpayroll/Usage Costs&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;Transfer Costs - PD&amp;S&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;Transfer Costs - GS/Country&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;Subcontractors&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;Depreciation&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;WK13_x0020_EVA_x0020_Detail&gt;
  &lt;F1&gt;EVA as a Percentage of Revenues before Reimbursements&lt;/F1&gt; 
  &lt;/WK13_x0020_EVA_x0020_Detail&gt;
- &lt;/OppFact&gt;
</code></pre>
