Question
Parsing Excel from stream
Hi,
I have an excel saved in DB, while processing it is moved to clipboard. I am trying to parse the excel stream but MSOParseExcelFile takes filename. Is there any OOTB option to parse an Excel stream. I tweaked the MSOParselExcel file to take ByteInputStream but its not working.
Thanks..
I have attached the document which explains what I am doing...I have couple of other performance questions revolving this POC.
Task 1 : Make Excel stream parsing using OOTB.
Task 2 : If excel has 40,000 rows it would be better I load first 500 rows, process them and load next 500. This would reduce the memory usage and ensures it works fine on multiple file processings.
This post is for task 1. Once we figure out the solution for task 1 next work will be on task 2. We have third party libraries like Apache POI which can do both task 1 and task 2. Instead of adding these libraries and build a custom solution in Pega I am thinking to expose Apache POI solution as an integration point for Pega.
Before that I am researching if there is any feasible option in Pega. If Task 1 works, there is a chance to request users to break down the large excel file as an alternate solution for Task2.
Thanks for this.
Can you post the code which sets the variable 'xlFileName' - is that loaded from the Property 'Content'
Can add a logging statement to output (looks correct) base64 content of 'xlFileName'; just to make sure it is correctly loaded.
Thanks; did you double-check that the PARAM 'FSFileName' is being set or not.
Maybe add the following Java or similar and check the PRPC logs after running Activity:
String testParamName="FSFileName";
oLog.infoForced( testParamName+":"+tools.getParamValue(testParamName) );