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

 KARTHIK MUTUPURI (@~K~@)
WELLS FARGO

WELLS FARGO
IN
@~K~@ Member since 2016 3 posts
WELLS FARGO
Posted: May 10, 2017
Last activity: Oct 16, 2018
Posted: 10 May 2017 7:06 EDT
Last activity: 16 Oct 2018 12:03 EDT
Closed
Solved

How to pass SheetName to MSOParseExcelFile activity

How to pass SheetName to MSOParseExcelFile activity, suppose if i have 2 sheets then if i want to switch reading data from one sheet to other how to do?

Currently i have a template with 2 sheets, but i have 2 sheets then the sheet 2 info is getting read.

***Updated by moderator: Lochan to add Categories***


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

Posted: 7 years ago
Posted: 11 May 2017 1:50 EDT
Madhuri Koravadi Srinidhi (MadhuriKS)
Virtusa
Madhuri Koravadi Srinidhi
Virtusa
AU

Hi Karthik,

Can you try passing the sheetname to the "ValidateSheet" parameter of the MSOParseExcel activity and check if this suits your requirement?

Thank you

To see attachments, please log in.
Posted: 7 years ago
Posted: 15 May 2017 2:08 EDT
KARTHIK MUTUPURI (@~K~@)
WELLS FARGO

WELLS FARGO
IN

I have tried passing the sheet name to the "ValidateSheet" parameter, but it is not working.

I have 2 tabs on the sheet every time it is talking the latest sheet on the excel that is sheet2 and not switching if i pass the parameter sheet1.

To see attachments, please log in.
Posted: 7 years ago
Posted: 24 Oct 2017 4:47 EDT
Aditya Viswanatha (Aditya Viswanatha)
Accenture
Lead System Architect
Accenture
SG

When passing this parameter with required sheet name it is always throwing column headers mismatch. Even though i uploaded same template file and testing. So please help why this error i'm getting as i'm uploading same template file and all column will match anyway

To see attachments, please log in.
Posted: 6 years ago
Posted: 2 Apr 2018 1:05 EDT
Srikanth Yangali (SrikanthY16686929)
Truviq Systems Private Limited

Truviq Systems Private Limited
IN

Hi Karthik,

Could you check the attached document which can help you in your requirement. 

Thanks,

Srikanth.

To see attachments, please log in.
Posted: 6 years ago
Posted: 2 Apr 2018 6:10 EDT
Sarath Prashanth (Sarath Prashanth)
Rabobank
Lead Pega Developer
Rabobank
SE

Hi Srikanth, 

could please brief on how the data is being read. Cause there not much steps in the InitAttachmentPage and the section . ?  Like how does it diff b/n the two sheets 

Thanks

Sarath.

To see attachments, please log in.
Posted: 6 years ago
Posted: 2 Apr 2018 7:31 EDT
Srikanth Yangali (SrikanthY16686929)
Truviq Systems Private Limited

Truviq Systems Private Limited
IN

Hi Prashanth,

As you can see the embedded sample template file in the attached document which contains two pagelist values in two sheets of excel file.

When we call the MSOParseExcelFile activity, the data in the two sheets will be populated into the respective pages as defined in the sample template.

Hope this is clear.

Thanks,

Srikanth.

 

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