Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Avinash kamtam (Avinashk7175) TCS
TCS
IN
Avinashk7175 Member since 2015 2 posts
TCS
Posted: Feb 19, 2016
Last activity: Feb 22, 2016
Posted: 19 Feb 2016 3:35 EST
Last activity: 22 Feb 2016 11:42 EST
Closed
Solved

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

To see attachments, please log in.
Data Integration

Posted: 8 years ago
Posted: 19 Feb 2016 4:59 EST
Santanu Bhattacherjee (Santanu) Senior Manager, Cloud Engineering, Management Plane Services
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.

To see attachments, please log in.
Posted: 8 years ago
Posted: 19 Feb 2016 9:52 EST
Santanu Bhattacherjee (Santanu) Senior Manager, Cloud Engineering, Management Plane Services
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

To see attachments, please log in.
Posted: 8 years ago
Posted: 19 Feb 2016 9:52 EST
John Pritchard-Williams (JOHNPW_GCS) Client Support Team Lead
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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice