Question
Marking the columns in Excel sheet as Read only Fields
We have a requirement , need to generate the excel from pega with a read only columns
Email Attachment include the excel sheet where the end user need to update the 2 columns out of 5 columns.
Hi Avinash,
I dont think it is possible to do from PEGA.
This can be done from excel . Details here :https://support.office.com/en-us/article/Password-protect-worksheet-or-workbook-elements-dbf706e0-ba22-4a08-84d8-552db16eef11
Hi Avinash,
Take a look at this document: Transforming Data. Building Stuff In the Model. Utilizing Java APIs.... which shows one way of using Apache POI to create an Excel File.
You should be able to modify the code which generates the document so that it makes columns read-only - I haven't tried this though.
This StackOverflow post should help: http://stackoverflow.com/questions/8502552/make-column-as-read-only-using-apache-poi
Thanks,
John
Hi Avinash,
What is the motive behind it ? If making the columns read only is the only intention then i would suggest you to try Export to PDF rather than Excel.