PI/XI: Reading MS Excel's XLSX and XLSM files with standard PI modules

[Former Member]

Hello All,

I'm refering at Michal's blog to convert excel sheet into xml file:

It works, I'm able to see all payploads into message, but I don't have any idea how/where I can get the external definitions (XSD) to use with those payloads.

Have you already found a solution and if so can anyone share these external definitions (XSD) file ?

Thanks a lot.

[asdasd_asdasd]

In the comments of is the solution:

"

...

For anyone creating their own xsd: Stop!

You can download the standard here: http://www.ecma-international.org/publications/standards/Ecma-376.htm

You only need Part 1, which contains OfficeOpenXML-XMLSchema-Strict.zip, which in turn contains sml.xsd.

...

"

Best Regards.

[former_member186851]

Hello Luca,

You can try as per the below Link,Structure can be build as per the requirement