Discussion

Reading excel file

Hi, I need to read excel file which has property name and type and need to convert it into Pega properties.Is there anyway to do it.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

October 22, 2010 - 9:21am

You can use Apache POI or JExcelAPI to read the excel file. I do not think there is an OOTB functionality for this.

October 23, 2010 - 1:03am

You can use Rule-Template-Excel for this purpose. For reference you can see the excel editor feature present in pega which can be used to add properties to a particular class.

March 7, 2013 - 11:17pm

Hi kalinga,

Can you please let me know how to use this "Rule-Template-Excel" approach to parse the excel file. I am working in PRPC v5.4 SP1 and need to parse xlsx file. Please reply.

August 25, 2015 - 3:23am

Hi,

 

Here is a small article for parsing excel file

 

http://vamshikassety.blogspot.in/2015/08/parse-excel-file.html

 

Vamshi