Discussion

Parse Excel spread sheet in PRPC

In PRPC v5.5, is it possible to parse complex microsoft excel spreadsheet which contains formulas also. If yes, what are the steps?

**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

March 31, 2010 - 1:20pm

Hi,
Get the jar files for org.apache.poi.hssf.usermodel.
It contains all the methods to read the worksheet, row and cell

Put the data of each row into a pagelist. Here seperate each cell data with a delimiter
Create a parse rule
For each embedded page,call Apply-Parse-Delimited method by passing the source property(which is the above pagelist property) and delimeter rule.

August 25, 2015 - 8:46am

HI,

 

We are facing problem parsing Excel file with formulas. It extracts cell value in excel along with formula. Any help will be greatly appreciated.

 

Regards,

Sarjak