Anyone can tell me why this error is come
This is my workflow
Merge.xaml (13.5 KB)
You are reading the excel file using Read Range workbook activity. That excel file doesn’t have the sheet you are trying to read. Check the sheet is exist in the excel file or not before executing the bot.
Hope it helps!!
sheet name which is i have give is correct
Check if there is any extra space in the sheet name.
Hi,
if you connect with onedrive first pause that then you run the process
You are iterating the each excel file in the folder. Check the same sheet name exist in all the filtered files. If not Might be there is any space before or after the sheet name… @yogitagaikwad2206
This my files only output file don’t have sheet name “MIS Report”
You output excel file doesn’t contain the sheet name you mentioned earlier so that’s the reason you are facing that error.
So to neglect that error we have 2 process:
1st process:
Within For Each File in Folder place an If condition and give the condition as
CurrentFile.Name.Contains("Output")
Leave the then block as empty and place the read range and the merge data table activities in the else block.
2nd process:
You can use an try catch and place the read range and the merge data table in the try block and in the catch block create an System.Exception and in that place an log message and just give as exception.message
So by either using any of the flow mentioned above you can neglect that error
Regards
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.