want to see xml structure in Excel format

[abhay_aggarwal]

Hi All,

Is there any tool by which we can see the xml structure to Excel sheet.

Regards

[former_member208856 · Accepted solution]

Yes, you can download XML file in Excel format.

Goto SXMB_MONI --> Open the payload in that in display mode

Check it is in 2nd window, then click on Export Button for WINDOW2.

Save the file in .xls format.

Now open the file --> it will ask 3 options, choose 2nd option & open file in Excel format with XML Structure & data.

[Former Member]

XMLSpy, can show the xml structure in Excel format

<!--<?xml version="1.0"?>

<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">

<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

<Created>1996-12-17T01:32:42Z</Created>

<LastSaved>2000-11-18T06:53:49Z</LastSaved>

<Version>11.9999</Version>

</DocumentProperties>

<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">

<RemovePersonalInformation/>

</OfficeDocumentSettings>

<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">

<WindowHeight>4530</WindowHeight>

<WindowWidth>8505</WindowWidth>

<WindowTopX>480</WindowTopX>

<WindowTopY>120</WindowTopY>

<AcceptLabelsInFormulas/>

<ProtectStructure>False</ProtectStructure>

<ProtectWindows>False</ProtectWindows>

</ExcelWorkbook>

<Styles>

<Style ss:ID="Default" ss:Name="Normal">

<Alignment ss:Vertical="Bottom"/>

<Borders/>

<Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/>

<Interior/>

<NumberFormat/>

<Protection/>

</Style>

<Style ss:ID="s21">

<Font ss:FontName="Arial Narrow" x:Family="Swiss" ss:Size="12"/>

<Interior ss:Color="#00CCFF" ss:Pattern="Solid"/>

</Style>

<Style ss:ID="s22">

<Font ss:FontName="Arial Narrow" x:Family="Swiss" ss:Size="12"/>

</Style>

</Styles>

<Worksheet ss:Name="Sheet1">

<Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="3" x:FullColumns="1" x:FullRows="1" ss:StyleID="s22" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25">

<Row ss:AutoFitHeight="0">

<Cell ss:StyleID="s21">

<Data ss:Type="String">COL1</Data>

</Cell>

<Cell ss:StyleID="s21">

<Data ss:Type="String">COL2</Data>

</Cell>

<Cell ss:StyleID="s21">

<Data ss:Type="String">COL3</Data>

</Cell>

</Row>

<Row ss:AutoFitHeight="0">

<Cell>

<Data ss:Type="String">A1</Data>

</Cell>

<Cell>

<Data ss:Type="String">B1</Data>

</Cell>

<Cell>

<Data ss:Type="String">C1</Data>

</Cell>

</Row>

<Row ss:AutoFitHeight="0">

<Cell>

<Data ss:Type="String">A2</Data>

</Cell>

<Cell>

<Data ss:Type="String">B2</Data>

</Cell>

<Cell>

<Data ss:Type="String">C2</Data>

</Cell>

</Row>

</Table>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<Unsynced/>

<Print>

<ValidPrinterInfo/>

<PaperSizeIndex>9</PaperSizeIndex>

<HorizontalResolution>300</HorizontalResolution>

<VerticalResolution>300</VerticalResolution>

</Print>

<Selected/>

<Panes>

<Pane>

<Number>3</Number>

<ActiveRow>16</ActiveRow>

<ActiveCol>2</ActiveCol>

</Pane>

</Panes>

<ProtectObjects>False</ProtectObjects>

<ProtectScenarios>False</ProtectScenarios>

</WorksheetOptions>

</Worksheet>

<Worksheet ss:Name="Sheet2">

<Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25"/>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<Unsynced/>

<ProtectObjects>False</ProtectObjects>

<ProtectScenarios>False</ProtectScenarios>

</WorksheetOptions>

</Worksheet>

<Worksheet ss:Name="Sheet3">

<Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25"/>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<Unsynced/>

<ProtectObjects>False</ProtectObjects>

<ProtectScenarios>False</ProtectScenarios>

</WorksheetOptions>

</Worksheet>

</Workbook>-->

Edited by: Eric on Mar 3, 2010 6:59 AM

Edited by: Eric on Mar 3, 2010 7:01 AM

[former_member181985]

>Is there any tool by which we can see the xml structure to Excel sheet.

Is this related to PI?

You can open XML file directly with Excel editor. Internally it converts to Excel cells.

[abhay_aggarwal]

ya praveen this xml structure in moni only...........

this not getting open in excel also saying invaild charecter........

Regards

Edited by: Abahy Aggarwal on Mar 3, 2010 6:04 AM

[former_member181985]

Any mapping failure in PI for this special character, if so check the trace header. Then you can find the invalid character and its position in the payload.

[abhay_aggarwal]

Hi Praveen,

I am not getting that charecter in my XML structure. If you also want to check you can give me ur mail id and I can send it to you.

Regards

[former_member181985]

Abhay, I am not able to understand yourissue.

Is there any error in PI for this payload?

or you just download and open it in excel tool.

You can check my business card for my ID.

Regards,

Praveen Gujjeti.

[former_member200962]

You can check my business card for my ID

Request to the experts not to encourage personal/ email communication:

/thread/670302 [original link is broken]

Regards,

Abhishek.

[former_member200962]

ya praveen this xml structure in moni only...........

this not getting open in excel also saying invaild charecter........

SXMB_MONI -->

Open the desired message processing -->

Payload --> Copy the payload into a Notepad -->

Remove the - sign from the payload (this is the eror) -->

There should be no space before the statement <?xml version="1.0" encoding="UTF-8"?> -->

Save as --> Excel file --> Open ....it will open then.

Regards,

Abhishek.