Accessing xlsx in service export directory through activity
I have an excel file stored in the service export directory that I need an activity to access to process when it is run, how would I go about implementing this?
I've seen some posts with similar requirements but they use a PDF instead. I also understand that I have to use PRInputStream? but I am unsure on how the file would be parsed through to the activity and accessed.
Any and all guidance appreciated, thanks!
Pegasystems Inc.
IN
You just want to access the file or parse the file and read the content of the file?
If you just want to access file then using any Java file API methods does it.
If you want to parse the content , read the file and then parse it using APACHE POI API
OCBC
SG
Hi, thanks for your response. I am new to Pega and Java so do correct me if I'm wrong.
My goal right now is to only to be able to access the file from the activity, the logic to process the excel file is already done.
https://support.pega.com/discussion/download-file-server-directory
I was doing some research and I saw the response by Abdul_Razi in the thread above, he passes his PDF file to his activity by setting his parameter PDFDocument to b, his byte object. However, I am still a little confused as to how the activity will receive/read the file though, and I did try to follow his solution but the tools.Activity() line did not seem to call my original activity.
For some context, my current activity uses pxParseExcelFile where FSFileName=pxRequestor.pyFileUpload. I now want to invoke the activity and use it to process a file already in the Service Export Directory instead of one that a user uploads.