Hi all,
I am using the Excel plugin to add password into excel file, but there is a issue when I try to export the excel file.
I would like to ask how to export the excel file inside the server action, there is no export file under "Workbook_Protect" function.
I am using:
https://www.outsystems.com/forge/Component_Documentation.aspx?ProjectId=1044&ProjectName=excel-package
Please help, thanks
Hi Jack,
You need to use output as binary data and use this binary data in screen action to download.
Hope this will help you.
Regards
Rahul Sahu
Rahul Sahu wrote:
Hi Rahul, thank you for your reply. Could you please let me know what you have set inside the "Assign - TemplateExcel".
Thanks
"Assign - TemplateExcel" hold data of TemplateRLtoExcel
After TemplateRLtoExcel you've got to feed the xls-binary to action Workbook_Open_BinaryData to get the Workbook object. This Workbook is then used in Workbook_Protect. After that you get the Xlsx binary with Workbook_GetBinaryData. This is the binary that you download.
Goodluck!
Lennart Kraak wrote:
Thank you Lennart, it really work for me~
Hi Jack
Isn't the answer from Lennart the solution to your question?
Regards,
Daniel
For Generating the Excel using Password, I have Used Advanced Excel Extension to Create the Workbook and write all the data's from the our Source and Generate the Excel with the Protect password.
I have attached the OML for the Excel Generation Protected with Password.
I have attached the Sample URL to tryhttps://vidya-sri.outsystemscloud.com/GenerateExcelUsingAdvanceExcel/
And also I have attached the OML for you reference.
Thanks,
Vidya.U