cancel
Showing results for 
Search instead for 
Did you mean: 

Convert XML file into Excel

former_member453678
Participant
0 Kudos

Hi all,

I need to convert my xml file into a excel formatted file.

Could you please guide me through it??

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Anish,

Call the transaction/query with content-type as text/csv.

Regards,

Rohit Negi.

former_member453678
Participant
0 Kudos

Can you please describe the process in detail as i am new to MII.

Former Member
0 Kudos

Hi Anish,


From where is this  XML getting generated?

From a transaction or Query?

And where do you need to send this XML/Excel file?


Regards,

Rohit Negi.

former_member453678
Participant
0 Kudos

Hi Rohit,

XML was generated because of a transaction only.

But now what i want to do is this - -

I have an already created XML file i want the data in it to be shown in an excel file.

Former Member
0 Kudos

Hi Anish,

Create an Xacute query and use the transaction inside this query.

Store the XML in the output parameter in the trasaction.

Map the output parameter of the transaction to the output parameter of the query.

Call the query with this URL:

<protocol>://<Server>:<Port>/XMII/Illuminator?QueryTemplate=<Path of the query>&content-type=text/csv

Note: Make sure that your XML is in MII XML Format i.e. Rowsets, Rowset, Row Format.

Regards,

Rohit Negi.

former_member453678
Participant
0 Kudos

Hi Rohit,

Thank you for explaining in detail.

I might need your help a bit more than i expected.

Actually i created an eXacute Query and also used transaction inside this query which was resulting into xml.

i also stored the XML into the output paramter of transaction properties.

But how do i map the output parameter of transaction to the output parameter of ther query?

Because for this i would need to create a new transaction in which the other transaction properties won't get displayed.

former_member453678
Participant
0 Kudos

Hi Rohit

I got what you were trying to say.

I did generate an excel file.

Thank you for replying.

Have a nice day. .

Answers (1)

Answers (1)

0 Kudos

Anish,

To layer onto the discussion and outline a few options for you around SAP & Microsoft Office integration....

You can always look at it the other way around and ask yourself how to get data into Excel using MII as the source.  Have a look at these links around how to re-use the MII Query templates to drive data into the Office environment on demand:

Also, have a look at this as another option to re-use an HTML 5 component from Microsoft to render your MII Query data (populated into an HTML table using an XSLT) using only a few lines of HTML code:

The Excel Button - Bringing Excel Everywhere | Office Blogs

This provides a more robust interface than the CSV export does, but CSV is still a valid option and has been used many times in the past.

Hope this helps,

Sam