Skip to main content

Question

 Prabhakaran Balasubramaniam (PrabhakaranB)
Accenture
Senior Analyst
Accenture
IN
PrabhakaranB Member since 2016 3 posts
Accenture
Posted: Jul 19, 2021
Last activity: Aug 31, 2022
Posted: 19 Jul 2021 6:17 EDT
Last activity: 31 Aug 2022 10:31 EDT
Solved

Unable to read data from excel sheet when file type is .xls in pega 8.6

I tried using ootb activity pxParseExcelFile.It works of .xlsx format files but when i try using .xls file it is not working.

***Edited by Moderator: Pooja Gadige to change category from Upgrade to Product, add platform capability ta***
To see attachments, please log in.
Pega Platform 8.6
Data Integration

  • Reply

Accepted Solution

Posted: 2 years ago
Updated: 2 years ago
Posted: 27 Jun 2022 8:05 EDT
Updated: 31 Aug 2022 10:31 EDT
Marije Schillern (MarijeSchillern)
MOD
Senior Knowledge Management Specialist
Pegasystems Inc.
GB

@DadiM827 I provided a response in your post OOTB activity pxParseExcelFile and MSOPaseExcelFile.It works of .xlsx format but not for xls that you logged today.

Please check the documentation which states only .csv and .xlsx is supported.

 

To see attachments, please log in.

Accepted Solution

Posted: 2 years ago
Updated: 2 years ago
Posted: 27 Jun 2022 8:05 EDT
Updated: 31 Aug 2022 10:31 EDT
Marije Schillern (MarijeSchillern)
MOD
Senior Knowledge Management Specialist
Pegasystems Inc.
GB

@DadiM827 I provided a response in your post OOTB activity pxParseExcelFile and MSOPaseExcelFile.It works of .xlsx format but not for xls that you logged today.

Please check the documentation which states only .csv and .xlsx is supported.

 

To see attachments, please log in.

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