Excel Source Plus

23 views
Skip to first unread message

Mike

unread,
Oct 4, 2022, 11:37:27 PM10/4/22
to COZYROC
Hi, 
I am using "Excel source plus." However, my excel file is dynamic. I used the "Foreach Loop container" to get the file name. How can I configure the WorkSheet name? The sheet name will not change, but I want to pull the data from the second sheet. If I hard code and read one file, it works. When I use "Variable" in Excel source plus connection string, it will error out, and the error is sheet name doesn't exist. 

Any advice?

Ivan Peev

unread,
Oct 5, 2022, 11:28:36 AM10/5/22
to COZYROC
Hi Aqeel,

Starting from 2.0 version, you can reference a sheet by index like that :1

Reply all
Reply to author
Forward
0 new messages