Generating excel file and protecting with password
I had a requriement to copy a data from pagelist to excel.
i had done these using .pyGenerateExcelFile method (.xlsx file is getting generated)but my requirement is like i need to generate an excel with .xls format which i am unable to create.Did there is any change in the template using for .xlsx and .xls?
Another requirement is the generated excel must be password protected. Did we have any activty in pega, that excel can be protected directly while generating an excel file.