Close popover
Satish Tripathi (PERKSATISH)
JP Morgan Chase

JP Morgan Chase
PERKSATISH Member since 2013 5 posts
JP Morgan Chase
Posted: August 11, 2017
Last activity: August 11, 2017

SpreadsheetXML not getting exported as Excel

What I have done:

1) created an xml stream and mapped with the source pagelist to create xml.

2) Property set xml is done in the activity

3) next step of activity, below java code:

ClipboardPage objHeadersPage = tools.findPage("pxRequestor").getProperty(".pyHTTPResponseHeaders").getPageValue();

objHeadersPage.putString("contentType" ,"application/");

objHeadersPage.putString("ContentDisposition" ,"attachment;filename=ExportData.xml");

4) The wrapper xml with the below content type is called.

<?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?>

The ExportData.xml is creaed but directly doesn't open in excel. There is a confirm box to confirm to open xml data in excel then only it opens in excel.

***Edited by Moderator Marissa to update categories***

Data Integration Reporting
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.