MSOParseExcelFile takes longer while parsing large excel content
Using MSOParseExcelFile OOTB activity to parse excel contents and map it to clipboard.
When there are more records > 10.000 rows in excel , system takes more than 5 mins to parse the file.
Analysed with PLA to identify the step taking more time. Observed that Java Step-3 which calls OOTB functions for parsing taking more time.
Is there any way to optimise the java execution ?
Thanks in Advance.
***Updated by Moderator: Vidyaranjan| Included Categories***
Pegasystems Inc.
IN
If the number of row is high the you will surely face performance issue. The optimization could be to identify the size of the excel size before uploading and if possible split the huge file using custom Java ( Apache POI )
Something similar is also discussed here
Pegasystems Inc.
GB
Note: 10,000 properties on a single Clipboard isn't recommended in any case (there is even a special Alert for this condition : https://collaborate.pega.com/discussion/si-framework-upgrade-impact-understanding )
Pegasystems Inc.
US
Apache POI is what you need, as Santanu suggests. Performance beyond reading 30 Excel rows and mapping to cliboard every second suggest will require some bulk-data streaming.
https://examples.javacodegeeks.com/core-java/writeread-excel-files-in-java-example/