Question

4
Replies
1071
Views
kangb Member since 2014 5 posts
PEGA
Posted: July 2, 2015
Last activity: July 18, 2017
Closed
Solved

How to read/parse Excel worksheet saved as MHT/MHTML

Our Pega 7 app is using Microsoft Excel files for inbound integration files from United Parcel Service (UPS). They send us files in 3 different versions of Excel, .XLS, .XLSX, and a 3rd hybrd *.XLS file that is actually an HTML document (MHTML)

We are using the Apache POI libraries in our app to read and parse the XLS and XLSX files.

We are unable to read/parse/consume the 3rd file type with the HTML content in an XLS wrapper.

Does anyone have any experience with consuming a MHTML/XLS file in a Peaga 7 app?

***Updated by moderator: Lochan to close post***
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Data Integration
Moderation Team has archived post
Share this page LinkedIn