on 09-23-2014 5:34 AM
Hi all,
I need to convert my xml file into a excel formatted file.
Could you please guide me through it??
Hi Anish,
Call the transaction/query with content-type as text/csv.
Regards,
Rohit Negi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.