Question
COGNIZANT TECHNOLOGY SOLUTIONS
US
Last activity: 16 Oct 2018 12:03 EDT
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.
Pegasystems Inc.
IN
It is worth going through:
https://mesh.pega.com/docs/DOC-89988
https://mesh.pega.com/docs/DOC-89449
https://mesh.pega.com/docs/DOC-89784
COGNIZANT TECHNOLOGY SOLUTIONS
US
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!
Pegasystems Inc.
IN
You can aswell look into https://collaborate.pega.com/question/how-read-data-multiple-tabs-excel-sheet
Looks like the similar one
COGNIZANT TECHNOLOGY SOLUTIONS
US
Hey Marissa, I have already updated in the post, the activity which you have shared is not helpful so please share more details. Thank you!
COGNIZANT TECHNOLOGY SOLUTIONS
US
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!
Truviq Systems Private Limited
IN
Hi Varun,
Find the attached document which contains detailed steps to achieve the desired.
Hope this helps !!
Pega Version used: 7.1.9
Thanks,
Srikanth Y.
COGNIZANT TECHNOLOGY SOLUTIONS
US
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
Truviq Systems Private Limited
IN
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.
Truviq Systems Private Limited
IN
Hi VenkataSatyanaraB,
The above method is not working for csv type files.
As mentioned above in one of the comments, you could use pxUploadCSVResults for csv type files.
Hope this helps !
Thanks,
Srikanth Y.
Tech Mahindra
CA
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.
Tech Mahindra
CA
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.