Skip to main content
Contact a Moderator

Question

1
Replies
696
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
Moderation Team has archived post, 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.
Posted: 5 years ago
Posted: 2 Sep 2016 13:16 EDT
John Pritchard-Williams (JOHNPW_GCS) PEGA Client Support Team Lead
Pegasystems Inc.
GB

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