"You must specify a sheet name" even though the sheet name is given

[Vigneswaran]

Hi Team,

Output Data - Tool 
Getting the following error, although the sheet name is specified 

"You must specify a sheet name"

Kindly help!

[ShankerV]

Hi @Vigneswaran 

Can you please share the screenshot of the Output tool configuration.

[Vigneswaran]

[flying008]

Hi, @Vigneswaran 

Maybe your Field [FileName] only have full path for file name, but have not sheet name or range ?

[Vigneswaran]

[ShankerV]

Hi @Vigneswaran 

Please remove the highlighted from your Output tool.

The below setting will work perfectly, I have tried in my desktop.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[Vigneswaran]

same issue persist buddy!

[ShankerV]

Hi @Vigneswaran 

Please find the use case, I have created to test your issue.

The output is as expected, hope this might help to resolve your issue..

I have modified the below setting alone, 

Many thanks

Shanker V

[Solène]

Hello ! 
I have the same problem as @Vigneswaran.

I have the message "You must specify a sheet name" but it is specified.

Did you find the solution ? 

Thank you :) 

[nagakavyasri]

@Vigneswaran @Solène 

Specify sheet: