SAP MII XML to XLST

[nwalter1]

Hi,

is there any way to transform a XML to Excel format and save it? Is there maybe any plugin for it?

Otherwise is it possible to generate a formatted CSV, in correct table form?

Thanks!

[steve_stubbs]

Hi Nico,

You can use the MII XSL Transformaction action and transform an MII RowSet XML object into CSV format using this pre-defined MII XSL reference: server://XMII/Stylesheets/IllumRowsetCSV.xsl.

The list of provided pre-defined MII XSL (referred to as Style Sheets in the documentation) are listed here.

Regards, Steve

[nwalter1]

Hi Steve,

Thanks for you answer!

Is it also possible to do the formatting in MII, so that I have columns and cells already formatted correctly.

Not like this:

A1, „B1“, „C1“

A2, „B2“, „C2“

Etc.

[steve_stubbs]

Hi Nico,

The provided XSL creates all the CSV column values as strings. In order to change this, you would have to copy and modify the XSL to provide whatever value formatting you want.

Regards, Steve