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.
Accepted Solution
Hi Prashanth,
Attached the sample excel sheets here.
Thanks,
Srikanth.
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.
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
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.