Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

1
Replies
728
Views
 Bangaru Reddy D (BANGARU REDDY) Accenture
Accenture
IN
BANGARU REDDY Member since 2010 1 post
Accenture
Posted: September 2, 2016
Last activity: September 2, 2016
Posted: 2 Sep 2016 11:05 EDT
Last activity: 2 Sep 2016 13:16 EDT
Closed

How to convert excel report data in to xml format

Report

I am trying to convert excel report data in to xml format, if anyone knows information please share to me.

 

Thanks

Bangaru Reddy

***Updated by Moderator: Marissa. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option; updated categories***

Reporting
Posted: 6 years ago
Posted: 2 Sep 2016 13:16 EDT
John Pritchard-Williams (JOHNPW_GCS) Client Support Team Lead
Pegasystems Inc.
GB
Report

You can use Apache POI  (Included in PRPC's Libs OOTB) to navigate through a 'binary' Excel document; and generate your XML this way. [example of going the other way is here : https://mesh.pega.com/docs/DOC-89449 - attached as PDF as well]

If your EXCEL file was generated from PRPC's 'Export To Excel' (from Report Viewer etc) - then actually this is already (almost) XML - it's a HTML format, with one malformed (by XML's strict standards) META TAG; if you remove this TAG, you have the data in HTML table format.....

 

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice