Unable to get excel file name from Folder

Learn Academy Feedback
1

hi,
i am trying to read each excel from folder and convert it into a data table. but the problem is i am getting complete folder path instead of excel file name so that i am getting an error in read range activity.
please find the attachedExcelFileName screen shot which i am getting.

2

On which activity you are getting error?
Excel Application scope will not throw error if you pass full path of excel

3

Hi @sunilraju
To answer your question.
To get the file name use.

path.getfilename("completepath")

This will provide you file name with extension.

  1. If you are having issue in read range activity it might be some other issue.
    Request you to share error message.
4

Hi,
Check this workflow
Main.xaml (6.2 KB)

Hope this may help you :slightly_smiling_face: