Question
TCS
IN
Last activity: 22 Feb 2016 11:42 EST
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
Pegasystems Inc.
IN
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.
TCS
IN
Email Attachment include the excel sheet where the end user need to update the 2 columns out of 5 columns.
Pegasystems Inc.
IN
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
Pegasystems Inc.
GB
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