Question

4
Replies
349
Views
 Avinash kamtam (Avinashk7175)
TCS

TCS
IN
Avinashk7175 Member since 2015 2 posts
TCS
Posted: February 19, 2016
Last activity: February 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

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 5 years ago
Posted: 19 Feb 2016 4:59 EST
Santanu Bhattacherjee (Santanu)
PEGA
Senior Manager - Sales Automation
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.
Posted: 5 years ago
Posted: 19 Feb 2016 9:52 EST
John Pritchard-Williams (JOHNPW_GCS)
PEGA
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