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

 lakhan khandelwal (lakhank7)
Nagarro Inc
Staff Engineer
Nagarro Inc
IN
lakhank7 Member since 2018 10 posts
Nagarro Inc
Posted: Nov 15, 2023
Last activity: Nov 21, 2023
Posted: 15 Nov 2023 9:41 EST
Last activity: 21 Nov 2023 9:22 EST
Closed

Excel file empty while parsing

Hi , 

 

I am trying to parse a excel file using pxParseExcelfIle and I want to log an error in case the file is empty. 

Is there any OOTB function or any java code so that we can identify whether the excel while is empty or not?

 

 

***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Pega Platform 8.7.3
Pega Platform
User Experience
Case Management
Java and Activities
Data Integration
Senior System Architect

Posted: 2 years ago
Posted: 19 Nov 2023 10:11 EST
Yogesh Pal (kumay2)
Pegasystems Inc.
System Architect
Pegasystems Inc.
IN

@lakhank7 After parsing an excel if the file contains no data then by using a function @lengthofPagelist is greater then zero on pxResults page can set a customised error. or if you want to validate the uploaded excel file have correct template then need to write java code. pxParseExcelfIle can't validate the template

To see attachments, please log in.
Posted: 2 years ago
Posted: 21 Nov 2023 9:22 EST
lakhan khandelwal (lakhank7)
Nagarro Inc
Staff Engineer
Nagarro Inc
IN

@kumay2

If the excel file is empty then pxresults will have pxobjclass after parsing. so how can we throw error?

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