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

16
Replies
2561
Views
varun keshri Member since 2017 12 posts
COGNIZANT TECHNOLOGY SOLUTIONS
Posted: Jul 28, 2017
Last activity: Oct 16, 2018
Closed

How to read data from excel sheet if it has two tabs?

Hello Team,

I have an requirement to read data from excel sheet which has two tabs. Each tab has multiple columns. I have to use file listener to read the data.

Is there any OOTB features? The below URL doesn't help much :-

https://pdn.pega.com/community/pega-product-support/question/how-read-data-multiple-tabs-excel-sheet

Appreciate your quick response!


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

To see attachments, please log in.
Data Integration

Posted: 7 years ago

Well, thank you for sharing the details but unfortunately I m not looking for to extract the data in to excel sheet. 

 

I have an excel sheet which I multiple tabs & I need to read data and load it in DB. How do I do this? File listener rule does this but only for single tab , doesn't work with multiple tabs. Please help! 

To see attachments, please log in.
Posted: 7 years ago

Need to try this, but if you have all ready implemented so can you please share more details? Can I add this flow action in my current flow and it would upload all data ( even data in multiple tabs?)

What's the best way to implement this? Thank you!

To see attachments, please log in.
Posted: 7 years ago

Hi Srikanth,

This is one of the best help ever provided to me. Much appreciated!! 

However, the sample excel sheet attached in the document is not accessible. Could you please share it again. Or upload the document separately? I'm using Pega 7.2.2 and going to try this approach and will update you my further response  

 

To see attachments, please log in.
Posted: 7 years ago

Hi Varun,

Thanks.
Attached the sample excel sheet used in the illustration.
In the sample sheet, I only used two columns. You can add your required columns in the same format as in the sheet.

Regards,
Srikanth Y.

To see attachments, please log in.
Posted: 7 years ago

Hi Srikanth,

I tried by calling pxUploadCSVResults in post-processing activity by passing the values for required parameters. I am getting thesome exception.

I am attaching the screen shots of what i did.

Please help me in resolving the problem. If possible you can share your number.

Regards,

Satya.

To see attachments, please log in.
Posted: 7 years ago

Hi Srikanth,

Thanks a lot for detailed reply.

I did the same as per the attached document. But Still I am getting the error on pyWorkPage of Clipboard.

.pyFileName: Invalid property reference123

Please find the attached file for details. Please share your number.

Regards,

Satya.

 

 

 

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