So, I was thinking to create a Binary File from the .xlsx that I have and call the Base64Encode() function to do this whole process, but I cannot figure out how to convert my file into a Binary File inside Pega.
Can someone give me hints to do that or maybe suggest another approach to create the Base64 string?
After generating the .xlsx file with the MSOGenerateExcelFile, I did a property-set to the pxRequestor.pyFileUpload property. The set value is the pxProcess.pxServiceExportPath (Pega path) + the file name (declared in the MSOGenerateExcelFile).
To finish, I called the function @uploadFile() in a property-set which populated string type property. This property will contain your Base64, File Extension, File Name and File Path.
This @uploadFile() function will look at the file path located in pxRequestor.pyFileUpload, thats why I needed to populate this property after the MSOGenerateExcelFile.