How to Linq To Xml ??

[EDN Admin]

Hello, I have a question.<br/>
Sorry, Iâm not good at writing in English.<br/>
How to Linq to Excel Xml??<br/>
Please, let me know. Thanks.
I want Display<br/>
ex) Row 1 , Col1 , Value = value<br/>
Row 1 , Col2 , Value = value<br/>
Row 1 , Col3 , Value = value<br/>
Row 2 , Col1 , Value = value<br/>
Row 2 , Col3 , Value = value
Xml Source
<?xml version="1.0"?><br/>
<?mso-application progid="Excel.Sheet"?><br/>
<Workbook xmlns="urn:schemas-microsoft-comffice:spreadsheet"<br/>
xmlns="urn:schemas-microsoft-comfficeffice"<br/>
xmlns:x="urn:schemas-microsoft-comffice:excel"<br/>
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"<br/>
xmlns:html=" http://www.w3.org/TR/REC-html40 http://www.w3.org/TR/REC-html40 <br/>
<DocumentProperties xmlns="urn:schemas-microsoft-comfficeffice <br/>
<Author>Jun</Author><br/>
<LastAuthor>Jun</LastAuthor><br/>
<Created>2011-05-31T05:02:57Z</Created><br/>
<LastSaved>2011-05-31T05:04:38Z</LastSaved><br/>
<Version>12.00</Version><br/>
</DocumentProperties><br/>
<ExcelWorkbook xmlns="urn:schemas-microsoft-comffice:excel <br/>
<WindowHeight>9855</WindowHeight><br/>
<WindowWidth>17235</WindowWidth><br/>
<WindowTopX>0</WindowTopX><br/>
<WindowTopY>60</WindowTopY><br/>
<ProtectStructure>False</ProtectStructure><br/>
<ProtectWindows>False</ProtectWindows><br/>
</ExcelWorkbook><br/>
<Styles><br/>
<Style ss:ID="Default" ss:Name="Normal <br/>
<Alignment ss:Vertical="Center"/><br/>
<Borders/><br/>
<Font ss:FontName="맑은 고딕" x:CharSet="129" x:Family="Modern" ss:Size="11"<br/>
ss:Color="#000000"/><br/>
<Interior/><br/>
<NumberFormat/><br/>
<Protection/><br/>
</Style><br/>
</Styles><br/>
<Worksheet ss:Name="Sheet1 <br/>
<Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="4" x:FullColumns="1"<br/>
x:FullRows="1" ssefaultColumnWidth="54" ssefaultRowHeight="16.5 <br/>
<Column ss:AutoFitWidth="0" ss:Width="154.5"/><br/>
<Column ss:AutoFitWidth="0" ss:Width="123.75"/><br/>
<Column ss:AutoFitWidth="0" ss:Width="153.75"/><br/>
<Column ss:Index="5" ss:AutoFitWidth="0" ss:Width="159"/><br/>
<Row ss:AutoFitHeight="0 <---Row 1 <br/>
<Cell><Data ss:Type="String A</Data></Cell> <--Col1 <br/>
<Cell><Data ss:Type="String B</Data></Cell> <--Col2 <br/>
<Cell ss:Index="4 <Data ss:Type="String D</Data></Cell> <---Col4 <br/>
</Row> <br/>
<Row ss:Index="3" ss:AutoFitHeight="0 <--Row 3 <br/>
<Cell><Data ss:Type="String A3</Data></Cell> <--Col1 <br/>
<Cell><Data ss:Type="String B3</Data></Cell> <--Col2 <br/>
<Cell><Data ss:Type="String C3</Data></Cell> <--Col3 <br/>
<Cell ss:Index="5 <Data ss:Type="String E3</Data></Cell> <--Col5 <br/>
</Row> <br/>
<Row ss:AutoFitHeight="0 <--Row 4 <br/>
<Cell><Data ss:Type="String A4</Data></Cell> <---Col1 <br/>
<Cell><Data ss:Type="String B4</Data></Cell> <----Col2 <br/>
<Cell><Data ss:Type="String C4</Data></Cell> <--Col3 <br/>
<Cell ss:Index="5 <Data ss:Type="String E4</Data></Cell> <--Col5 <br/>
</Row> <br/>
</Table><br/>
<WorksheetOptions xmlns="urn:schemas-microsoft-comffice:excel <br/>
<PageSetup><br/>
<Header x:Margin="0.3"/><br/>
<Footer x:Margin="0.3"/><br/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/><br/>
</PageSetup><br/>
<Unsynced/><br/>
<Print><br/>
<ValidPrinterInfo/><br/>
<PaperSizeIndex>9</PaperSizeIndex><br/>
<HorizontalResolution>600</HorizontalResolution><br/>
<VerticalResolution>0</VerticalResolution><br/>
</Print><br/>
<Selected/><br/>
<Panes><br/>
<Pane><br/>
<Number>3</Number><br/>
<ActiveRow>3</ActiveRow><br/>
</Pane><br/>
</Panes><br/>
<ProtectObjects>False</ProtectObjects><br/>
<ProtectScenarios>False</ProtectScenarios><br/>
</WorksheetOptions><br/>
</Worksheet><br/>
<Worksheet ss:Name="Sheet2 <br/>
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1"<br/>
x:FullRows="1" ssefaultColumnWidth="54" ssefaultRowHeight="16.5 <br/>
<Row ss:AutoFitHeight="0"/><br/>
</Table><br/>
<WorksheetOptions xmlns="urn:schemas-microsoft-comffice:excel <br/>
<PageSetup><br/>
<Header x:Margin="0.3"/><br/>
<Footer x:Margin="0.3"/><br/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/><br/>
</PageSetup><br/>
<Unsynced/><br/>
<ProtectObjects>False</ProtectObjects><br/>
<ProtectScenarios>False</ProtectScenarios><br/>
</WorksheetOptions><br/>
</Worksheet><br/>
<Worksheet ss:Name="Sheet3 <br/>
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1"<br/>
x:FullRows="1" ssefaultColumnWidth="54" ssefaultRowHeight="16.5 <br/>
<Row ss:AutoFitHeight="0"/><br/>
</Table><br/>
<WorksheetOptions xmlns="urn:schemas-microsoft-comffice:excel <br/>
<PageSetup><br/>
<Header x:Margin="0.3"/><br/>
<Footer x:Margin="0.3"/><br/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/><br/>
</PageSetup><br/>
<Unsynced/><br/>
<ProtectObjects>False</ProtectObjects><br/>
<ProtectScenarios>False</ProtectScenarios><br/>
</WorksheetOptions><br/>
</Worksheet><br/>
</Workbook> <hr class="sig http://vsto.tistory.com

View the full article